违法和不良信息举报 联系客服
免费注册 登录

You execute the following PL/SQL:Which two statements are tr

题目
多选题
You execute the following PL/SQL:Which two statements are true?（）
A

Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed.

B

FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed.

C

FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.

D

FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Examine the SQL statements that creates ORDERS table:For which columns would an index be automatically created when you execute the above SQL statement? ()

A. SER_NO

B. ORDER_ID

C. STATUS

D. PROD_ID

E. ORD_TOTAL

F. Composite index on ORDER_ID and ORDER_DATE


参考答案：A, F

第2题：

Which of the following servers would execute SQL？（）

  • A、 Database Server
  • B、 DNS Server
  • C、 NAS Server
  • D、 Web Server

正确答案:A

第3题：

Which of the following statements about ORACLE is (are) correct?

Ⅰ.ORACLE follows SQL standard

Ⅱ.ORACLE database defines two logical types: table and view

A．Ⅰonly

B．Ⅱ only

C．Ⅰ and Ⅱ

D．none of the above


正确答案：C

第4题：

You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）

  • A、Library cache 
  • B、Row cache
  • C、Dictionary cache 
  • D、Large area 
  • E、Buffer cache

正确答案:B

第5题：

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

第6题：

You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute thefollowing script:SQL > @utlrp.sqlWhich two actions does the script perform?()

A. Parallel compilation of only the stored PL/SQL code

B. Sequential recompilation of only the stored PL/SQL code

C. Parallel recompilation of any stored PL/SQL code

D. Sequential recompilation of any stored PL/SQL code

E. Parallel recompilation of Java code

F. Sequential recompilation of Java code


参考答案：C, E

第7题：

You have forgotten the name of binary PL/SQL library saved to the operating system. This file contains the PL/SQL constricts you created for the inventory report. For which file extension should you reach?（）

  • A、 .SQL 
  • B、 .PLL 
  • C、 .PLD
  • D、 .PRT

正确答案:B

第8题：

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

第9题：

Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem？（）

  • A、 functions
  • B、 package
  • C、 procedure
  • D、 database trigger
  • E、 anonymous PL/SQL block

正确答案:D

第10题：

You execute the following command to enable a session in resumable mode：  SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60；  What is the impact of a timeout on the statements being suspended？（） 

  • A、The statements remain suspended for at least 60 seconds.
  • B、The statements are suspended for 60 seconds and then they are executed.
  • C、The suspended statements error out if the problem is not rectified within 60 seconds.
  • D、The statements are automatically suspended 60 seconds after an error is received， and then attempt toexecute normally again.

正确答案:C

更多相关问题
相关内容