Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements?（）A、Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.B、Capture the plans from the previous version using STS and then load them into the stored outline.C、Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).D、Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.
Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements?（）
- A、Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.
- B、Capture the plans from the previous version using STS and then load them into the stored outline.
- C、Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).
- D、Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.
相关考题：
We are of course()that the time for completion of your project has already been exceeded. A、knowB、to knowC、awareD、sure
Other than academic success, what has been your greatest achievement up to date? What do you see as your personal strength, why?
A system administrator has just applied an update to an AIX system to correct a problem, The APAR number is IX49035 and was shipped as part of the PTF number U437542. After applying the APAR fix, the administrator wants to ensure that the fix is applied before informing the system users of the corrected problem. Which of the following commands should the system administrator run to verify that the APAR fix has been applied to the system?（）A.lslpp -f IX49035B.lslpp -fB U437542C.instfix -f IX49035D.instfix -ik IX49035
Who has done your hair，Susan?（）AMy hair has been doneBThat hair stylistCMy hairstyle is coolDI have it cut
An administrator has added a new device to a system and wants to determine if it has been correctly added to the ODM database. Which command would the system administrator use？（）A、odmgetB、odmaddC、odmshowD、odmcreate
Who has done your hair，Susan?（）A、My hair has been doneB、That hair stylistC、My hairstyle is coolD、I have it cut
Cisco IDS sensors form the eyes and ears of your Cisco network intrusion detection system. Placing sensors correctly throughout your network is crucial to successfully implementing your Cisco intrusion detection system .Which two of these are characteristics of an IDS sensor？（）A、 has a permissive interface that is used to monitor networksB、 is an active device in the traffic pathC、 passively listens to network trafficD、 has a promiscuous interface that is used to monitor the network
Which of the following is the MOST important reason for referencing the HCL？（）A、 To ensure that all hardware being used has previously been testedB、 To ensure that all hardware being used has the latest firmwareC、 To ensure that all hardware being used is the most energy efficientD、 To ensure that all hardware being used can be upgraded in the future
A patch has been applied to the operating system. After rebooting, the system is hung. Which of the following commands should have been performed to prevent the system from hanging?（）A、 lppchk, bosboot B、 lslpp -l, oslevel C、 installp -C, lppchk D、 bosboot, synclvodm
A system administrator has just finished upgrading a system to AIX 5.2. If there are future problems， the system administrator would like to add an entry to the AIX errorlog to record this event. Which of the following commands can be issued for this purpose？（）A、/usr/bin/errmsg "System upgraded to AIX 5.2"B、/usr/bin/errlog "System upgraded to AIX 5.2"C、/usr/bin/errupdate "System upgraded to AIX 5.2"D、/usr/bin/errlogger "System upgraded to AIX 5.2"
A new application has been added to a system which needs to automatically be started at system startup. The system administrator has decided to accomplish this by using the /etc/inittab file. Which command would be used to accomplish this in a supported manner？（）A、viB、mkitabC、telinitD、startsrc
A system administrator has been asked to document the hardware configuration of a system. Which command can be used to assist in this task？（）A、lscfgB、mkdevC、lslppD、cfgmgr
The System Administrator has set up shared processors on three partitions in the p5 590 system. The shared processors have been set to uncapped. The system administrator notices that the logical partition is acting like it is capped. What is the most probable cause?（）A、The uncapped weight has been set to 0.B、The uncapped weight has been set to 128.C、The processing unit for that partition was set to .1 processing units. A full processor was assigned.D、The processing unit for that partition was set to 0.50 processing units. A full processor was assigned.
System configurations on the HMC have been backed up correctly. After a restore, the partitions are defined with different characteristics than the running systems. What is the most probable cause of this problem?（）A、The LPAR Configuration backup is corruptB、The LPAR Configuration has been altered using DLPARC、The LPAR Configuration backup was performed on a different HMCD、The LPAR Configuration has been altered through the Advanced System Management Interface （ASMI） on the server after the backup was performed
A file system has been corrupted and needs to be restored. Which file contains the ufsdump levels for this file system？ （）A、 /etc/backupB、 /etc/ufsdumpC、 /etc/dumpdatesD、 /etc/fsdumpdates
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE？（）A、to enable operating system authentication for a remote clientB、to restrict the scope of administration to identical operating systemsC、to allow the start up and shut down of the database from a remote clientD、to enable the administration of the operating system from a remote clientE、to disable the administration of the operating system from a remote client
Initially， for the Automatic Workload Repository （AWR） statistics，the retention period is set to 7 days， the collection interval is set to 30 minutes and the collection level is set to Typical in your production database. You have been using the Memory Advisor for the last three months to generate recommendations for tuning memory components. However，when you observe the Memory Advisor on a Friday，you find that the statistics are available only for two days， Thursday and Friday，of that week. What would have caused the statistics to be removed？（）A、On Wednesday， the statistics have been purged.B、On Wednesday， the retention period has been set to zero.C、On Wednesday， the collection interval has been set to zero.D、On Wednesday， the collection level has been changed to All.E、On Wednesday， the retention period has been set to one day.F、On Wednesday， the retention period has been set to two daysG、On Wednesday, the collection level has been changed to Typical.H、On Wednesday, the collection interval has been set to 1440 minutes.
A system administrator has just applied an update to an AIX system to correct a problem, The APAR number is IX49035 and was shipped as part of the PTF number U437542. After applying the APAR fix, the administrator wants to ensure that the fix is applied before informing the system users of the corrected problem. Which of the following commands should the system administrator run to verify that the APAR fix has been applied to the system?（）A、lslpp -f IX49035B、lslpp -fB U437542C、instfix -f IX49035D、instfix -ik IX49035
单选题Purging air from a hydraulic system is necessary when（）Aadding small amounts of oil to the systemBthe system has been overheatedCthe system has been drained and then filled with new oilDthe system has been idle for a long period of time
单选题A medical customer has a rack with four BladeCenter H chassis that have been operating normally for several months. After installing a new rack of servers in the data center, the system administrator notices the blowers in the BladeCenters have increased their speed. Which of the following caused this problem? （）AThe room temperature has reached 23C (73.4F). BA Blade within the chassis has been shut down. CThe ambient temperature in the data center has increased DOne of the additional System X servers in the BladeCenter rack has failed.
单选题You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE？（）Ato enable operating system authentication for a remote clientBto restrict the scope of administration to identical operating systemsCto allow the start up and shut down of the database from a remote clientDto enable the administration of the operating system from a remote clientEto disable the administration of the operating system from a remote client
填空题What has been done by the heating system supplier?____ has been asked to find out the cause of the accident.
单选题A system administrator has just finished upgrading a system to AIX 5.2. If there are future problems， the system administrator would like to add an entry to the AIX errorlog to record this event. Which of the following commands can be issued for this purpose？（）A/usr/bin/errmsg System upgraded to AIX 5.2B/usr/bin/errlog System upgraded to AIX 5.2C/usr/bin/errupdate System upgraded to AIX 5.2D/usr/bin/errlogger System upgraded to AIX 5.2
单选题In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）Aflash back the databaseBperform point-in-time recoveryCperform a full database recoveryDdrop and re-create the tablespaceEuse Recovery Manager （RMAN） to recover the database
单选题Who has done your hair，Susan?（）AMy hair has been doneBThat hair stylistCMy hairstyle is coolDI have it cut
单选题You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）ARestore all the data files and open the databaseBCreate the data file and performtablespacerecoveryCNo need to restore any file， just recover the databaseDRestore only the system data file and recover the databaseERestore only lost date file and performtablespacerecovery
单选题A patch has been applied to the operating system. After rebooting, the system is hung. Which of the following commands should have been performed to prevent the system from hanging?（）A lppchk, bosboot B lslpp -l, oslevel C installp -C, lppchk D bosboot, synclvodm