Q1. Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?

A. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.

B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.

C. All the components may be moved into SYSAUX tablespace.

D. All the components may be moved from the SYSAUX tablespace.

View Answer

Q2. Which three statements are true about adaptive SQL plan management?

A. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.

B. The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.

C. It adds new, bettor plans automatically as fixed plans to the baseline.

D. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.

E. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated. 

View Answer

Q3. Which three operations can be performed as multipartition operations in Oracle?

A. Merge partitions of a list partitioned table

B. Drop partitions of a list partitioned table

C. Coalesce partitions of a hash-partitioned global index.

D. Move partitions of a range-partitioned table

E. Rename partitions of a range partitioned table

F. Merge partitions of a reference partitioned index

View Answer

Q4. Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB.  You execute the following command:

SQL > CREATE UNDO TABLESPACE undotb01

DATAFILE ‘u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON; 

What is the result?

A. It executes successfully and creates an UNDO tablespace in HR_PDB. 

B. It falls and reports an error because there can be only one undo tablespace in a CDB. 

C. It fails and reports an error because the CONTAINER=ALL clause is not specified in the command. 

D. It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command. 

E. It executes successfully but neither tablespace nor the data file is created. 

View Answer

Q5. A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);

You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.

What could be a reason for this recommendation?

A. The keep pool is not configured. 

B. Automatic Workarea Management is not configured. 

C. Automatic Shared Memory Management is not enabled. 

D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed. 

E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view.

View Answer

Q6. You are administering a database and you receive a requirement to apply the following restrictions:

1.A connection must be terminated after four unsuccessful login attempts by user.

2.A user should not be able to create more than four simultaneous sessions.

3.User session must be terminated after 15 minutes of inactivity.

4.Users must be prompted to change their passwords every 15 days. How would you accomplish these requirements?

A. by granting a secure application role to the users

B. by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to FALSE

C. By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4

D. By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE.

E. By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.

View Answer

Q7. You notice that the elapsed time for an important database scheduler Job is unacceptably long.

The job belongs to a scheduler job class and window. Which two actions would reduce the job's elapsed time?

A. Increasing the priority of the job class to which the job belongs

B. Increasing the job's relative priority within the Job class to which it belongs

C. Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window

D. Moving the job to an existing higher priority scheduler window with the same schedule and duration

E. Increasing the value of the JOB_QUEUE_PROCESSES parameter

F. Increasing the priority of the scheduler window to which the job belongs

View Answer

Q8. You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema. 

Examine the following steps:

1.Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (‘SH’, ‘CUSTOMERS’) FROM dual statement.

2.Execute the DBMS_STATS.SEED_COL_USAGE (null, ‘SH’, 500) procedure.

3.Execute the required queries on the CUSTOMERS table.

4.Issue the SELECT DBMS_STATS.REPORT_COL_USAGE (‘SH’, ‘CUSTOMERS’) FROM dual statement.

Identify the correct sequence of steps.

A. 3, 2, 1, 4

B. 2, 3, 4, 1

C. 4, 1, 3, 2

D. 3, 2, 4, 1

View Answer

Q9. Your multitenant container database (CDB) contains a pluggable database, HR_PDB.  The default permanent tablespace in HR_PDB is USERDATA.  The container database (CDB) is open and you connect RMAN.

You want to issue the following RMAN command: 

RMAN > BACKUP TABLESPACE hr_pdb:userdata;

Which task should you perform before issuing the command?

A. Place the root container in ARHCHIVELOG mode.

B. Take the user data tablespace offline.

C. Place the root container in the nomount stage.

D. Ensure that HR_PDB is open.

View Answer

Q10. Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):

Which three are prerequisites for successful execution of the command?

A. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role.

B. All the user-defined tablespaces must be in read-only mode on the source database.

C. The export dump file must be created before starting the import on the target database.

D. The source and target database must be running on the same platform with the same endianness.

E. The path of data files on the target database must be the same as that on the source database.

F. The impdp operation must be performed by the same user that performed the expdp operation.

View Answer