单选题 Examine this configuration: 1. CDB1 is a container database running in ARCHIVELOG mode. 2. Controlfiles of CDB1 are multiplexed in '/u01/app/oracle/oradata/CDB1/controlfile/controlfile01.ctl' and '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'. 3. The only backup of CDB1 was taken when CONTROLFILE AUTOBACK was OFF 4. SNAPSHOT CONTROLFILE NAME is '/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1.f'. 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: $ rman target sys/oracle_4U8localhost:1521/cdb1 RMAN> SHUTDOWN ABORT -- Oracle instance shut down RMAN> STARTUP NOMOUNT RMAN> RESTORE CONTROLFILE FROM '/u01/app/oracle/oradata/CDB1/controlfile/controlfile01.ctl'; What will be the outcome? (Choose one.)

单选题 Examine this configuration: 1). The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA. 2). ORCL uses disk group +FRA for the Fast Recovery Area. 3). LISTENER is the listener for ORCL. 4). The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart. 5). All components are currently shut down. You execute this command: $ srvctl start database - d ORCL What is the outcome? (Choose one.)

单选题 Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application. Examine these steps: 1. Install the SALES_APP application, including the common tables, in the application root. 2. Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root. 3. Create an application seed. 4. Install the SALES_APP application in the application seed. 5. Create the SALES_APP1 and SALES_APP2 application PDBs. 6. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root. 7. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed. 8. Sync the application seed with the application root. Which are the minimum required steps in the correct sequence?

单选题 Examine these actions: 1). Create a new database for a recovery catalog. 2). Create a tablespace with sufficient space in the catalog database for the recovery catalog. 3). Configure ARCHIVELOG mode for the catalog database. 4). Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog. 5). Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner. 6). Grant the SYSBACKUP privilege to the recovery catalog schema owner. Which are the minimum actions that must be performed before executing the CREATE CATALOG command?

单选题 Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?

单选题 Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed. No changes have been made to the standard PDB$SEED. How many default temporary tablespaces can be assigned in the CDB?

单选题 Examine these queries and their output:

SQL> select pdb_name, name, pdb_restore_point, clean_pdb_restore_point

2 from v$restore_point natural join dba_pdbs;

PDB_NAME NAME PDB_RESTORE_POINT CLEAN_PDB_RESTORE_POINT

-------- ------ ----------------- -----------------------

PDB1 R1 YES NO

SQL> select property_name, property_value

2 from database_properties where property_name like '%UNDO%';

PROPERTY_NAME PROPERTY_VALUE

---------------- ---------------

LOCAL_UNDO_ENABLED FALSE

An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created.

You want to recover PDB1 to Restore Point R1.

How do you achieve this?

单选题 A user complains about poor database performance. You want to verify if the user’s session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once? (Choose one.)