You execute the RMAN commands:

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk; RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 2; RMAN> BACKUP DATABASE;

Which two statements are true? (Choose two.)

A. One channel is allocated.

B. Two channels are allocated.

C. The backup set is created in parallel in two locations.

D. The backup set is created in parallel only in one location.

E. The backup set is created serially in only one location.

Your database is running in ARCHIVELOG mode. Examine the initialization parameters you plan to set for your database instance.

LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/3rch' LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch' L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/3rch MANDATORY'

Identify the statement that correctly describes these settings.

A. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in any of the LOG_ARCHIVE_DEST_.n destinations.

B. Optional destinations cannot use the fast recovery area.

C. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in the location specified for LOG_ARCHIVE_DEST_4.

D. These settings work only if LOG__ARCHIVE_MIN_SUCCEED_DEST is set to a value of 4.

You restore and recover your database to a new host by using an existing RMAN open database backup.

Which step must you perform next?

A. Execute catproc.sql to recompile invalid PL/SQL modules.

B. Open the database with the RESETLOGS option.

C. Set a new database identifier (DBID) for the newly restored database.

D. Use the RMAN SET NEWNAME and SWITCH commands to switch to new files.

A database is running in archivelog mode. The database contains locally managed tablespaces. Examine the RMAN command:

RMAN> BACKUP AS COMPRESSED BACKUPSET SECTION SIZE 1024M DATABASE;

Which statement is true about the execution of the command?

A. The backup succeeds only if all the tablespaces are locally managed.

B. The backup succeeds only if the RMAN default device for backup is set to disk.

C. The backup fails because you cannot specify section size for a compressed backup.

D. The backup succeeds and only the used blocks are backed up with a maximum backup piece size of 1024 MB.

You must unload data from the orders, order_items, and products database tables to four files using the External Tables.

CREATE TABLE orders_ext (order_id, order_date, product_id, product_name,quantity) ORGANIZATION EXTERNAL ( TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY ext.dir LOCATION (`ordersl.dmp','orders2.dmp','orders3.dmp','lorders4.dmp') ) PARALLEL AS SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity FROM orders o,productsp,order_items WHERE o.orderid = i.order_id and i.product_id = p.product_id;

You execute the command shown in the Exhibit, but only two files are created. Which parameter must be changed so that four files are created?

A. TYPE

B. LOCATION

C. PARALLEL

D. DEFAULT DIRECTORY

E. ORGANIZATION EXTERNAL