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?

• A.Only 1
• B.Only 2
• C.Only 3
• D.3 and 1
• E.1 and 2

Comment: *

Name: *

Email: *

Verification: *

Which three operations can be performed as multipartition operations in Oracle? (Choose three.)

• A.Merge partitions of a list partitioned table
• B.Drop partitions of a list partitioned table
• C.Coalesce partitions of a hash-partitioned global index.
• D.Move partitions of a range-partitioned table
• E.Rename partitions of a range partitioned table
• F.Merge partitions of a reference partitioned index

Comment: *

Name: *

Email: *

Verification: *

Examine the parameters for your database instance:

Which three statements are true about the process of automatic optimization by using cardinality feedback? (Choose three.)

• A.The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
• B.The optimizer can re optimize a query only once using cardinality feedback.
• C.The optimizer enables monitoring for cardinality feedback after the first execution of a query.
• D.The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
• E.After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

Comment: *

Name: *

Email: *

Verification: *

Examine the following command:
SQL> DBMS_STATS. SET_TABLE_PREFS ('SH', 'CUSTOMERS', 'PUBLISH', 'false');
What is the effect of executing this command?

• A.Statistics subsequently gathered on theCUSTOMERStable are stored as pending statistics.
• B.Statistics for theCUSTOMERStable are locked and cannot be overwritten.
• C.Existing statistics for theCUSTOMERStable become unusable for the query optimizer.
• D.Automatic statistics collection is stopped for theCUSTOMERStable.

Comment: *

Name: *

Email: *

Verification: *

Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in
ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container.
The steps to recover the tablespace are as follows:
1. Mount the CDB.
2. Close all the PDBs.
3. Open the database.
4. Apply the archive redo logs.
5. Restore the data file.
6. Take the SYSAUX tablespace offline.
7. Place the SYSAUX tablespace online.
8. Open all the PDBs with RESETLOGS.
9. Open the database with RESETLOGS.
10. Execute the command SHUTDOWN ABORT.
Which option identifies the correct sequence to recover the SYSAUX tablespace?

• A.6, 5, 4, 7
• B.10, 1, 2, 5, 8
• C.10, 1, 2, 5, 4, 9, 8
• D.10, 1, 5, 8, 10

Comment: *

Name: *

Email: *

Verification: *