The current system change number (SCN) for a live database is 663571.You decide to use the FLASHBACK TABLE statement to flash back the CUSTOMERS table to SCN 662116.After flashing back the CUSTOMERS table, you query it and decide to undo the effects of the FLASHBACK TABLE command.Which is the fastest way to do this?
Examine the following command:CREATE TABLE (prod_id number(4),Prod_name varchar2 (20),Category_id number(30),Quantity_on_hand number (3) INVISIBLE);Which three statements are true about using an invisible column in the PRODUCTS table?
Which two statement are true about the installation modes in Oracle Database 12c? (Choose two.)
You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements:SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;For which database users is the audit policy now active?
On your Oracle 12c database, you invoked SQL*Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:$> sqlldr hr/hr@pdb table=employeesWhich two statements are true regarding the command? (Choose two.)
Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)
