to minimize plan regression due to the use of a new optimizer version
to completely avoid the use of new plans generated by a new optimizer version
to prevent plan capturing when the SQL statement is executed after the database upgrade
to keep the plan in the plan history so that it can be used when the older version of the optimizer is used
第1题:
Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database()
第2题:
Which of the following restrictions are not true with respect to tablespace point-in-time recovery?()
第3题:
Which of the following statements is NOT true about RMAN?()
第4题:
You administer an Oracle Database 10g and a third-party database. You use Recovery Manager (RMAN) to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command?()
第5题:
you can perform an active database duplication when the database is in NOARCHIVELOG mode.()
第6题:
Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you?()
第7题:
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command: RMAN> RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup?()
第8题:
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario()
第9题:
The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?()
第10题:
Your test database is running in NOARCHIVELOG mode. What are the implications of this? ()