Which three components does the Scheduler use for managing tasks within the Oracle environment? (Choose three.)
You are performing incomplete recovery using RMAN. You execute the following RUN block:RUN -{SET UNTIL SCN 1107600;RESTORE DATABASE;RECOVER DATABASE;}Which statement is true about the result?
Which of the following statements is true regarding implementing a Flashback Table recovery?
Which statement about recovering from the loss of a redo log group is true?
You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;Then you issue the following commands:RMAN> CONNECT CATALOG vpc1/oracle@catdb;RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"What is the outcome of the above commands?
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?
