Q1. You created an encrypted tablespace:

You then closed the encryption wallet because you were advised that this is secure. 

Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE

tablespace with the SALT option on the EMPLOYEE column.

Which is true about the result?

A. It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.

B. It generates an error when creating the table because the wallet is closed. 

C. It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.

D. It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.

View Answer

Q2. Which three are true about the large pool for an Oracle database instance that supports

shared server connections?

A. Allocates memory for RMAN backup and restore operations

B. Allocates memory for shared and private SQL areas

C. Contains a cursor area for storing runtime information about cursors

D. Contains stack space

E. Contains a hash area performing hash joins of tables

View Answer

Q3. Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.

Which two RMAN commands may be; used to back up only the PDB1 pluggable database?

A. BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container

B. BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container

C. BACKUP DATABASE while connected to the PDB1 container

D. BACKUP DATABASE while connected to the boot container

E. BACKUP PLUGGABLE database PDB1 while connected to PDB2

View Answer

Q4. You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.

Which method or feature should you use?

A. Compare Period ADDM report

B. AWR Compare Period report

C. Active Session History (ASH) report

D. Taking a new snapshot and comparing it with a preserved snapshot

View Answer

Q5. Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:

Which two statements are true?

A. Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.

B. The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.

C. The command will, create a common user whose description is contained in the root and each PDB. 

D. The schema for the common user C # # A_ADMIN can be different in each container.

E. The command will create a user in the root container only because the container clause is not used. 

View Answer

Q6. Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged.  You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.

Which three steps should you perform to recover the control file and make the database fully operational?

A. Mount the container database (CDB) and restore the control file from the control file auto backup.

B. Recover and open the CDB in NORMAL mode.

C. Mount the CDB and then recover and open the database, with the RESETLOGS option.

D. Open all the pluggable databases.

E. Recover each pluggable database.

F. Start the database instance in the nomount stage and restore the control file from control file auto backup.

View Answer

Q7. You are administering a database stored in Automatic Storage management (ASM). The files are stored in the DATA disk group. You execute the following command:

SQL > ALTER DISKGROUP data ADD ALIAS ‘+data/prod/myfile.dbf’ FOR ‘

+data/prod/myfile.dbf’

What is the result?

A. The file ‘+data. 231.54769’ is physically relocated to ‘+data/prod’ and renamed as ‘myfile.dbf’.

B. The file ‘+data. 231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’.

C. The file ‘+data. 231.54769’ remains in the same location and a synonym 'myfile.dbf' is created. 

D. The file ‘myfile.dbf’ is created in ‘+data/prod’ and the reference to ‘+data. 231.54769’ in the data dictionary removed. 

View Answer

Q8. Examine the commands executed to monitor database operations:

$> conn sys oracle/oracle@prod as sysdba 

SQL > VAR eid NUMBER

SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’);

Which two statements are true?

A. Database operations will be monitored only when they consume a significant amount of resource.

B. Database operations for all sessions will be monitoreD. 

C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.

D. Only DML and DDL statements will be monitored for the session.

E. All subsequent statements in the session will be treated as one database operation and will be monitored. 

View Answer

Q9. Which two are true concerning a multitenant container database with three pluggable database?

A. All administration tasks must be done to a specific pluggable database.

B. The pluggable databases increase patching time.

C. The pluggable databases reduce administration effort.

D. The pluggable databases are patched together.

E. Pluggable databases are only used for database consolidation.

View Answer

Q10. You performed an incremental level 0 backup of a database: 

RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;

To enable block change tracking after the incremental level 0 backup, you issued this command:

SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE

‘ /mydir/rman_change_track.f’;

To perform an incremental level 1 cumulative backup, you issued this command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;

Which three statements are true?

A. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.

B. The change tracking file must always be backed up when you perform a full database backup.

C. Block change tracking will always reduce I/O performed during cumulative incremental backups.

D. More than one database block may be read by an incremental backup for a change made to a single block.

E. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

View Answer