For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)
A. to specify a default tablespace in a PDB cloned from another PDB in the same CDB.
B. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB
C. to include specific user tablespaces only when relocating a PDB
D. to specify the list of user tablespaces to include when moving a non-CDB to a PDB
E. to exclude a temp tablespace when plugging in a PDB
F. to specify the list of tablespaces to include when creating a PDB from the CDB seed
Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)
A. defining primary keys for all tables to speed up all queries
B. using check constraints to speed up updates
C. defining foreign keys for all tables to speed up joins
D. the physical data model
E. the configuration of storage arrays
Examine this configuration:
While CDB1 is open, `/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl' is accidentally deleted. To recover from this critical failure, you execute these commands:
What will be the outcome?
A. It will create `$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl'
B. It will create `/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'.
C. It will re-create `/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'
D. It will create `/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl'.
E. It will fail because there is no autobackup of the controlfiles.
A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB.
Data file 24 of PDB2 was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the BACKUP DATABASE command while connected to CDB$ROOT.
Which three are true? (Choose three.)
A. Data file 24 can be recovered only while connected to PDB2.
B. Data file 24 can be restored and recovered while connected to CDB$ROOT.
C. Data file 24 can be restored only while connected to CDB$ROOT.
D. Data file 24 can be restored only while connected to PDB2.
E. Data file 24 can be recovered while connected to PDB2.
F. Data file 24 can be recovered while connected to CDB$ROOT.
Examine this configuration:
1.
CDB1 is an Oracle Database 12c Release 2 container database (CDB).
2.
PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1.
After successfully performing all the preupgrade tasks, you execute these commands from the Oracle Database 18c environment:
What is the outcome?
A. It fails because PDB$SEED is in MIGRATE state.
B. Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded.
C. Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded.
D. CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.
E. Only CDB$ROOT and PDB$SEED are upgraded.
F. It fails because PDB2 is not in UPGRADE state.
Which two are prerequisites for performing Flashback Transaction?
A. Fast Recovery Area must be enabled for the database
B. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.
C. Undo retention guarantee must be configured for the database.
D. A supplemental log must be enabled for the primary key.
E. A supplemental log must be enabled for the primary key.
Which two are true about PDB archive files? (Choose two).
A. DBMS_PDB.CHECK_PLUG_COMPATIBILITY can be run against a PDB archive.
B. They contain a PDB manifest file and all the data files in uncompressed form for a PDB.
C. They contain all the data files only in uncompressed form for a PDB.
D. They must be created using the DBMS_PDB package.
E. They contain a PDB manifest file and all the data files in compressed form for a PDB.
F. They contain all the data files only in compressed form for a PDB.
Examine the RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M;
Which statement is true about the DUPLICATE command?
A. It succeeds and creates multisection backup sets that are used for active database duplication.
B. It fails because there is no connection to a recovery catalog.
C. It succeeds only if the target database is in MOUNT state.
D. It fails because no parallel channels are allocated for the auxiliary database.
Which three RMAN persistent settings can be set explicitly? (Choose three)
A. SPFILE backup duplexing
B. control file auto backup formats
C. archive log deletion policy
D. image copy duplexing
E. redo log backup duplexing
F. archive log backup duplexing
You execute this command successfully:
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
What is the outcome?
A. It creates a binary backup of the control file.
B. It updates the alert log with the location and contents of the control file
C. It creates a file that contains SQL statements to re-create the control file.
D. It creates a file that contains RMAN scripts to create a duplicate database.
E. It creates a copy of the control file in the fast recovery area (FRA).