Examine the following RMAN command:BACKUP DATABASE -TAG TESTDB -KEEP UNTIL 'SYSDATE+1'RESTORE POINT TESTDB06;Which two statements are true regarding the backup taken by using the above RMAN command? (Choose two.)
You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?
View the Exhibit and examine the output.You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table:ALTER TABLE exchange_rate FLASHBACK ARCHIVE;What is the outcome of this command?Exhibit:
You issue the following command:RMAN>CONFIGURE BACKUP OPTIMIZATION ON;What is the result of this command on your backups?
You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for the RMAN. To accomplish the backup, you issued the following RMAN command:RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;Which two statements are true regarding the execution of the above command? (Choose two.)
The INV_HISTORY table is created using the command:The following data has been inserted into the INV_HISTORY table:You would like to store the data belonging to the year 2006 in a single partition and issue the command:SQL> ALTER TABLE inv_history -MERGE PARTITIONS -FOR(TO_DATE('15-feb-2006','dd-mon-yyyy')),FOR(TO_DATE('15-apr-2006'))INTO PARTITION sys_py;What would be the outcome of this command?
