You are upgrading the database servers that are used by all 

题目
单选题
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.

参考答案和解析
正确答案: A
解析: 暂无解析
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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?()

  • A、Database Control
  • B、Management Server
  • C、Management Repository
  • D、Application Server Control
  • E、Oracle Management Agent

正确答案:E

第2题:

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. Now according to the company requirement, you are designing a consolidated repository of performance data. You must make sure that the four requirements below are met: the data collector is used to gather performance information; a single database stores performance information for all instances; performance information that is older than 15 days is deleted; reduce the administrative effort to manage performance to the least. So what action should you perform to achieve this goal? () 

  • A、You should create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances. 
  • B、You should configure a management data warehouse process on each instance, then use this process to store and delete performance data in a single database for all instances. 
  • C、You should configure an automated server-side trace process on each instance, then use this process to store and delete performance data in a single database for all instances. 
  • D、You should create and schedule a single Microsoft SQL Service Integration Services (SSIS) package process, then use this process to store and delete performance data in a single database for all instances. 

正确答案:B

第3题:

You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()

A. The backup as copy can only be taken to disk

B. The backup as copy can only be taken to tape

C. Backup can be performed only when the instance is shutdown

D. Backup will constitute all used and unused blocks in the database


参考答案:A, D

第4题:

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

正确答案:A

第5题:

You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()

  • A、The backup as copy can only be taken to disk
  • B、The backup as copy can only be taken to tape
  • C、Backup can be performed only when the instance is shutdown
  • D、Backup will constitute all used and unused blocks in the database

正确答案:A,D

第6题:

You have an Exchange Server 2010 organization that contains five Mailbox servers.Your Active Directory domain contains five domain controllers in a single site. You create a new mailbox database.You notice that the database fails to mount. You need to ensure that the database mounts as soon as possible. What should you do?()

  • A、Configure all domain controllers as Global Catalog servers.
  • B、Install the Exchange Server 2010 Administration Tools on a domain controller.
  • C、Force the replication of the Active Directory Domain partition between all domain controllers.
  • D、Force the replication of the Active Directory Configuration partition between all domain controllers.

正确答案:D

第7题:

Which one of the following answer choices below is true regarding the OSPF topology database?()

  • A、All entries in the topology database will be included on each router.
  • B、All routers in the same OSPF area will have one topology database.
  • C、The Dijkstra algorithm is used in the creation of the topology database.
  • D、LSA packets are used to update and maintain the topology database.

正确答案:D

第8题:

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.

第9题:

You are designing a VPN Server strategy to meet the business and technical requirement.  What should you do? ()

  • A、 Configure all client computers to point to a VPN server in Amsterdam.
  • B、 Configure all client computers to use Multilink Bandwidth Allocation Protocol (BAP).
  • C、 Create a network Load Balancing cluster of VPN servers.
  • D、 Create a shutdown script for the VPN servers to delete the host(A) resource record of the VPN sever from the DNS database when the VPN server are shutdown.

正确答案:C

第10题:

You have an Exchange Server 2010 organization that contains 20 Mailbox servers.You plan to create 10 mailbox databases on each Mailbox server. You need to create a naming convention for all mailbox databases.  What should you include in your naming convention()? 

  • A、For each mailbox database, provide a database name that is unique within the organization.
  • B、For each mailbox database, provide a database name that is unique within the Mailbox server.
  • C、For each mailbox database file, provide a file name that is unique within the organization.
  • D、For each mailbox database file, provide a file name that is unique within the Mailbox server.

正确答案:A

更多相关问题