Q1. For which three pieces of information can you use the RMAN list command? 

A. stored scripts in the recovery catalog 

B. available archived redo log files 

C. backup sets and image copies that are obsolete 

D. backups of tablespaces 

E. backups that are marked obsolete according to the current retention policy 

View Answer

Q2. In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20. 

Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement? 

A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used 

B. Setting the target tablespace to read-only after the segments are moved 

C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds T3Spercent used 

D. Taking the target tablespace offline after the segments are moved 

E. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used 

View Answer

Q3. In your database, there are tablespaces that were read-only when thelast backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file. 

What precaution must you take for the read-only tablespaces before performing anincomplete recovery? 

A. All the read-only tablespaces should be taken offline. 

B. All the read-only tablespaces should be restored separately. 

C. All the read-only tablespaces should be renamed to have the MISSINGnnnn format. 

D. All the read-only tablespacesshould be made online with logging disabled. 

View Answer

Q4. Examine the parameters for your database instance: 

NAMETYPEVALUE 

optimizer_adaptive_reporting_onlybooleanFALSE 

optimizer_capture_sql_plan_baselinesbooleanFALSE 

optimizer_dynamic_samplinginteger2 

optimizer_features_enablestring12.1.0.1 

Which three statements are true about the process of automatic optimization by using statistics feedback? 

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

View Answer

Q5. Which two methods can be used toadd an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)? 

A. Use the d3MS_pdb package to plug the Oracle 11g database into the existing CDB as a PDB. 

B. Use the create database ... enable pluggable database statement to create a PDB by copying data files from pd3Sseed and use data pump to load data from the Oracle 11g database into the newly created PDB. 

C. Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB. 

D. Pre-create a PDB in CDB and use the network_link and parallel parameters with data pump import to import data from the Oracle 11g database to the newly created PDB. 

E. Upgrade the Oracle 11g database to a 12c non-CDB and use the dbms_pdb.describe procedure to plug the database as a new PDB into the CDB. 

View Answer

Q6. You create two Resource Manager plans, one for night time workloads, the other for day time. 

How would you make the plans switch automatically? 

A. Use job classes. 

B. Use scheduler windows. 

C. Use the mapping rule for the consumer groups. 

D. Set the switch_time plan directive for both plans. 

E. Use scheduler schedules. 

View Answer

Q7. Which two statements are true abouta multitenant architecture? 

A. Each pluggable database (PDB) has its own initialization parameter file. 

B. A PDB can have a private undo tablespace. 

C. Log switches occur only at the container database level. 

D. A PDB can have a private temporary tablespace. 

E. Each PDB has a private control file. 

View Answer

Q8. You are administering a multitenant container database (CDB) cdb1 that has multiple pluggable databases (PDBs). As the sys user on cdb$root, you execute the commands: 

SQL> CREATE USER C##ADMIN IDENTIFIED BY orc1123; 

SQL> GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL; 

SQL> GRANT CREATE USER TO C##ADMIN CONTAINER=ALL; 

Which two statements are true about the c##admin user that is created in all PDBs? 

A. It can create only local users in all the PDBs. 

B. It has a common schema for all the PDBs. 

C. It can create common users only when it is logged in to the CDB. 

D. It can create only local users in the CDB. 

E. It can be granted only common roles in the PDBs. 

View Answer

Q9. Which two are prerequisites for setting up Flashback Data Archive? 

A. Fast Recovery Area should be defined. 

B. Undo retention guarantee should be enabled. 

C. Supplemental logging should be enabled. 

D. Automatic Undo Management should be enabled. 

E. All users using Flashback Data Archive should have unlimitedquota on the Flashback Data Archive tablespace. 

F. The tablespace in which the Flashback Data Archive is created should have Automatic Segment Space Management (ASSM) enabled. 

View Answer

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

Examine the command executed to back up pdb2_1: 

RMAN> BACKUP DATABASE PLUS ARCHIVELOG; 

Which statement is true about the execution of this command? 

A. It fails because archive log files cannot be backed up using a connection to a PDB. 

B. It succeeds but only the data files belonging to the pdb2_i pluggable database are backed up. 

C. It succeeds andall data files belonging to PD32_i are backed up along with the archive log files. 

D. It fails because the pluggable clause is missing. 

View Answer