Q1. You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).

Examine the query and its output:

Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?

A. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.

B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

C. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.

D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.

E. Re-create the password file in the Oracle Database 12c format.

View Answer

Q2. In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container:

Which two statements are true?

A. The C # # ROLE1 role is created in the root database and all the PDBs.

B. The C # # ROLE1 role is created only in the root database because the container clause is not used. 

C. Privileges are granted to the C##A_ADMIN user only in the root database.

D. Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.

E. The statement for granting a role to a user fails because the CONTAINER clause is not used. 

View Answer

Q3. Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges?

A. Bind Variable Peeking

B. SQL Plan Baselines

C. Adaptive Cursor Sharing

D. Bind variable used in a SQL statement

E. Literals in a SQL statement

View Answer

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

Q5. Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?

A. Tracking the most recent read time for a table segment in a user tablespace

B. Tracking the most recent write time for a table segment in a user tablespace

C. Tracking insert time by row for table rows

D. Tracking the most recent write time for a table block

E. Tracking the most recent read time for a table segment in the SYSAUX tablespace

F. Tracking the most recent write time for a table segment in the SYSAUX tablespace

View Answer

Q6. You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed. 

Identify three possible reasons for this.

A. Missing or stale histogram statistics

B. Undersized shared pool

C. High clustering factor for the indexes

D. High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter

E. Oversized buffer cache

View Answer

Q7. You execute the following commands to audit database activities:

SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;

SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL;

Which statement is true about the audit record that generated when auditing after instance restarts?

A. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.

B. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.

C. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.

D. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used. 

E. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used. 

View Answer

Q8. You use the segment advisor to help determine objects for which space may be reclaimeD.  Which three statements are true about the advisor given by the segment advisor?

A. It may advise the use of online table redefinition for tables in dictionary managed tablespace.

B. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.

C. It may advise the use of online table redefinition for tables in locally managed tablespaces

D. It will detect and advise about chained rows.

E. It may advise the use of segment shrink for free list managed tables.

View Answer

Q9. Which two are prerequisites for performing a flashback transaction?

A. Flashback Database must be enabled. 

B. Undo retention guarantee for the database must be configured. 

C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.

D. Supplemental logging must be enabled. 

E. Recycle bin must be enabled for the database.

F. Block change tracking must be enabled tor the database.

View Answer

Q10. Which two statements are true about variable extent size support for large ASM files?

A. The metadata used to track extents in SGA is reduced. 

B. Rebalance operations are completed faster than with a fixed extent size

C. An ASM Instance automatically allocates an appropriate extent size.

D. Resync operations are completed faster when a disk comes online after being taken offline.

E. Performance improves in a stretch cluster configuration by reading from a local copy of an extent.

View Answer