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

A database instance uses an SPFILE. Examine the parameter: You plan to multiplex the control file to a new location, parallelization for the backup set./u01/app/oracle/oradata/cdb1/disk3/control03.ctl/.

Examine the possible steps that are in random order:

1. Shut down the database instance.

2.Issue ALTER SYSTEM SET CONTROL_FILES= `/u01/app/oracle/oradata/cdb1/disk1/control01.ctl, /u01/

app/oracle/oradata/cdb1/disk2/control02, ctl, /u01/app/oracle/oradata/cdb1/disk3/control03.ctl'

SCOPE=SPFILE;.

3.

Issue ALTER SYSTEM SET CONTROL_FILES=

`/u01/app/oracle/oradata/cdb1/disk1/control01.ctl, /u01/app/oracle/oradata/cdb1/disk2/control02.ctl, /u01/

app/oracle/oradata/cdb1/disk3/control03.ctl';.

4.

Copy the control file from the existing location to `/u01/app/oracle/oradata/cdb1/disk3/control03.ctl'.

5.

Mount the database.

6.

Open the database.

Identify the required steps in the correct order to accomplish the task.

A. 3, 4

B. 2, 1, 4, 6

C. 3, 1, 4, 6

D. 1, 5, 2, 4, 6

E. 2, 6

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.

You are required to migrate your 11.2.0.3 database to an Oracle 12c database.

Examine the list of steps that might be used to accomplish this task:

1.

Place all user-defined tablespaces in read-only mode on the source database.

2.

Use the RMAN convert command to convert data files to the target platform's endian format, if required.

3.

Perform a full transportable export on the source database with the parameters VERSION=12, TRANSPORTABLE=ALWAYS, and FULL=Y.

4.

Transport the data files for all the user-defined tablespaces.

5.

Transport the export dump file to the target database.

6.

Perform an import on the target database by using the FULL, NETWORK_LINK, and TRANSPORT_DATAFILES parameters.

7.

Perform an import on the target database by using the full and TRANSPORT_DATAFILES parameters.

Identify the minimum required steps in the correct order.

A. 1, 3, 5, 4, 2, and 7

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

C. 2, 4, 5, 3 and 7

D. 1, 4, 5, 2 and 6

E. 3, 5, 4, 2, and 7

Examine the commands:

SQL> ALTER SESSION SET RECYCLEBIN = ON;

Session altered.

SQL> DROP TABLE emp; --(First EMP table)

Table dropped.

SQL> CREATE TABLE emp(id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2

(15), salary NUMBER(7,2));

Table created.

You then execute multiple INSERT statements to insert rows into the EMP table and drop the table again:

SQL> DROP TABLE emp; -- (Second EMP table)

Table dropped.

SQL> FLASHBACK TABLE emp TO BEFORE DROP;

Which statement is true about the FLASHBACK command?

A. It recovers the structure, data, and indexes of the first EMP table.

B. It recovers only the structure of the second EMP table.

C. It returns an error because two tables with the same name exist in the recycle bin.

D. It recovers the structure, data, and indexes of the second EMP table.

Your database is running in archivelog mode and Automatic Undo Management is enabled.

Which two tasks should you perform before enabling Flashback Database? (Choose two.)

A. Enable minimal supplemental logging.

B. Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back.

C. Enable the recyclebin.

D. Enable undo retention guarantee.

E. Enable Fast Recovery Area.

You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting? (Choose two.)

A. DATE

B. TIMESTAMP

C. INTERVAL YEAR TO MONTH

D. INTERVAL DAY TO SECOND

E. TIMESTAMP WITH LOCAL TIME ZONE

Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (CDB) plan using Oracle Database Resource Manager? (Choose two.)

A. maximum undo per consumer group

B. maximum idle time for a session in a PDB

C. parallel server limit

D. CPU

E. maximum number of sessions for a PDB

The following parameters are set for your Oracle 12c database instance:

OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE

You want to manage the SQL plan evolution task manually. Examine the following steps:

1. Set the evolve task parameters.

2. Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function.

3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.

4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.

5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.

Identify the correct sequence of steps.

A. 2, 4, 5

B. 2, 1, 4, 3, 5

C. 1, 2, 3, 4, 5

D. 1, 2, 4, 5

Which three conditions must be true for unused block compression to be used automatically while performing backups by using RMAN? (Choose three.)

A. The compatible initialization parameter is set to 10.2 or higher.

B. There are no guaranteed restore points defined for the database.

C. The default device for the backup must be set to disk.

D. The tablespaces are locally managed.

E. The fast recovery area is less than 50 percent free.