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 err

题目

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.
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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.


正确答案:A
解析:Explanation: SQL Server 2000 failover clustering provides high availability support by allowing us to configure one failover cluster to automatically, with no manual configuration, fail over to any other node in the failover cluster configuration. In this way, we minimize system downtime and provide high server availability during an operating system failure or a planned upgrade. Before SQL Server 2000 failover clustering can be set up, we must install Windows NT 4.0, Enterprise Edition, Windows 2000 Advanced Server or Windows 2000 Datacenter Server, and the Microsoft Cluster Service (MSCS).

In this scenario a cluster would be preferred to a standby server because it would be available immediately. A standby server on the other would require manual configuration and more time to become online.

Incorrect Answers:
B: A standby server would require you to reconfigure clients to allow it to connect to the standby server when the main server goes down. It would require at least several minutes of manual administration before the standby server would be operational. But the scenario requires that no reconfiguration of the client computers should be necessary. Therefore we should use a SQL Server 2000 cluster not a standby server.

Note: A standby server is a second server that contains a copy of the databases on the primary server and that can be brought online in the event of a primary server failure or due to scheduled maintenance on the primary server. This allows users to continue working with databases when the primary server becomes unavailable. When the primary server becomes available again, any changes to the standby server's copies of databases must be restored back to the primary server.

C: The Microsoft Distributed Transaction Coordinator coordinates distributed transactions, but would not increase availability.

Note: The Microsoft Distributed Transaction Coordinator (MS DTC) is a transaction manager that allows client applications to include several different sources of data in one transaction. MS DTC coordinates committing the distributed transaction across all the servers enlisted in the transaction.

An installation of SQL Server 2000 can participate in a distributed transaction by calling stored procedures on remote servers running SQL Server, automatically or explicitly promoting the local transaction to a distributed transaction and enlist remote servers in the transaction, and making distributed updates that update data on multiple OLE DB data sources. If these OLE DB data sources support the OLE DB distributed transaction interface, SQL Server 2000 can also enlist them in the distributed transaction. The MS DTC service coordinates the proper completion of the distributed transaction to ensure that either all of the updates on all the servers are made permanent, or, in the case of errors, all erased.

D: With Federated SQL Server 2000 servers, SQL Server 2000 databases can be spread across a group of autonomous database servers. These are capable of supporting the processing growth requirements of the largest Web sites and enterprise data-processing systems built with Microsoft Windows DNA, which divides the processing units of a data processing system into logical tiers. This however does not improve availability.

第2题:

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).

正确答案:D

第3题:

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.


参考答案:D

第4题:

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

正确答案:A

第5题:

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 Recoveryplans
  • B、What are plans for datamigration
  • C、What storage system space isavailable
  • D、DoesiSCSI meet the needs

正确答案:B

第6题:

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 wcs
  • C、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

正确答案:B

第7题:

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) SP2
  • B、all domain controllers to Windows Server 2008 (x86)
  • C、all Exchange Server 2003 servers to Exchange Server 2007 SP2
  • D、all Exchange Server 2007 SP1 servers to Exchange Server 2007 SP2

正确答案:D

第8题:

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


参考答案:A

第9题:

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.

正确答案:C

第10题:

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 Control
  • B、Management Server
  • C、Management Repository
  • D、Application Server Control
  • E、Oracle Management Agent

正确答案:E

更多相关问题