Q1. Which two statements are true about tablespaces in multitenant container databases (CDBs)? 

A. Default permanent tablespaces can be shared across pluggable databases (PDBs). 

B. The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB. 

C. Each PDB can have its own default temporary tablespace. 

D. The default permanent tablespace for a PDB can be changed only by a local user with the required permissions. 

E. The amount of space that each PDB can usein a shared temporary tablespace must be set at the CDB level. 

View Answer

Q2. Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and is affecting undo retention. 

Which two actions would you take to solve this problem? 

A. Enable temporary undo for the database. 

B. Enable undo retention guarantee. 

C. Increase the size of the redo log buffer. 

D. Enable Automatic Memory Management (AMM). 

E. Increase the size of the temporary tablespace. 

View Answer

Q3. Which two are prerequisites for creating a backup-based duplicate database? 

A. connecting to the target database and a recovery catalog to execute the duplicate command 

B. creating a password file for an auxiliary instance 

C. connecting to an auxiliary instance 

D. matching the database identifier (DBID) of the source database and the duplicate database 

E. creating an SPFILE for the target database 

View Answer

Q4. Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog. 

You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host. 

How would you achieve this? 

A. by using the RMAN switch command to set the new location for the data files 

B. by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host 

C. by using the RMAN duplicate command with dbid and set nekname for tablespace to recover the database to the new host 

D. by creating a new database in the new host, and then using the RMAN recover command 

View Answer

Q5. You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference. 

Which method or feature should you use? 

A. Database Replay 

B. Automatic Database Diagnostic Monitor (ADDM) Compare Period report 

C. Active Session History (ASH) report 

D. SQL Performance Analyzer 

View Answer

Q6. Automatic Shared Memory Management (ASMm) is enabled for your database instance, 

but parameters for the managed components are not defined. 

You execute this command: 

SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M; 

Which statement is true? 

A. The minimum size for the standard buffer cache is 100 MB. 

B. The maximum size for the standard buffer cache is 100 MB. 

C. The minimum space guaranteed in the buffer cache for any server process is 100 MB. 

D. The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB. 

E. The minimum size for all buffer caches is 100 MB. 

View Answer

Q7. Which three statements are true about unplugging a pluggable database (PDB)? 

A. The PDB must be open in read only mode. 

B. The PDB must be dosed. 

C. The unplugged PDB becomes a non-CDB. 

D. The unplugged PDB can be plugged into the same multitenant container database (CDB) 

E. The unplugged PDB can be plugged into another CDB. 

F. The PDB data files are automatically removed from disk. 

View Answer

Q8. Which three statements are true about the database instance startup after an instance failure? 

A. The RECO process recovers the uncommitted transactions at the next instance startup. 

B. Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery. 

C. Uncommitted changes are rolled back to ensure transactional consistency. 

D. The SMON process automatically performs the database recovery. 

E. Media recovery is required to complete the database recovery. 

F. Changes committed before the failure, which were not written to the data files, are re-applied. 

View Answer

Q9. View the Exhibit showing steps to create a database resource manager plan. 

SQL>executedbms_resource_manager.create_pendingarea(); PL/SQLproceduresuccessfully completed. 3QL>execdbms_resource_manager,create_consumergroup 

(consumer_group=>’OLTP,,comment=>,onlineuser’) PL/SQLproceduresuccessfullycompleted. SQL>execdbras_resource_raanager.create_plan(plan=>’PRIU3ER3',comment=>'dssprio’); SQL>exec Dbms_resource_manager.create_plan_directive(plan=>’PRIU3ER3’,group_or_subplan=>' 

OLTP’,comraent=>'onlinegrp'CPU_Pl=>60); 

PL/3QLproceduresuccessfullycompleted. 

After execting the steps in the exhibit you execute this procedure, which results in an error: 

SQL> EXECUTEdbms_resource_manager. validate_pending_area (); 

What is the reason for the error? 

A. The pending area is automatically submitted when creating plan directives. 

B. The procedure must be executedbefore creating any plan directive. 

C. The sys_group group is not included in the resource plan. 

D. The other_groups group is not included in the resource plan. 

E. Pending areas can not be validated until submitted. 

View Answer

Q10. Which three types of failures are detected by the Data Recovery Advisor (DRA)? 

A. loss of a non-critical data file 

B. loss of a control file 

C. physical data block corruption 

D. logical data block corruption 

E. loss of an archived redo log file 

View Answer