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.
相关考题：
I wonder how many years ago _______.A.did you father retireB.your father retiredC.has your father retiredD.your father has retired
You create a large, n-tier Web application that has a custom event tracking system. You need to create a custom event type that enables your event tracking system to record all relevant event details for all types of events. The events must be stored in Microsoft SQL Server.From which base type should your custom event type inherit? （）A. IWebEventCustomEvaluatorB. WebEventProviderC. WebBaseEventD. WebAuditEvent
Given that the current directory is empty, and that the user has read and write permissions, and the following:Which statement is true?() A.Compilation fails.B.The file system has a new empty directory named dir.C.The file system has a new empty directory named newDir.D.The file system has a directory named dir, containing a file f1.txt.E.The file system has a directory named newDir, containing a file f1.txt.
Your vessel has a gasoline engine and a mechanical exhaust ventilation system．BEFORE starting the engine，the exhaust blower should be run long enough to ______．A.warm up the exhaust blower motorB.provide a proper supply of fresh air for the engine（s）C.see the system is in good operating conditionD.insure at least one complete change of air in the compartments concerned
When an ICMP redirect is received， which of the following options is the most appropriate to conclude？（）A、A routing table has changedB、The IP address has changedC、The system has become a gatewayD、A hacker is posing a threat to the system
Your company has an Active Directory domain that has two domain controllers named DC1 and DC2.You prepare both servers to support event subscriptions. On DC1, you create a new default subscription for DC2. You need to review system events for DC2. Which event log should you select？（）A、system log on DC1B、application log on DC2C、Forwarded Events log on DC1D、Forwarded Events log on DC2
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
One of your best customers has limited funding and is interested in the ability to increase a system’s computing power as needed. Which of the following System x server attributes should the Sales Specialist promote？（）A、Ability to hot-plug additional processors on demandB、Low cost of System x servers makes scaling out an optionC、"Pay as you Grow" scalability of the IBM System x3950 serverD、Integration of System x servers with the existing servers using an interconnect
A system was rebooted and is taking a long time toreturn. The administrator has logged into the HMC and sees reference code 0c9. What does this mean?（）A、The system is configuring a device.B、A system initiated dump has started.C、The system is varyingon a volume group.D、The system is running an inbuilt self test.
Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（） A、 Yes， if the database is in ARCHIVELOG modeB、 Yes， if the database is in NOARCHIVELOG modeC、 No， the backup is not usable in any wayD、 Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE
Your workgroup’s project is critical and there is no time for rebuilding the Windows 2000 Professional desktops in case of disaster. Your company has not yet established automated system replacement that Windows 2000 can provide. What is your most comprehensive option for disaster recovery at this time？（）A、Back up each project desktop with the System State option enabled.B、Back up everything on each desktop as a backup option and perform this daily. Create an Emergency Repair Disk weekly to keep the registry backup current.C、Back up everything on each desktop as a backup option and perform this daily.D、Back up each project desktop with the System State option enabled， including the systerotected files.
Your company has a main office and 10 branch offices. You have an Exchange Server 2010 organization. All Exchange servers are installed on virtual machines. You need to create a monitoring plan for the Exchange servers that meets the following requirements：.Identify Exchange server errors .Provide alerts when Exchange services are stopped .Produce statistical analysis and reporting Which tool should you include in the plan？（）A、Microsoft System Center Service ManagerB、Microsoft System Center Operations ManagerC、Microsoft System Center Configuration ManagerD、Microsoft System Center Virtual Machine Manager
You create a large, n-tier Web application that has a custom event tracking system. You need to create a custom event type that enables your event tracking system to record all relevant event details for all types of events. The events must be stored in Microsoft SQL Server. From which base type should your custom event type inherit? （）A、IWeb Event Custom EvaluatorB、Web Event ProviderC、Web Base EventD、Web Audit Event
Your company has a domain controller server that runs the Windows Server 2008 R2 operating system. The server is a backup server. The server has a single 500-GB hard disk that has three partitions for the operating system， applications， and data. You perform daily backups of the server. The hard disk fails. You replace the hard disk with a new hard disk of the same capacity. You restart the computer on the installation media. You select the Repair your computer option. You need to restore the operating system and all files. What should you do（）A、Select the System Image Recovery option.B、Run the Imagex utility at the command prompt.C、Run the Wbadmin utility at the command prompt.D、Run the Rollback utility at the command prompt.
Your company has an Active Directory Domain Services (AD DS) domain. You virtualize applications by using Microsoft Application Virtualization (App - V). You are creating an application virtualization package. Which sh ould you use?（）A、Microsoft Application Virtualization SequencerB、Microsoft Application Virtualization Desktop ClientC、Microsoft System Center Application Virtualization Streaming ServerD、Microsoft System Center Application Virtualization Management Server
You create a large, n-tier Web application that has a custom event tracking system. You need to create a custom event type that enables your event tracking system to record all relevant event details for all types of events. The events must be stored in Microsoft SQL Server. From which base type should your custom event type inherit? （）A、IWebEventCustomEvaluatorB、WebEventProviderC、WebBaseEventD、WebAuditEvent
Your company has a domain controller that runs Windows Server 2008. The server is a backup server. The server has a single 500-GB hard disk that has three partitions for the operating system， applications， and data. You perform daily backups of the server. The hard disk fails. You replace the hard disk with a new hard disk of the same capacity. You restart the computer on the installation media. You select the Repair your computer option. You need to restore the operating system and all files. What should you do（）A、Select the Startup repair option.B、Select the System restore option.C、Run the Rollback utility at the command prompt.D、Run the Wbadmin utility at the command prompt.
单选题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
单选题Your company has a main office and a branch office. Your network contains a single Active Directory domain. You install 25 Windows Server 2008 R2 member servers in the branch office. You need to recommend a storage solution that meets the following requirements： èEncrypts all data on the hard disks èAllows the operating system to start only when the authorized user is present What should you recommend？（）AEncrypting File System （EFS）BFile Server Resource Manager （FSRM）CWindows BitLocker Drive Encryption （BitLocker）DWindows System Resource Manager （WSRM）
单选题Your vessel has run aground and upon taking fuel oil tank soundings, you find that a fuel tank level has increasedYou therefore should suspect （）.Acondensation in the fuel tankBa crack in the hull portion of the fuel tankCa load of bad fuelDcontamination from the saltwater flushing system
单选题You need to verify whether your computer can obtain all of the latest operating system updates. What should you do？ （）AConfirm that your computer has a Microsoft Windows Experience Index base score above 3.0. BRun Microsoft Windows Vista Upgrade Advisor.CConfigure Windows Defender to detect updates before scanning.DValidate your Windows installation from the Microsoft Windows Genuine Advantage Web page.
单选题Your network consists of a single Active Directory forest. The sales department in your company has 600 Windows Server 2008 R2 servers. You need to recommend a solution to monitor the performance of the 600 servers. Your solution must meet the following requirements： èGenerate alerts when the average processor usage is higher than 90 percent for 20 minutes. èAutomatically adjust the processor monitoring threshold to allow for temporary changes in the workload. What should you recommend？（）AInstall Windows System Resource Manager （WSRM） on each server.BDeploy Microsoft System Center Operations Manager （OpsMgr）.CDeploy Microsoft System Center Configuration Manager （SysMgr）.DConfigure Reliability and Performance Monitor on each server.
单选题Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（）A Yes， if the database is in ARCHIVELOG modeB Yes， if the database is in NOARCHIVELOG modeC No， the backup is not usable in any wayD Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE
单选题When an ICMP redirect is received， which of the following options is the most appropriate to conclude？（）AA routing table has changedBThe IP address has changedCThe system has become a gatewayDA hacker is posing a threat to the system