Q1. Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX?

A. Thread creation must be routed through a dispatcher process

B. The local listener may spawn a now process and have that new process create a thread

C. Each Oracle process runs an SCMN thread. 

D. Each multithreaded Oracle process has an SCMN thread. 

E. The local listener may pass the request to an existing process which in turn will create a thread. 

View Answer

Q2. On your Oracle Database, you issue the following commands to create indexes:

SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE;

SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);

Which two statements are true?

A. Only the ORD_CUSTOMER_IX1 index created. 

B. Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.

C. Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.

D. The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.

E. Both the indexes are created and used by the optimizer for queries on the ORDERS table.

F. Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.

View Answer

Q3. You executed this command to create a password file:

$ orapwd file = orapworcl entries = 10 ignorecase = N 

Which two statements are true about the password file?

A. It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.

B. It contains username and passwords of database users who are members of the OSOPER operating system group.

C. It contains usernames and passwords of database users who are members of the OSDBA operating system group.

D. It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.

E. It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.

View Answer

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

Q5. You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:

SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE;

Which is true about the result of this command?

A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened. 

B. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened. 

C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted. 

D. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored. 

View Answer

Q6. The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup.

A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;

B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

C. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

D. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;

E. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;

F. BACKUP SPFILE SECTION SIZE 1M;

G. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

View Answer

Q7. You use a recovery catalog for maintaining your database backups.

You execute the following command:

$rman TARGET / CATALOG rman / cat@catdb

RMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;

Which two statements are true?

A. Corrupted blocks, if any, are repaired. 

B. Checks are performed for physical corruptions.

C. Checks are performed for logical corruptions.

D. Checks are performed to confirm whether all database files exist in correct locations

E. Backup sets containing both data files and archive logs are created. 

View Answer

Q8. You execute the following piece of code with appropriate privileges:

User SCOTT has been granted the CREATE SESSION privilege and the MGR role. 

Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?

A. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.

B. Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.

C. Data is never redacted for the EMP_V.SAL column.

D. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.

E. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.

View Answer

Q9. Identify two situations in which the alert log file is updated. 

A. Running a query on a table returns ORA-600: Internal Error.

B. Inserting a value into a table returns ORA-01722: invalid number.

C. Creating a table returns ORA-00955: name us already in used by an existing objects.

D. Inserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated. 

E. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.

View Answer

Q10. Which three activities are supported by the Data Recovery Advisor?

A. Advising on block checksum failures

B. Advising on inaccessible control files

C. Advising on inaccessible block change tracking files

D. Advising on empty password files

E. Advising on invalid block header field values

View Answer