单选题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?（）AExecute unit test scripts for each stored procedure in each database.BExecute the stored procedures in the SQL Server Management Studio debugger, and verify the results.CSet the database compatibility level on the database servers to 80.DExecute 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.
参考解析
解析：
暂无解析
相关考题：
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 diskB. The backup as copy can only be taken to tapeC. Backup can be performed only when the instance is shutdownD. Backup will constitute all used and unused blocks in the database
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.
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 ControlB、Management ServerC、Management RepositoryD、Application Server ControlE、Oracle Management Agent
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.
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.
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.
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 diskB、The backup as copy can only be taken to tapeC、Backup can be performed only when the instance is shutdownD、Backup will constitute all used and unused blocks in the database
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.
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 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.
You have an Exchange organization.All servers in the organization have Exchange Server 2010 Service Pack 1 （SP1） installed. The organization contains two Mailbox servers named Server1 and Server2.Each Mailbox server has one mailbox database and one public folder database. You discover that all users create public folders on Server1 only. You need to ensure that all users create public folders on Server2 only. What should you do？（）A、Move all mailboxes to Server2.B、Modify the properties of both mailbox databases.C、Remove all public folder replicas from Server1.D、Modify the properties of both public folder databases.
Your organization has 5 Mailbox servers and 5 Active directory servers.You need to install a new Mailbox server.During the installation you notice the mailbox database will not mount. What should you do to make sure you can install the mailbox server：（）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 AD domain partition between all domain controllers.D、Force the replication of the AD configuration partition between all domain controllers.
You are the network administrator for Testking.com. The TestKing network contains seven application servers. Each application server runs a database application named TestKingApp. Requirements for TestKingApp state that when you add a new user, you must add the user to the server that has the most available disk space. You need to ensure that you meet the requirements when you add new users to TestKingApp. What should you do?（）A、Use Event Viewer to review the application logs on each of the seven servers.B、Use Performance Logs and Alerts to record the PhysicalDisk object on all seven servers.C、Use Task Manager to view the performance data on each of the seven servers.D、Use System Monitor to generate a histogram view of the LogicalDisk object on all seven servers.
You have an Exchange Server 2010 organization that contains three Mailbox servers.All Mailbox servers are members of a database availability group （DAG） and have a public folder database.The Active Directory forest contains one site.You create a new site and install new Exchange Server 2010 servers in the site.You need to ensure that public folders are stored on servers in both sites.What should you do？（）A、Create a public folder database on a server in the new site. Modify the replication settings for all public foldersB、Create a public folder database on a server in the new site.Run the Set-DatabaseAvailabilityGroup cmdlet from a server in the new siteC、Configure clustered continuous replication （CCR） on two servers in the new site. Modify the replication settings for all public folder databasesD、Configure standby continuous replication （SCR） on a server in the new site. Run the Enable-StorageGroupCopy cmdlet from a server in the new site
You need to ensure that database schema changes in branch offices result in the proper notifications. What should you do?（）A、Install Notification Services on all branch office servers， and configure Notification Services to use a local notifications database.B、Specify that all SQL Server log files must be archived and sent by e-mail to the main office. C、Implement DML triggers that use Database Mail to send an e-mail message about the DML activity.D、Implement DDL triggers that use Database Mail to send an e-mail message about the DDL activity.
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 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.
多选题In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container: Which two statements are true?（）AThe C # # ROLE1 role is created in the root database and all the PDBs.BThe C # # ROLE1 role is created only in the root database because the container clause is not used.CPrivileges are granted to the C##A_ADMIN user only in the root database.DPrivileges are granted to the C##A_ADMIN user in the root database and all PDBs.EThe statement for granting a role to a user fails because the CONTAINER clause is not used.
多选题You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?（）AThe backup as copy can only be taken to diskBThe backup as copy can only be taken to tapeCBackup can be performed only when the instance is shutdownDBackup will constitute all used and unused blocks in the database
单选题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
单选题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?（）ACreate one OU that includes both the web servers and the database servers. BCreate one OU that includes the web servers and one OU that includes the database servers. CCreate one OU that includes the web servers. Then Place the database servers in the Computer Containers.DPlace 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 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 need to ensure that the network administrators are able to administer the NewApp database servers. Which two actions should you perform?（）ACreate an organizational unit (OU) for all users who log on to any of the NewApp servers.BCreate an organizational unit (OU) named NewApp Users for the NewApp users.CCreate an organizational unit (OU) named NewApp Servers for the NewApp servers.DCreate a Group Policy object (GPO) for the NewApp Users OU to enforce the use of IPSec.ECreate a global group for all NewApp servers. Add this group to the NewApp Servers OU.FCreate a Group Policy object (GPO) for the NewApp Servers OU to enforce the use of smart cards.
单选题A customer wants to hold all enterprise data on their DS4000 system. Several servers were added after they purchased another company. The servers that have to be run are： （1）An Oracle database running on a HP-UX server （2）Several virtual machines running on VMWare ESX server （3）A Microsoft cluster running Exchange 2000 server Which of these new servers can be integrated with the DS4000？（）ADS4000 storage does not support HP-UX， so the HP-UX server cannot be integrated.All other new servers can be used.BAn Exchange cluster needs local disks， so the DS4000 cannot be used for this.All other new servers can be used.CWhen equipped with proper HBA’s and subsystem device drivers， all new servers can operate with the DS4000 storage device.DVMWare ESX can use the DS4000 storage； however， the virtual machines running in it will not have access to this storage other than via a virtual disk.All other new servers can be used.
单选题You are the network administrator for All network servers run Windows Server 2003. A server named TK1 contains a mirrored volume that consists of two 36-GB disks. Both disks are used for data storage. TK1 also contains a third unallocated dynamic disk. Next week, a database that currently requires 45 GB of disk space will be installed on TK1. This database will grow at a rate of 10 percent every 6 months. You need to realocate disk space on TK1. Your realocation must satisfy the space requirements of the new database, and it must also ensure that data will remain available in case of disk failure. First, you break the mirror and delete all volumes on the disks. What should you do next?（）ACreate a spanned volume.BCreate a stripped volume.CCreate a mirrored volume.DCreate a RAID-5 volume.