View the Exhibit and examine the resource consumption details for the current plan in use by the database instance.Which two statements are true based on the output? (Choose two.) Exhibit:
Which three elements can a job chain process involve? (Choose three)
You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You executed the following commands:RMAN> CONNECT CATALOG rco11/password@catdbRMAN> IMPORT CATALOG rcat10/oracle@inst1 NO UNREGISTER;Which two statements are true regarding the tasks accomplished with these commands? (Choose two.)
If you are going to run a TSPITR recovery, which view will help you to determine which objects will be lost during the TSPITR?
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?
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?
