You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? （）A、to minimize plan regression due to the use of a new optimizer versionB、to completely avoid the use of new plans generated by a new optimizer versionC、to prevent plan capturing when the SQL statement is executed after the database upgradeD、to keep the plan in the plan history so that it can be used when the older version of the optimizer is used
You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? （）
- A、to minimize plan regression due to the use of a new optimizer version
- B、to completely avoid the use of new plans generated by a new optimizer version
- C、to prevent plan capturing when the SQL statement is executed after the database upgrade
- D、to keep the plan in the plan history so that it can be used when the older version of the optimizer is used
相关考题：
View the Exhibit and examine the output.You execute the following RMAN command to perform the backup operation:What is the multiplexing level in the preceding backup process() A. 4B. 8C. 7D. 0
You perform an in-place upgrade on a Microsoft Windows XP Service Pack 2 (SP2) computer to Windows Vista.After the upgrade, you attempt to run a custom application. You receive the following error message: This application is only designed to run on Windows XP or later.”You need to run the application on Windows Vista.What should you do?（）A.AB.BC.CD.D
You need to configure a new computer to dual－boot to the following operating systems:·Microsoft Windows XP Professional·Microsoft Windows VistaWhich two procedures should you perform?() A.AB.BC.CD.D
You have a server that runs Windows Server 2003 Service Pack 2 (SP2). The server is configured as shown in the following table.You need to ensure that you can restore the server and all its data in the event of a complete system failure.You perform an Automated System Recovery (ASR) backup.What else should you backup? （）A.volume CB.volume DC.volume ED.the system state
Which of the following statements is NOT true about RMAN？（）A、It improves usability by enabling you to reuse the scripts to perform recovery operations.B、It detects block corruption while restoration and recovery operations.C、It enables you to perform block media recovery.D、It is capable to recover through unrecoverable operations， with only full database backups.
You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery ：Type screen？（）A、 Whole databaseB、 TablespacesC、 DatafilesD、 Archive logsE、 Redo logs
Which three are true regarding the use of outer joins? （）A、You cannot use IN operator in a condition that involves an outerjoin.B、You use (+) on both sides of the WHERE condition to perform an outerjoin.C、You use (*) on both sides of the WHERE condition to perform an outerjoin.D、You use an outerjoin to see only the rows that do not meet the join condition.E、In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.F、You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.
You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). On Server1, you have the following backup schedule: ·Normal backups every Saturday at 01:00 Differential backups every weekday at 02:00, except on Saturday You need to perform a complete manual backup of Server1 on Tuesday. The backup must not change which files are backed up during the next scheduled backup. Which type of backup should you perform? （）A、copyB、dailyC、incrementalD、normal
Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）A、 The target database must be in NOARCHIVELOG mode.B、 No backup is required of the database before you perform a TSPITR.C、 You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.D、 If you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.E、 If you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.
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？（）A、shut down and restart the instanceB、add new tempfiles to the temporary tablespaces after recoveryC、perform a media recovery and open the database with the RESETLOGS optionD、perform a media recovery and bring the database to NOARCHIVELOG mode
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？（）A、 target databaseB、 auxiliary databaseC、 third-party databaseD、 recovery catalog database
Your test database is running in NOARCHIVELOG mode. What are the implications of this？ （）A、You can perform open database backups.B、You can perform closed database backups.C、You cannot perform schema-level logical backups.D、You can perform the backup of only the SYSTEM tablespace when the database is open.
You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table： SQL FLASHBACK TABLE ORDERS TO SCN 771513； What is the prerequisite to perform Flashback Table？（）A、 You must configure OMF in your database.B、 You must enable block change tracking feature in your database.C、 You must enable ROW MOVEMENT feature on the ORDERS table.D、 You must use the Flashback Version Query before using the Flashback Table feature.
You have a file server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). You need to use Windows Backup to meet the following requirements: ·Minimize the number of scheduled backup jobs. ·Perform a scheduled normal backup to disk every Friday. ·Perform a scheduled normal backup to tape every Friday. ·Perform scheduled differential backups to tape every Monday, Tuesday, Wednesday, and Thursday. How many scheduled jobs should you create from Windows Backup? （）A、oneB、twoC、threeD、six
You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). You perform a normal backup of Server1 every Saturday. You need to implement a backup strategy for Server1 to meet the following requirements: ·Minimize the time required to restore files. ·On weekdays, back up only files that have changed since the Saturday backup. Which type of backup should you perform on weekdays? （）A、copyB、dailyC、differentialD、incremental
You use the following declaration to add a Web user control named TestUserControl.ascx to an ASP.NET page named TestPage.aspx. You add the following code to the code-behind file of TestPage.aspx. private void TestMethod（）{ ...}You define the following delegate. public delegate void MyEventHandler（）； You need to add an event of type MyEventHandler named MyEvent to TestUserControl.ascx and attach the page’s TestMethod method to the event. Which two actions should you perform？（）A、Add the following line of code to TestUserControl.ascx.cs. public event MyEventHandler MyEvent；B、Add the following line of code to TestUserControl.ascx.cs. public MyEventHandler MyEvent；C、Replace the TestUserControl.ascx reference in TestPage.aspx with the following declaration. uc:TestUserControl ID="testControl" runat="server" OnMyEvent="TestMethod"/D、Replace the TestUserControl.ascx reference in TestPage.aspx with the following declaration. uc:TestUserControl ID="testControl" runat="server" MyEvent="TestMethod"/
You are designing an upgrade strategy for a Windows Azure application that includes one web role with one instance. You have the following requirements： - Test the application on the Windows Azure platform. - Ensure that application upgrades can be rolled back. - Ensure that upgrade and rollback processes do not cause downtime. You need to recommend an approach for upgrading the application. What should you recommend？（）A、 Deploy to the Production slot. Test the application， and then perform a VIP swap.B、 Deploy to the Staging slot. Test the application， and then perform a VIP swap.C、 Deploy to the Staging slot. Test the application， and then perform a manual in-place upgrade to the Production slot.D、 Deploy to the Staging slotTest the application， and then perform an automatic in-place upgrade to the Production slot.
单选题Which of the following statements is NOT true about RMAN？（）AIt improves usability by enabling you to reuse the scripts to perform recovery operations.BIt detects block corruption while restoration and recovery operations.CIt enables you to perform block media recovery.DIt is capable to recover through unrecoverable operations， with only full database backups.
单选题The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.One of 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?（）AYou should perform a log switchBYou should make a backup of the databaseCYou should switch the database to the NONARCHIVELOG modeDYou should shut down the database instance and perform a complete database recovery
单选题You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery ：Type screen？（）A Whole databaseB TablespacesC DatafilesD Archive logsE Redo logs
单选题An important tablespace of your database is dropped by mistake. You use the Flashback Database feature to retrieve the tablespace. You perform the following steps to retrieve the tablespace： 1. You log on to Enterprise Manager as SYSDBA. 2. You select the maintenance screen. 3. You choose Perform Recovery option on the maintenance screen. 4. You choose Whole Database in the Object Type drop-down list Perform Recovery： Type screen. 5. You choose Recover to Current Time from the Operation Type on the Perform Recovery： Type screen. 6. You provide the Host Credentials for a database user. on the Perform Recovery： Type screen. 7. You click the continue button. An information screen appears saying that the database is unavailable. What is this information screen？（）ARecovery ManagerBRecovery WindowCRecovery WizardDEnterprise Manager Home Page
多选题You have a database with the following tablespaces： SYSTEM， SYSAUX， UNDO， USERS， TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday. Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task？（）ASYSTEMBSYSAUXCUNDODUSERSETEMPFThis restore is not possible
多选题Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）AThe target database must be in NOARCHIVELOG mode.BNo backup is required of the database before you perform a TSPITR.CYou must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.DIf you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.EIf you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.
单选题To perform a database point-in-time recovery using RMAN， after database restoration， you must ensure that the database is in which of the following states？（）AOPENBMOUNTCNOMOUNTDCLOSE
单选题The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of 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？（）A You should perform a log switchB You should make a backup of the databaseC You should switch the database to the NONARCHIVELOG modeD You should shut down the database instance and perform a complete database recovery
单选题You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). On Server1, you have the following backup schedule: ·Normal backups every Saturday at 01:00 ·Differential backups every weekday at 02:00, except on Saturday You need to perform a complete manual backup of Server1 on Tuesday. The backup must not change which files are backed up during the next scheduled backup. Which type of backup should you perform? （）AcopyBdailyCincrementalDnormal
单选题If you are guilty of failure to properly perform your duties as Operator of Uninspected Towing Vessels，which of the following actions may NOT be taken? （）AIssuance of a letter of warningBSuspension of your licenseCRevocation of your licenseDA fine placed against your license
单选题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？（）A target databaseB auxiliary databaseC third-party databaseD recovery catalog database