Which two statements are true regarding Oracle Data Pump? (Choose two.)

A. EXPDP and IMPDP are the client components of Oracle Data Pump.

B. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.

C. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

D. Oracle Data Pump imports can be done from the export files generated in the Original Export Utility.

E. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

In which three situations must you use a recovery catalog? (Choose three.)

A. when you want to store RMAN global scripts that can be used across multiple databases

B. when you want to restrict the amount of space used by backups

C. when you want to perform incremental backups by using a block change tracking file

D. when you want to list data files that were in a target database at a given time by using the AT clause with the REPORT SCHEMA command

E. when you want to maintain backup metadata longer than the period specified by the CONTROL_FILE_RECORD_KEEP_TIME parameter

You execute the commands to configure settings in RMAN:

Then, you issue the following command to take a backup:

Which statement is true about the execution of these commands?

A. The backup terminates because the backup destination for disk is not specified in the BACKUP command.

B. It backs up two copies each of the data files to disk and media, and two copies of archived logs to media.

C. It backup up the data files and archived logs, making one copy of each data file and archived log on disk and media.

D. It backs up the data files and archived logs to media, making two copies of each data file and archived logs.

You regularly take backups of your database using RMAN with a recovery catalog. Your database is currently open and the temp01.dbf temp file belonging to the TEMP tablespace is corrupted.

Identify two methods to recover the temp file with the least disruption to database availability. (Choose two.)

A. Drop the TEMP tablespace, and then re-create it with new temp files.

B. Restart the database instance to create the temp file automatically.

C. Take the TEMP tablespace offline, drop the missing temp file, and then create a new temp file.

D. Add a new temp file to the TEMP tablespace with a new name, and then drop the temp file that is corrupted.

Which statement is true about the ALTER SESSION SET CONTAINER command to switch between containers?

A. It can be executed only from CDB$ROOT.

B. It rolls back any pending transactions in the container from which it is executed.

C. It will not fire login triggers for the specified container.

D. It cannot be used to connect to PDB$SEED.

E. It cannot be used to connect to CDB$ROOT from a pluggable database (PDB).

You have a production Oracle 12c database running on a host.

You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.

The steps in random order:

1.

Create directory structures similar to the production database on all new machines.

2.

Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.

3.

Create a database clone template for the database.

4.

Run the Database Configuration Assistant (DBCA) to create the database.

5.

Run OUI in graphical mode on each machine.

6.

Run OUI in silent mode using the OUI response file.

Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.

A. 2, 1, 6, and 4

B. 2, 3, and 6

C. 3, 1, 5, and 6

D. 2, 3, 1, and 6

E. 1, 5, and 4

Which three statements are true about Oracle Restart? (Choose three.)

A. It can be configured to automatically attempt to restart various components after a hardware or software failure.

B. While starting any components, it automatically attempts to start all dependencies first and in proper order.

C. It can be configured to automatically restart a database in case of normal shutdown of the database instance.

D. It can be used to only start Oracle components.

E. It runs periodic check operations to monitor the health of Oracle components.

Which two statements are true about dropping a pluggable database (PDB)? (Choose two.)

A. A PDB must be in MOUNT state or it must be unplugged.

B. The data files associated with a PDB are automatically removed from disk.

C. A dropped and unplugged PDB can be plugged back into the same multitenant container database (CDB) or other CDBs.

D. A PDB must be in closed state.

E. The backups associated with a PDB are removed.

F. A PDB must have been opened at least once after creation.

A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.

Which table organization allows for generating the bills with minimum degree of row sorting?

A. a hash cluster

B. an index cluster

C. a partitioned table

D. a sorted hash cluster

E. a heap table with a rowid column

Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:

1.

Create a policy to capture the privileges used by a user for privilege analysis.

2.

Generate a report with the data captured for a specified privilege capture.

3.

Start analyzing the data captured by the policy.

4.

Revoke the unused privileges.

5.

Compare the used and unused privileges' lists.

6.

Stop analyzing the data.

Identify the correct sequence of steps.

A. 1, 3, 5, 6, 2, 4

B. 1, 3, 6, 2, 5, 4

C. 1, 3, 2, 5, 6, 4

D. 1, 3, 5, 2, 6, 4