You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN. Which two statements are correct in this scenario?()
时间:2022-10-26
A media failure has occurred. This has resulted in all the members of the next log group being rendered inaccessible to the log writer process (LGWR) at a log switch. How does this failure affect the operational database?()
The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility. What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility?()
You are creating a resource consumer group using the DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP procedure. Which parameter will you use to define the resource scheduling method used between sessions within the resource group?()
You executed the following command in Recovery Manager (RMAN): RMAN> RESTORE CONTROLFILE; Which operation must you perform before this command is executed?()
You executed the following command in Recovery Manager (RMAN) against your Oracle 10g database: RMAN> REPORT NEED BACKUP days 3; What would be the output of this command?()
时间:2022-10-25
For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state?()
You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code?() RMAN>RUN { SET UNTIL SEQUENCE THREAD ; RESTORE DATABASE; RECOVER DATABASE; }
You execute the following command to enable a session in resumable mode: SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60; What is the impact of a timeout on the statements being suspended?()
You received the following error: ORA-01578: ORACLE data block corrupted (file # %s, block # %s) Which file will you check to view additional information regarding the cause of this error?()
You execute the following RMAN command in the order shown below: BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do?()
时间:2022-10-24
While creating a scheduler window using the DBMS_SCHEDULER package, a user logged in as DBMGR gets the error message insufficient privileges? Which two commands would you use to resolve this error?()
In which scenario will you issue the following command?() SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 : 12:09:08’ USING BACKUP CONTROLFILE;
时间:2022-10-23
Why would you use the following FLASHBACK TABLE command?() FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’);
In which scenario is a Database Administrator NOT required to perform an incomplete recovery?()
时间:2022-10-22