Q1. A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:

There is enough free space in the disk group for mirroring to be done.

What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?

A. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.

B. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.

C. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated. 

D. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.

E. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed. 

View Answer

Q2. Which three statements are true about using flashback database in a multitenant container database (CDB)?

A. The root container can be flashed back without flashing back the pluggable databases (PDBs).

B. To enable flashback database, the CDB must be mounted. 

C. Individual PDBs can be flashed back without flashing back the entire CDB. 

D. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB. 

E. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

View Answer

Q3. Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:

1.Create a policy to capture the privilege used by a user for privilege analysis.

2.Generate a report with the data captured for a specified privilege capture.

3.Start analyzing the data captured by the policy.

4.Revoke the unused privileges.

5.Compare the used and unused privileges’ lists.

6.Stop analyzing the data. 

Identify the correct sequence of steps.

A. 1, 3, 5, 6, 2, 4

B. 1, 3, 6, 2, 5, 4

C. 1, 3, 2, 5, 6, 4

D. 1, 3, 2, 5, 6, 4

E. 1, 3, 5, 2, 6, 4

View Answer

Q4. What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE” statement?

A. It will create a multitenant container database (CDB) with only the root opened. 

B. It will create a CDB with root opened and seed read only.

C. It will create a CDB with root and seed opened and one PDB mounted. 

D. It will create a CDB that must be plugged into an existing CDB. 

E. It will create a CDB with root opened and seed mounted. 

View Answer

Q5. Which two statements are true about the RMAN validate database command?

A. It checks the database for intrablock corruptions.

B. It can detect corrupt pfiles.

C. It can detect corrupt spfiles.

D. It checks the database for interblock corruptions.

E. It can detect corrupt block change tracking files.

View Answer

Q6. Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX?

A. Thread creation must be routed through a dispatcher process

B. The local listener may spawn a now process and have that new process create a thread

C. Each Oracle process runs an SCMN thread. 

D. Each multithreaded Oracle process has an SCMN thread. 

E. The local listener may pass the request to an existing process which in turn will create a thread. 

View Answer

Q7. 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?

A. It succeeds because the PDB_ADMIN user has the required privileges.

B. It fails because common users are unable to use the SET CONTAINER statement.

C. It fails because local users are unable to use the SET CONTAINER statement.

D. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

View Answer

Q8. What are three purposes of the RMAN “FROM” clause?

A. to support PUSH-based active database duplication

B. to support synchronization of a standby database with the primary database in a Data environment

C. To support PULL-based active database duplication

D. To support file restores over the network in a Data Guard environment

E. To support file recovery over the network in a Data Guard environment

View Answer

Q9. In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation.

How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?

A. It collects data from SGA and compares it with a preserved snapshot.

B. It collects data from SGA, analyzes it, and provides a report.

C. It collects data from SGA and compares it with the latest snapshot.

D. It collects data from both SGA and PGA, analyzes it, and provides a report.

View Answer

Q10. You database is running an ARCHIVELOG mode.

The following parameter are set in your database instance: 

LOG_ARCHIVE_FORMAT = arch+%t_%r.arc 

LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ 

DB_RECOVERY_FILE_DEST_SIZE = 50G

DB_RECOVERY_FILE = ‘/u01/oradata’

Which statement is true about the archived redo log files?

A. They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.

B. They are created only in the Fast Recovery AreA. 

C. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.

D. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.

View Answer