You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements:What is the result of the last SET CONTAINER statement and why is it so?
Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:What are three possible causes for the latch-related wait events?
You enabled an audit policy by issuing the following statements:SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;For which database users and for which executions is the audit policy now active? Select two.
A redaction policy was added to the SAL column of the SCOTT.EMP table:All users have their default set of system privileges.For which three situations will data not be redacted? (Choose three.)
What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled?
Examine the parameters for your database instance:You execute the following command:SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;Which statement is true in this scenario?
