Oracle认证考试

You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（

题目

You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（）

  • A、Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.
  • B、Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.
  • C、Data is never redacted for the EMP_V.SAL column.
  • D、Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.
  • E、Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.
如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You have an SQL query that takes one minute to execute. You use the following code segment to execute theSQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader()You need to execute a method named DoWork() that takes one second to run while the SQL query is executing.DoWork() must run as many times as possible while the SQL query is executing.Which code segment should you use?（）

A.

B.

C.

D.


参考答案：B

第2题：

To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:The blocks of code execute successfully; however, you do not get the required outcome. What could be the reason?（）

A. A template needs to be associated with the task.

B.A workload needs to be associated with the task.

C. The partial or complete workload scope needs to be associated with the task.

D. The type of structures (indexes, materialized views, or partitions) to be recommended need to be specified for the task.


参考答案：B

第3题：

A piece of ( ) music will make you happy.

A、pleased

B、merry

C、glad

D、fond


参考答案：B

第4题：

You plan to execute the following command to perform a Flashback Database operation in your database：   SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）；   Which two statements are true about this？（）

  • A、 The database must have multiplexed redo log files
  • B、 The database must be in the MOUNT state to execute the command
  • C、 The database must be in the NOMOUNT state to execute the command
  • D、 The database must be opened in RESTRICTED mode before this operation
  • E、 The database must be opened with the RESETLOGS option after the flashback operation

正确答案:B,E

第5题：

You are troubleshooting a WAN connection for TestKing, and on the router you execute the, "debug ppp authentication" command, and view the following output:What kind of handshake was used for the PPP authentication?（）

A. one-way

B. two-way

C. three-way

D. No handshakes required during authentication

E. None of the above


参考答案：C

第6题：

View the Exhibit and examine the output.You execute the following RMAN command to perform the backup operation:What is the multiplexing level in the preceding backup process()

A. 4

B. 8

C. 7

D. 0


参考答案：A

第7题：

is NOT a concept of White Box Testing.

A．You should execute all logical decisions on their tree and false sides.

B．You should execute all independent paths within a module at least once.

C．You should execute all loops at their boundary conditions.

D．You should execute all interfaces at their boundary conditions.


正确答案：D

第8题：

— ______— Oh, it's a piece of cake、I love writing.

A、Do you like the writing class

B、How do you feel about your writing class

C、have another piece of cake

D、Could you help me


参考答案：B

第9题：

This piece of （） is long enough for you to make a shirt.

Acloth

Bclothes

Cclothing

Dsuit


A
略

第10题：

Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

  • A、 when you change the name of a datafile
  • B、 when you drop a table from the database
  • C、 when you take an export of the database
  • D、 when you back up the database using OS utilities
  • E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
  • F、 when you issue a BACKUP command from inside the RMAN run block

正确答案:A,E,F

更多相关问题
相关内容