You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years. You execute the following command…

Examine the RMAN commands: RMAN> CONNECT TARGET “sbu@prod AS SYSBACKUP”; RMAN> CONNECT AUXILIARY “sbu@dup_db AS SYSBACKUP”; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M; Which statement is true about the DUPLICATE command? A. It…

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

An incremental level 1 backup is taken every week day. A new tablespace is created before the backup is performed. You execute: RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE; Which two are true? (Choose…