Q1. Yourdatabase supports an OLTP workload. Examine the output of the query: 

SQL> SSLECT target_mttr, estimated_mttr FROM v$instance_recovery Target_mttrestimated_mttr 

To ensure faster instance recovery, youset the fast_start_mttrjtargh:t initialization parameter to 

30. 

What is the effect of this setting on the database? 

A. Automatic checkpoint tuning is disabled. 

B. The frequency of log switches is increased. 

C. The overhead on database performance is increased because of frequent writes to disk. 

D. The MTTR advisor is disabled. 

View Answer

Q2. Which three statements are true about the keystore storage framework for transparent data encryption? 

A. It facilitates and helps to enforce keystore backup requirements. 

B. It handles encrypted data without modifying applications. 

C. It enables a keystore to be stored only in a file on a file system. 

D. It enables separation of duties between the database administrator and the security administrator. 

E. It transparently decrypts data for the databaseusers and applications that access this data. 

F. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations. 

View Answer

Q3. Which three statements are true about a job chain? 

A. It can contain a nested chain of jobs. 

B. It can be used to implement dependency-based scheduling. 

C. It cannot invoke the same program or nested chain in multiple steps in the chain. 

D. It cannot have more than one dependency. 

E. It can be executed using event-based or time-based schedules. 

View Answer

Q4. Examine the command: 

SQL>RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL; 

In which two scenarios is this command required? 

A. The current online redo log file is missing. 

B. A data file belonging to a noncritical tablespace is missing. 

C. All the control files are missing. 

D. The database backup is older than the control file backup. 

E. All the data files are missing. 

View Answer

Q5. Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2, both of which are open. RMAN is connected to the target database pdb2_1. 

RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT; 

Which statement is true about the execution of this command to back up the database? 

A. All data files belonging to pdb2_1 are backed up and all archive log files are deleted. 

B. All data files belonging to pdb2_1 are backed up along with the archive log files. 

C. Only the data files belonging to pdb2_ are backed up. 

D. This command gives an error because archive log files can be backed up only when RMAN is connected to the root database. 

View Answer

Q6. View the SPFILE parameter settings in the Exhibit. 

You issue this command and get errors: 

SQL> startup 

ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET dueto existing internalsettings,seealertlog for moreinformation 

Why did the instance fail to start? 

A. because pga_aggregate_target is not set 

B. because statistics_level is set to basic 

C. because memory_target and memory_max_target cannot be equal 

D. because sga_target and memory_target are both set 

View Answer

Q7. Which three conditions must be true for unused block compression to be used automatically while performing backups by using RMAN? 

A. The compatible initialization parameter is set to 10.2 or higher. 

B. There are no guaranteed restore points defined for the database. 

C. The default device for the backup must be set to disk. 

D. The tablespaces are locally managed. 

E. The fast recovery area is less than 50 percentfree. 

View Answer

Q8. You have a production Oracle 12c database running on a host. 

You want toinstall and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database. 

The steps in random order: 

1.Create directory structures similar to the production database on all new machines. 

2.Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database. 

3.Create a database clone template for the database. 

4.Run the Database Configuration Assistant (DBCA) to create the database. 

5.Run OUI in graphical mode on each machine. 

6.Run OUI in silent mode using the OUI response file. 

Identify the required steps in the correct sequence to achieve the requirementwith minimal human intervention. 

A. 2, 1, 6, and 4 

B. 2, 3, and 6 

C. 3, 1, 5, and 6 

D. 2, 3, 1, and 6 

E. 1, 5, and 4 

View Answer

Q9. Examine the RMAN command: 

RMAN> BACKUP VALIDATE DATABASE; 

Which statement is true about the execution of the command? 

A. Block change tracking must be enabled before executing this command. 

B. The database must be running in archivelog mode for the successful execution of this command. 

C. A complete database backup must exist before executing this command. 

D. The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block header. 

E. The command checks for blocks that contain a valid checksum and matching headers and footers, but that has logically inconsistentcontents. 

View Answer

Q10. Examine the initialization parameter that is set in the PFILE: 

DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/' 

You execute the following command to create theCDB1. container database (CDB): 

SQL>CREATEDATABASECDB1 

DEFAULTTABLESPACE users 

DEFAULTTEMPORARY TABLESPACEtemp 

UNDO TABLESPACEundotbsl 

ENABLEPLUGGA3LEDATABASE 

SEED 

SYSTEMDATAFILESSIZE125M AUTOEXTEND ON NEXT10M MAXSIZEUNLIMITED 

SYSAUXDATAFILESSIZE100M; 

Which three statements are true? 

A. It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively. 

B. The files created for both the root and seed databases use Oracle Managed Files (OMF). 

C. It creates a multitenant container database with the root and seed databases opened and one PDB mounted. 

D. It sets the users tablespace as the default for both the root and seed databases. 

E. undotbs1 is used as the undo tablespace for both the root and seed databases. 

F. It creates a multitenant container database with the root database opened and the seed database mounted. 

View Answer