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？（）
A. The statements remain suspended for at least 60 seconds.
B. The statements are suspended for 60 seconds and then they are executed.
C. The suspended statements error out if the problem is not rectified within 60 seconds.
D. The statements are automatically suspended 60 seconds after an error is received， and then attempt to execute normally again.
查看答案
相关试题
换一换
Why would you execute the report obsolete command？（）
A. To list all backups that were no longer available for restore operations B. To list all backups that had aged beyond the RMAN retention criteria C. To list all backup set pieces listed in control-file or recovery-catalog metadata that are not on the backup media D. To list all datafiles that are no longer part of the database and thus do not need to be backed up E. To list all archived redo logs that are no longer needed for any database recovery
答案
After the recovery is complete， which command should you execute？（）
A.LTER DATABASE OPEN； B.LTER DATABASE CLEAR LOGFILE； C.LTER DATABASE OPEN RESETLOGS； D.LTER DATABASE OPEN NORESETLOGS；
答案
RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）
A.’SQL ALTER DATABASE OPEN’； B.SQL ALTER DATABASE ’OPEN’； C.OPEN DATABASE； D.ATABASE OPEN
答案
You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）
A. STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN； B. STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS； C. STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS； D. STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
答案
You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script？（）
A. run { open script backup_database； run script backup_database } B. run { engage script backup_database； } C. run { run script backup_database； } D. Run { execute script backup_database； } E. The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.
答案
You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script？（）
A. run { open script backup_database； run script backup_database } B. run { engage script backup_database； } C. run { run script backup_database； } D. Run { execute script backup_database； } E. The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.
答案
You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）
A. Create a backup of the database and recover all corrupted blocks found in the backup. B. Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database. C. Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view. D. Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view. E. Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.
答案
You work as a database administrator for Certkiller .com. On a Monday morning， you find the database instance aborted. After inspecting the alert log file， you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true？（）
A.PMON coordinates media recovery. B.SMON coordinates instance recovery. C.PMON coordinates instance recovery. D.Undo Advisor would roll back all uncommitted transactions. E.SQL*PLUS reports an error with the message asking you to perform instance recovery.
答案
You work as a database administrator for Supportcenter.cn. On a Monday morning， you find the database instance aborted. After inspecting the alert log file， you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true？（）
A.PMON coordinates media recovery. B.SMON coordinates instance recovery. C.PMON coordinates instance recovery. D.Undo Advisor would roll back all uncommitted transactions. E.SQL*PLUS reports an error with the message asking you to perform instance recovery.
答案
You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）
A.All control files are opened B.All redo files are opened C.The password file is opened D.The parameter file is opened E.All online data files are opened
答案
热门试题
You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）
You work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）
You have a disk group， DGROUP1， with three disk and NORMAL redundancy. You execute the following command to create a template for the disk group： ALTER DISKGROUP dgroup1 ADD TEMPLATE my_temp ATTRIBUTES （MIRROR FINE）；Which statement is true？（）
You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down: SQL> shutdown immediate; What is the result of executing this command?（）
You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down: SQL> shutdown immediate; What is the result of executing this command?（）
Which two code fragments will execute the method doStuff（） in a separate thread？（）
What RMAN command is used to execute a tablespace point-in-time recovery？（）
You find that some queries on a table are taking a long time to execute because there are no indexes created on the table. You decide to invoke the SQL Access Advisor to determine the appropriate index to be created. Which package will you use to invoke the SQL Access Advisor？（）
You find that some queries on a table are taking a long time to execute because there are no indexes created on the table. You decide to invoke the SQL Access Advisor to determine the appropriate index to be created. Which package will you use to invoke the SQL Access Advisor？（）
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？（）
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA， which commands must you execute to enable SCOTT to flash back the transactions？（）
You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database？（）
You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database？（）
Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）
You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take？（）
You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take？（）
You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）
You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of yourdatabase to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order： 1.Shut down the instance. 2.Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value. 3.Execute the ALTER DATABASE FLASHBACK OFF command. 4.Start up the instance and mount the database. 5.Execute the ALTER DATABASE FLASHBACK ON command. 6.Open the database. Select the correct order in which these tasks need to be performed.（）
You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）
The user is trying to execute a SELECT statement. Which of the following background processes will obtain data from a disk for the user?（）
使用微信扫一扫登录
