Q1. You must track all transactions that modify certain tables in the sales schema for at least three years.

Automatic undo management is enabled for the database with a retention of one day. 

Which two must you do to track the transactions?

A. Enable supplemental logging for the database.

B. Specify undo retention guarantee for the database.

C. Create a Flashback Data Archive in the tablespace where the tables are stored. 

D. Create a Flashback Data Archive in any suitable tablespace.

E. Enable Flashback Data Archiving for the tables that require tracking.

View Answer

Q2. You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema. 

Examine the following steps:

1.Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (‘SH’, ‘CUSTOMERS’) FROM dual statement.

2.Execute the DBMS_STATS.SEED_COL_USAGE (null, ‘SH’, 500) procedure.

3.Execute the required queries on the CUSTOMERS table.

4.Issue the SELECT DBMS_STATS.REPORT_COL_USAGE (‘SH’, ‘CUSTOMERS’) FROM dual statement.

Identify the correct sequence of steps.

A. 3, 2, 1, 4

B. 2, 3, 4, 1

C. 4, 1, 3, 2

D. 3, 2, 4, 1

View Answer

Q3. Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.

A user issues a query on a table on one of the PDBs and receives the following error: ERROR at line 1:

ORA-01565: error in identifying file ‘/u01/app/oracle/oradata/CDB1/temp01.tmp’ 

ORA-27037: unable to obtain file status

Identify two ways to rectify the error.

A. Add a new temp file to the temporary tablespace and drop the temp file that that produced the error.

B. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.

C. Take the temporary tablespace offline, recover the missing temp file by applying redo logs, and then bring the temporary tablespace online.

D. Shutdown the database instance, restore and recover the temp file from the backup, and then open the database with RESETLOGS.

E. Shut down the database instance and then restart the CDB and PDBs.

View Answer

Q4. 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

Q5. In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?

Both local and global partitioned B-tree Indexes are defined on the table.

A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.

Minimal disrupt ion to availability is required. 

Which three statements are true about this requirement?

A. The partitions can be moved online to new tablespaces.

B. Global indexes must be rebuilt manually after moving the partitions.

C. The partitions can be compressed in the same tablespaces.

D. The partitions can be compressed in the new tablespaces.

E. Local indexes must be rebuilt manually after moving the partitions.

View Answer

Q6. In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute the following command from the root container:

SQL > REVOKE create table FROM C # # A_ADMIN; 

What is the result?

A. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.

B. It fails and reports an error because the CONTAINER=ALL clause is not used. 

C. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.

D. It fails and reports an error because the CONTAINER=CURRENT clause is not used. 

E. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.

View Answer

Q7. Examine the following command:

ALTER SYSTEM SET enable_ddl_logging=FALSE; 

Which statement is true?

A. None of the data definition language (DDL) statements are logged in the trace file.

B. Only DDL commands that resulted in errors are logged in the alert log file.

C. A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.

D. Only DDL commands that resulted in the creation of new database files are logged. 

View Answer

Q8. Identify three valid methods of opening, pluggable databases (PDBs).

A. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root

B. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a PDB

C. ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed

D. ALTER DATABASE PDB OPEN issued from the root

E. ALTER DATABASE OPEN issued from that PDB

F. ALTER PLUGGABLE DATABASE PDB OPEN issued from another PDB

G. ALTER PLUGGABLE DATABASE OPEN issued from that PDB

View Answer

Q9. Which two statements are true about Oracle Managed Files (OMF)?

A. OMF cannot be used in a database that already has data files created with user- specified directions.

B. The file system directions that are specified by OMF parameters are created automatically.

C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.

D. OMF automatically creates unique file names for table spaces and control files.

E. OMF may affect the location of the redo log files and archived log files.

View Answer

Q10. Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.

Examine the following command and its output:

You execute the following command:

RMAN > BACKUP DATABASE PLUS ARCHIVELOG;

Which data files will be backed up?

A. Data files that belong to only the root container

B. Data files that belong to the root container and all the pluggable databases (PDBs)

C. Data files that belong to only the root container and PDB$SEED

D. Data files that belong to the root container and all the PDBs excluding PDB$SEED

View Answer