You are upgrading the database servers that are used by all of the companys applications. As the first step in the upgrade, you upgrade the development database servers. You need to verify that the upgrade of the database servers did not introduce any errors into the databases. What should you do?（） A、Execute unit test scripts for each stored procedure in each database.B、Execute the stored procedures in the SQL Server Management Studio debugger, and verify the results.C、Set the database compatibility level on the database servers to 80.D、Execute the application user interface test scripts to verify proper operation.
You are upgrading the database servers that are used by all of the companys applications. As the first step in the upgrade, you upgrade the development database servers. You need to verify that the upgrade of the database servers did not introduce any errors into the databases. What should you do?（）
- A、Execute unit test scripts for each stored procedure in each database.
- B、Execute the stored procedures in the SQL Server Management Studio debugger, and verify the results.
- C、Set the database compatibility level on the database servers to 80.
- D、Execute the application user interface test scripts to verify proper operation.
相关考题：
Your network contains a database server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2).Server1 has the following hardware configurations:·A single processor that supports hyper-threading·Dual processor motherboard·Two hard disks·2 GB of RAMThe first disk contains all the files for the operating system and applications. The second disk is empty.Hyper-threading is disabled in the BIOS.Users report a slow response when they query the database on Server1.You monitor Server1 for one day and receive the performance statistics shown in the following table.You need to improve database performance.What should you do? （）A. Upgrade the RAM to 4 gb.B. Install a second processor.C. Enable hyper-threading in the bios.D. Move the database to the second disk.
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 are the administrator of two Microsoft Windows 2000 advanced server computers. On these servers, you are configuring a database that will store accounting information for your company.The data must be available at all times. Interruptions in data connectivity should not last longer than five minutes. Any changes to the database should not require you to reconfigure the client computers.How should you configure the database?A．Configure the database on the two servers as a SQL Server 2000 cluster.B．Configure the database on one server, and then configure a standby database on the second server.C．Configure the database on each server. Use Microsoft Distributed Transaction Coordinator to keep the two servers perfectly synchronized.D．Configure the database as a federated database, and then partition half the data on each server.
What is the correct order of steps for upgrading a cisco wcs？（）A、back up the database， stop the wcs， upgrade the wcs， restore the database， start the wcs B、stop the wcs， back up the database， upgrade the wcs， restore the database， start the wcsC、back up the database， stop the wcs， upgrade the wcs， start the wcs， restore the database D、stop the wcs， back up the database， upgrade the wcs， start the wcs， restore the database
You have an Active Directory forest that contains three sites named Site1， Site2， and Site3. Each site contains two Exchange Server 2007 Client Access servers， two Mailbox servers， and two Hub Transport servers. All Exchange Server 2007 servers have Exchange Server 2007 Service Pack 1 （SP1） installed. You need to ensure that you can deploy Exchange Server 2010 servers in Site1. You must achieve this goal by using the minimum amount of administrative effort. What should you do（）？ A、Upgrade all Client Access servers in the organization to Exchange Server 2007 Service Pack 2 （SP2）.B、Upgrade all Exchange Server 2007 servers in Site1 to Exchange Server 2007 Service Pack 2 （SP2）.C、Upgrade all Exchange Server 2007 servers in the organization to Exchange Server 2007 Service Pack 2 （SP2）.D、Upgrade all Exchange Server 2007 servers in Site1 and all Client Access servers in the organization to Exchange Server 2007 Service Pack 2 （SP2）.
Your company has an Active Directory forest. The network contains Exchange Server 2007 Service Pack 1 （SP1） and Exchange Server 2003 ServicePack 2 （SP2） servers. All domain controllers run Windows Server 2003 （x86） Service Pack 1 （SP1）. You plan to deploy Exchange Server 2010 on the network. You need to recommend changes to the servers so that you can deploy Exchange Server 2010 servers. What should you upgrade first？（）A、all domain controllers to Windows Server 2003 （x64） SP2B、all domain controllers to Windows Server 2008 （x86）C、all Exchange Server 2003 servers to Exchange Server 2007 SP2D、all Exchange Server 2007 SP1 servers to Exchange Server 2007 SP2
A customer has a combination of fifteen Windows file servers with direct attached storage and three Power Systems with AIX database servers SAN attached to a DS4700. They would like to upgrade and plan for 40 TB capacity. The customer needs to move to a more scalable storage system to include all servers. Which of the following would be most appropriate to ask first？（）A、What are Disaster RecoveryplansB、What are plans for datamigrationC、What storage system space isavailableD、DoesiSCSI meet the needs
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL@utlu111i.sql Which statement about the execution of this script is true?（）A、It must be executed from the Oracle Database 11g environment.B、It must be executed only after the SYSAUX tablespace has been created.C、It must be executed from the environment of the database that is being upgraded.D、It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.E、It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
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 work as a database administrator for Certkiller .com. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）A、Database ControlB、Management ServerC、Management RepositoryD、Application Server ControlE、Oracle Management Agent
You are designing an organizational unit （OU） structure to manage the New App servers. What should you do？ （）A、 Create one OU that includes both the web servers and the database servers.B、 Create one OU that includes the web servers and one OU that includes the database servers.C、 Create one OU that includes the web servers. Then Place the database servers in the Computer Containers.D、 Place the web server and the database servers in the Domain Controller OU.
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is an internal application which uses Analysis Services and Reporting Services. You use the application on the basis of SQL Server 2008. According to the requirement of company security policy, the surface area for all the deployed components of SQL Server 2008 should be configured. You have to implement the security policy and devise a method to evaluate the security policy against other database servers. What should you do?（） A、You should create policies based on the appropriate facets. Apply the policies against a server group. The server group includes the database servers that need to be configured B、You should create a Transact-SQL script based on the sp_configure stored procedure. Use a configuration server to run the script against a server group that includes the database servers that need to be configured C、You should edit the RSReportServer.config configuration file. Distribute the file to all database servers that need to be configured D、You should analyze your database servers by using the SQL Server Best Practices Analyzer (BPA). Implement the recommendations of the BPA
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a SQL Server 7.0 database. You upgrade the database to the SQL Server instance. According to the company requirement, you must make sure that suspect pages can be detected in the database. So what action should you perform to achieve this goal?（）A、For the database, you should turn on the TRUSTWORTHY database optionB、For the database, the PAGE_VERIFY database option should be set to CHECKSUMC、For the database, the database compatibility level option should be set to 10D、For the model database, the PAGE_VERIFY database option should be set to TORN_PAGE_DETECTION.
You have an Active Directory forest that contains three sites named Site1， Site2， and Site3. Each site contains two Exchange Server 2007 Client Access servers， two Mailbox servers， and two Hub Transport servers. All Exchange Server 2007 servers have Exchange Server 2007 Service Pack 1 （SP1） installed.You need to ensure that you can deploy Exchange Server 2010 servers in Site1.You must achieve this goal by using the minimum amount of administrative effort. What should you do？（）A、Upgrade all Client Access servers in the organization to Exchange Server 2007 Service Pack 2 （SP2）.B、Upgrade all Exchange Server 2007 servers in Site1 to Exchange Server 2007 Service Pack 2 （SP2）.C、Upgrade all Exchange Server 2007 servers in the organization to Exchange Server 2007 Service Pack 2 （SP2）.D、Upgrade all Exchange Server 2007 servers in Site1 and all Client Access servers in the organization to Exchange Server 2007 Service Pack 2 （SP2）.
You have an Exchange organization that contains Exchange 2000 Server Service Pack 3 （SP3）， Exchange Server 2003 Service Pack 2 （SP2）， and Exchange Server 2007 Service Pack 1 （SP1） servers. You need to transition the organization to Exchange Server 2010. What should you do first？（）A、Remove all Exchange Server 2007 SP1 servers from the organization.B、Remove all Exchange 2000 Server and all Exchange Server 2003 servers from the organization.C、Remove all Exchange 2000 Server servers from the organization，and then upgrade all Exchange server 2007 servers to SP2.D、Remove all Exchange Server 2003 servers from the organization，and then upgrade all Exchange server 2007 servers to SP2.
Your company has several branch offices. Your network consists of a single Active Directory domain. Each branch office contains domain controllers and member servers. The domain controllers run Windows Server 2003 SP2. The member servers run Windows Server 2008 R2. Physical security of the servers at the branch offices is a concern. You plan to implement Windows BitLocker Drive Encryption （BitLocker） on the member servers. You need to ensure that you can access the BitLocker volume if the BitLocker keys are corruptedon the member servers. The recovery information must be stored in a central location. What should you do？（）A、Upgrade all domain controllers to Windows Server 2008 R2.Use Group Policy to configure Public Key policies.B、Upgrade all domain controllers to Windows Server 2008 R2. Use Group Policy to enable Trusted platform Module（TPM） backups to Active Directory.C、Upgrade the domain controller that has the schema master role to Windows Server 2008 R2. Use group Policy to enable a Data Recovery Agent （DRA）.D、Upgrade the domain controller that has the primary domain controller （PDC） emulator role to windows Server 2008 R2. Use Group Policy to enable a Data Recovery Agent （DRA）.
You need to configure the security settings for the new app servers. Which two actions should you perform?（）A、Create a Group policy object (GPO) for the web servers.B、Create a Group policy object (GPO) for the database servers.C、Modify the Default Domain Policy.D、Modify the Default Domain Controllers Policy.
You need to ensure that the network administrators are able to administer the NewApp database servers. Which two actions should you perform?（）A、Create an organizational unit (OU) for all users who log on to any of the NewApp servers.B、Create an organizational unit (OU) named NewApp Users for the NewApp users.C、Create an organizational unit (OU) named NewApp Servers for the NewApp servers.D、Create a Group Policy object (GPO) for the NewApp Users OU to enforce the use of IPSec.E、Create a global group for all NewApp servers. Add this group to the NewApp Servers OU.F、Create a Group Policy object (GPO) for the NewApp Servers OU to enforce the use of smart cards.
You are designing an organizational unit (OU) structure to manage the New App servers. What should you do?（）A、Create one OU that includes both the web servers and the database servers. B、Create one OU that includes the web servers and one OU that includes the database servers. C、Create one OU that includes the web servers. Then Place the database servers in the Computer Containers.D、Place the web server and the database servers in the Domain Controller OU.
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. On DB1, quite few logged operations are performed. Now according to the requirement of the company CIO, you must validate that the database can be restored to a specific point in time. So what action should you perform to achieve this goal? （） A、You should verify that the simple recovery model is used by the database.B、You should verify that the full recovery model is used by the database.C、You should verify that the checksum page verify option is used by the database. D、You should verify that the bulk-logged recovery model is used by the database.
You are the network administrator for TestKing. The network consists of a single Active Directory domain named testking.com. All domain controller run Windows Server 2003. employes three database administrators who administer seven databases servers that run Windows Server 2003. The database administrators occasionally restore a database server after a disaster. To restore a server, database administrators need the rights required to perform the following tasks: 1. Back up files and folders 2. Restore files and folders. 3. Restore the System State data. You need to assign the database administrators the rights that they require to perform the specified tasks. For security reasons, you must not assign the administrators more rights than they require to perform the tasks. What should you do?（）A、Add the database administrators' user accounts to the Administrators group on each of the database servers.B、Add the database administrators' user accounts to the Power Users group on each of the database servers.C、Add the database administrators' user accounts to the Backup Operators group on each of the database servers.D、Add the database administrators' user accounts to the Backup Operators group on one of the domain controllers.E、Add the database administrators' user accounts to the Server Operators group on one of the domain controllers.
单选题You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. On DB1, quite few logged operations are performed. Now according to the requirement of the company CIO, you must validate that the database can be restored to a specific point in time. So what action should you perform to achieve this goal? （）AYou should verify that the simple recovery model is used by the database.BYou should verify that the full recovery model is used by the database.CYou should verify that the checksum page verify option is used by the database. DYou should verify that the bulk-logged recovery model is used by the database.
单选题You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）ADatabase ControlBManagement ServerCManagement RepositoryDApplication Server ControlEOracle Management Agent
单选题You are designing an organizational unit （OU） structure to manage the New App servers. What should you do？ （）A Create one OU that includes both the web servers and the database servers.B Create one OU that includes the web servers and one OU that includes the database servers.C Create one OU that includes the web servers. Then Place the database servers in the Computer Containers.D Place the web server and the database servers in the Domain Controller OU.
单选题Your network contains two Exchange Server 2010 Service Pack 1 （SP1） Mailbox servers. You create a database availability group （DAG）.You need to install all of the Failover Clustering components on to the Mailbox servers. What should you do？（）AAdd both servers to the DAGBInstall the Application server role on both serversCRun Setup /roles：Mailbox /NewCIMS on both serversDRun the Start-ClusteredMailboxServer cmdlet on both servers
单选题You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL@utlu111i.sql Which statement about the execution of this script is true?（）AIt must be executed from the Oracle Database 11g environment.BIt must be executed only after the SYSAUX tablespace has been created.CIt must be executed from the environment of the database that is being upgraded.DIt must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.EIt must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
单选题You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is an internal application which uses Analysis Services and Reporting Services. You use the application on the basis of SQL Server 2008. According to the requirement of company security policy, the surface area for all the deployed components of SQL Server 2008 should be configured. You have to implement the security policy and devise a method to evaluate the security policy against other database servers. What should you do?（）AYou should create policies based on the appropriate facets. Apply the policies against a server group. The server group includes the database servers that need to be configured BYou should create a Transact-SQL script based on the sp_configure stored procedure. Use a configuration server to run the script against a server group that includes the database servers that need to be configured CYou should edit the RSReportServer.config configuration file. Distribute the file to all database servers that need to be configured DYou should analyze your database servers by using the SQL Server Best Practices Analyzer (BPA). Implement the recommendations of the BPA