单选题You execute the following commands to audit database activities: SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about th

题目

单选题

You execute the following commands to audit database activities: SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?（）

One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.

One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.

One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.

One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.

One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.

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

相似问题和答案

第1题：

To make audit information more productive， the DBA executes the following command before startingan audit operation： SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase（）

A、It contains only the plan for the SQL statement executed by the user.
B、It contains the SQL text executed by the user and the bind variables used with it.
C、It contains the plan and statistics associated with the SQL statement executed by the user.
D、It contains the plan for the SQL statement executed by the user and the bind variables used with it.

正确答案:B

第2题：

Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）

A、It releases the storage space used by the table.
B、It does not release the storage space used by the table.
C、You can roll back the deletion of rows after the statement executes.
D、You can NOT roll back the deletion of rows after the statement executes.
E、An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
F、You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

正确答案:A,D,F

第3题：

Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? ()

A. It releases the storage space used by the table.

B. It does not release the storage space used by the table.

C. You can roll back the deletion of rows after the statement executes.

D. You can NOT roll back the deletion of rows after the statement executes.

E. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.

F. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

参考答案：B, D, F

第4题：

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.

正确答案:A,B

第5题：

You execute the following command to audit the database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command？（）

A、One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
B、One audit record is created for every session when any user successfully drops a table owned by SCOTT.
C、One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
D、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
E、One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

正确答案:A

第6题：

You execute the following command to audit database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）

A、One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.
B、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.
C、One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.
D、One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
E、One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT

正确答案:C

第7题：

Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered SQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL> DROP TABLE emp； Table dropped. What happens in this scenario？（）

A、The table is moved to the SYSAUX tablespace.
B、The table is moved to the SYSTEM tablespace.
C、The table is removed from the database permanently.
D、The table is renamed and remains in the TBSFD tablespace.

正确答案:D

第8题：

You are connected to a pluggable database (PDB) as a common user with DBA privileges.The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE;Which is true about the result of this command?（）

A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.

B. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.

C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.

D. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.

参考答案：C

第9题：

Which three statements are true regarding the fine/x7fgrained auditing （FGA）？（）

A、FGA is possible on SELECT statements only.
B、The audit trail for FGA is stored in the FGA_LOG$ table.
C、The audit trail for FGA is stored in the AUD_LOG$ table.
D、FGA enables a SQL predicate to define when to audit an event.
E、FGA audits DELETE statements only when audit columns are specified.
F、FGA includes the SQL statement used by the user as part of the audit event entry.

正确答案:B,D,F

第10题：

You executed the following commands： SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false； SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）； SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）； Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session？（）

A、 The statistics are stored in the pending statistics table in the data dictionary.
B、 The statistics are treated as the current statistics by the optimizer for all sessions.
C、 The statistics are treated as the current statistics by the optimizer for the current sessions only.
D、 The statistics are temporary and used by the optimizer for all sessions until this session terminates.

正确答案:A

单选题You execute the following commands to audit database activities: SQL ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the

题目

相似问题和答案

更多相关问题

相关内容