You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.Which two are possible if table updates are performed which affect the invisible index columns? (Choose two.)
In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container:Which two statements are true? (Choose two.)
The persistent configuration settings for RMAN have default for all parameters.Identify four RMAN commands that produce a multi-section backup.
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:SQL > SHUTDOWN IMMEDIATE -SQL > STARTUP MOUNT -SQL > FLASHBACK DATABASE to TIME "TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)";Examine following commands:1. ALTER PLUGGABLE DATABASE ALL OPEN;2. ALTER DATABASE OPEN;3. ALTER DATABASE OPEN RESETLOGS;Which command or commands should you execute next to allow updates to the flashback back schema?
Examine the commands executed to monitor database operations:$> conn sys oracle/oracle@prod as sysdbaSQL > VAR eid NUMBER -SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (batch_job , FORCED_TRACKING => Y);Which two statements are true? (Choose two.)
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?
