Which command do you use to generate a report of database incarnations?
The EMP table exists in your schema. You want to execute the following query:SELECT ename, sal -FROM emp -AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE)WHERE ename = 'ALLEN';What are the minimum requirements for the statement to execute successfully? (Choose all that apply)
You configured the default backup device type as disk for RMAN backups. In your database, because of business requirements, you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used.What must you set using the RMAN CONFIGURE command to achieve this?
What is the purpose of the until change option of the restore command?
You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup? (Choose three.)
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?
