Q1. In which two scenarios do you use SQL* Loader to load data?

A. Transform the data while it is being loaded into the database.

B. Use transparent parallel processing without having to split the external data first.

C. Load data into multiple tables during the same load statement.

D. Generate unique sequential key values in specified columns.

View Answer

Q2. Examine the following command;

ALTER SYSTEM SET enable_ddl_logging = TRUE;

Which statement is true?

A. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.

B. All DDL commands are logged in the alert log file.

C. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.

D. Only DDL commands that resulted in the creation of new segments are logged. 

E. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

View Answer

Q3. You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.

In which three ways can you re-create the lost disk group and restore the data?

A. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data. 

B. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.

C. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data. 

D. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data. 

E. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.

F. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data. 

View Answer

Q4. To enable the Database Smart Flash Cache, you configure the following parameters:

DB_FLASH_CACHE_FILE = ‘/dev/flash_device_1’ , ‘/dev/flash_device_2’ 

DB_FLASH_CACHE_SIZE=64G

What is the result when you start up the database instance?

A. It results in an error because these parameter settings are invalid. 

B. One 64G flash cache file will be used. 

C. Two 64G flash cache files will be used. 

D. Two 32G flash cache files will be used. 

View Answer

Q5. Which statement is true about Oracle Net Listener?

A. It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.

B. A single listener can service only one database instance and multiple remote client connections.

C. Service registration with the listener is performed by the process monitor (LREG) process of each database instance.

D. The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.

E. The listener.ora configuration file must be located in the ORACLE_HOME/network/admin directly.

View Answer

Q6. Which three statements are true about SQL plan directives?

A. They are tied to a specific statement or SQL ID. 

B. They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.

C. They are used to gather only missing statistics.

D. They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.

E. They instruct the optimizer to create only column group statistics.

F. Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.

View Answer

Q7. Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c?

A. ALTER TABLE SPLIT PARTITION

B. ALTER TABLE MERGE PARTITION

C. ALTER TABLE TRUNCATE PARTITION

D. ALTER TABLE ADD PARTITION

E. ALTER TABLE DROP PARTITION

F. ALTER TABLE MOVE PARTITION

View Answer

Q8. Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:

What are three possible causes for the latch-related wait events?

A. The size of the shared pool is too small.

B. Cursors are not being shared. 

C. A large number COMMITS are being performed. 

D. There are frequent logons and logoffs.

E. The buffers are being read into the buffer cache, but some other session is changing the buffers.

View Answer

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

Q10. You run a script that completes successfully using SQL*Plus that performs these actions:

1.Creates a multitenant container database (CDB)

2.Plugs in three pluggable databases (PDBs)

3.Shuts down the CDB instance

4.Starts up the CDB instance using STARTUP OPEN READ WRITE Which two statements are true about the outcome after running the script?

A. The seed will be in mount state.

B. The seed will be opened read-only.

C. The seed will be opened read/write.

D. The other PDBs will be in mount state.

E. The other PDBs will be opened read-only.

F. The PDBs will be opened read/write.

View Answer