RMAN provides more granular catalog security through which feature?
Which operation requires that you create an auxiliary instance manually before executing the operation? (Choose all that apply.)
Which two statements are true regarding the Automatic Diagnostic Repository (ADR) in Oracle Database 11g? (Choose two.)
You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database, as shown here:1. Put the tablespaces in backup mode.2. Back up the datafiles for all tablespaces.3. Take the tablespaces out of backup mode.4. Back up all archived redo logs.Your colleague asks for you to comment on his plan. Which response would be correct?
Which Scheduler view(s) can be queried to see which jobs are currently executing? (Choose all that apply.)
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?
