多选题TestKing.com uses a SQL Server 2005 database. This database contains a trigger named trg InsertOrders， which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table

题目

多选题

TestKing.com uses a SQL Server 2005 database. This database contains a trigger named trg InsertOrders， which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal？（）

ALTER TABLE OrdersDISABLE TRIGGER trg InsertOrders

DROP TRIGGER trg InsertOrders

DISABLE TRIGGER trg InsertOrders ON Orders

ALTER TRIGGER trg InsertOrders ON Orders NOT FOR REPLICATION

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which contains a database. According to the company requirement， you have to move the application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance to record the use of features. These features will be discontinued. What should you do？（）

A、The SQL Server 2008 Upgrade Advisor should be used.
B、The SQL Server Profiler which captures the SQL:BatchCompleted and Exception event classes should be used.
C、A SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes should be used
D、A SQL server-side trace that captures the SQL:BatchCompleted and Exception event classes should be used.

正确答案:C

第2题：

An on-premise .NET application uses an on-premise Microsoft SQL Server 2008 database. The existing compute infrastructure is insufficient to support peak loads. You plan to move only the compute-intensive component of the application into Windows Azure. The component requires access to the on-premise database. The on-premise database cannot be accessed from outside the network boundary. You need to recommend a database topology. What should you recommend？（）

A、 Use SQL Azure for the on-premise components and the compute-intensive component.
B、 Configure merge replication with the on-premise database as publisher and the SQL Azure database as subscriber.
C、 Configure snapshot replication with the on-premise database as publisher and the SQL Azure database assubscriber.
D、 Configure snapshot replication with the SQL Azuredatabase as publisher and the on-premise database as subscriber.

正确答案:A

第3题：

You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe. database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database.

The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company's mainframe. database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.

You need to configure a SQL Server computer for the new branch office in Sydney. You want to copy the Los Angeles package and modify it so that it writes data to the SQL Server database in Sydney.

You use the DTS Designer to modify the DTS package so that it imports regional data from the mainframe. database to the server in Sydney. The modified DTS package runs successfully on the server in Los Angeles. You save this DTS package to the server in Sydney, but the server in Sydney cannot connect to the mainframe. database.

You want to enable the server in Sydney to connect to the mainframe. database. What should you do?

A．Change the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database.

B．Modify the workflow in the DTS package so that the server in Sydney is included.

C．On the server in Sydney, install an OLE DB provider for the mainframe. database.

D．On the server in Sydney, delete and then re-create the DTS package.

正确答案：C
解析：Explanation: OLE DB is an API that allows COM applications to use data from OLE DB data sources, which includes data stored in different formats. An application uses an OLE DB provider to access an OLE DB data source. An OLE DB provider is a COM component that accepts calls to the OLE DB API and performs the necessary processing required by request against the data source. In this scenario the OLE DB source is the company's mainframe. database, which contains all company data. As each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database, all existing and future branch office SQL Server 2000 servers will require an OLE DB provider to access the company's mainframe. database.

Incorrect Answers:
A: The DTS package requires an OLE DB provider to access an OLE DB data source. It needs this provider to connect to the company's mainframe. database. Resetting the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database will not provide the DTS package with the required access to the mainframe. database.

B: A separate DTS package must be created for the Sydney branch office. This DTS package must extract data from the company's mainframe. computer that is relevant to the branch office in Sydney. The existing DTS package used to extract data from the company's mainframe. for the Los Angeles SQL Server 2000 server can be modified to serve the same function for the Sydney office.

D: Re-creating the DTS package on the SQL Server 2000 server in the branch office in Sydney is unnecessary the that SQL Server 2000 server would still require an OLE DB provider to access the company’s mainframe. database. It would require less administrative effort to modify the existing DTS package.

第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 a database named Dworks in the instance. You are log shipping the Adventureworks database to a remote SQL Server 2008 instance. The primary SQL Server instance required a restart during the weekend. But you notice that log shipping has stopped working after the weekend. You have to check log shipping of the Adventureworks database and find out the problem. What should you do? （）

A、You should use the EXTENDED_LOGICAL_CHECKS option to execute a DBCC CHECKDB statement on the AdventureWorks database by.
B、You should identify whether the SQL Server Agent is started on the primary server.
C、You should identify whether the AdventureWorks database uses the Simple recovery model.
D、You should identify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server

正确答案:B

第5题：

You work in a company which 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 DB01 in the instance. The company CIO wants all the application developers can capture traces to troubleshoot the application that uses the database DB1， and they can perform this by using SQL Server Profiler. But they have to be given as little permission as possible. The company CIO assigns this task to you. So what action should you perform to achieve this goal？（）

A、All the SQL Server logins of the application developers have to be added to a fixed server role.
B、All the database users of the application developers have to be added to a fixed database role
C、All SQL Server logins of the application developers should be given the appropriate server-level permissions.
D、All database users of the application developers should be given the appropriate database-level permissions.

正确答案:C

第6题：

You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）

A、Configure a Linked Server connection to the application database.
B、Write a query that uses an OPENDATASOURCE command.
C、Write a query that uses an OPENQUERY command.
D、Configure a Remote Server connection to the application database.

正确答案:B

第7题：

You are planning the deployment of a SQL Azure database. Your company has a Volume Licensing Agreement for Microsoft SQL Server 2008. The SQL Azure database must maintain a monthly availability of 99.9%. You need to recommend an approach for minimizing the monthly expenses associated with the SQL Azure database. What should you recommend？（）

A、 Add a processor license to the existing SQL Server licensing agreement.
B、 Purchase a Windows Azure consumption platform subscription.
C、 Purchase a SQL Server Services Provider Licensing Agreement （SPLA）.
D、 Purchase a SQL Server Web license to extend the existing SQL Server licensing agreement.

正确答案:B

第8题：

You are the administrator of several SQL Server 2000 computers. You want to retrieve information from an archived inventory database. You have a full tape backup of the database. The backup’s header information shows that the backup uses the SQL_Latin1_General_CR437_BIN collation.

However, the existing SQL server computers in your office are configured to use the

SQL_Latin1_General_CP1_CI_AS collation.

You do not want to join tables in the inventory database with tables in other databases. You need to restore the inventory database to a SQL Server 2000 computer by using the least amount of administrative effort.

What should you do?

A．Use the rebuildm utility to rebuild the system database on an existing SQL server computer. Configure all the databases on that server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the server.

B．Restore the inventory database to an existing SQL server computer. Accept the SQL_Latin1_General_CR437_BIN collation for that database.

C．Install a new named instance of SQL Server 2000 on an existing SQL Server 2000 computer. Configure the named instance to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the named instance.

D．Install SQL Server 2000 on a new computer. Configure the new server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the new server.

正确答案：B
解析：Explanation:CollationscontrolthephysicalstorageofcharacterstringsinSQLServer2000byspecifyingthebitpatternsthatrepresenteachcharacterandtherulesbywhichcharactersaresortedandcompared.WhereasearlierversionsofSQLServersupportedonlyonecollationforeachinstanceofSQLServer,SQLServer2000allowsobjectsthathavedifferentcollationstobestoredinasingledatabase.WecanthusrestorethedatabasetoanexistingSQLServer2000computerwithouthavingtochangethecollationofthatdatabase.IncorrectAnswers:A:TherebuildmutilityrebuildsthemasterdatabaseandcanbeusedtochangethecollationsettingsofaninstanceofSQLServer2000,ortofixacorruptedmasterdatabase.Rebuildingthemasterdatabaseinvolvesremovesalldatabaseobjectsanddata,re-createthedatabaseobjectsandreloadthedata,orreattachthedataandlogfilesusingsp_attach_dbwhentherebuildiscomplete.C:CollationscontrolthephysicalstorageofcharacterstringsinSQLServer2000byspecifyingthebitpatternsthatrepresenteachcharacterandtherulesbywhichcharactersaresortedandcompared.WhereasearlierversionsofSQLServersupportedonlyonecollationforeachinstanceofSQLServer,SQLServer2000allowsobjectsthathavedifferentcollationstobestoredinasingledatabase.ItisthusnotnecessarytoinstallanewinstanceofSQLServer2000inordertorestorethedata.WecaninsteadrestorethedatabasetoanexistingSQLServer2000computerwithouthavingtochangethecollationofthatdatabase.D:CollationscontrolthephysicalstorageofcharacterstringsinSQLServer2000byspecifyingthebitpatternsthatrepresenteachcharacterandtherulesbywhichcharactersaresortedandcompared.WhereasearlierversionsofSQLServersupportedonlyonecollationforeachinstanceofSQLServer,SQLServer2000allowsobjectsthathavedifferentcollationstobestoredinasingledatabase.ItisthusnotnecessarytoinstallanewinstanceofSQLServer2000onanewcomputerinordertorestorethedata.WecaninsteadrestorethedatabasetoanexistingSQLServer2000computerwithouthavingtochangethecollationofthatdatabase.

第9题：

You work in a company which 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 named Dworks in the instance. The Dworks database has a table named Bills which contains several indexes and a great amount of rows. An enterprise Web environment is supported by the database. Onthe Bills table 28% of the indexes have been fragmented. You have to defragment the indexes， making sure that you reduce the effect on database availability to the least. In the ALTER INDEX statement， which option should be included？（）

A、Sort in tempdb
B、Online
C、Fill factor
D、Pad index

正确答案:B

第10题：

You are designing a strategy for synchronizing a SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships. You need to recommend an approach for ensuring that all changes in the remote databases synchronize with the SQL Azure database. What should you recommend？（）

A、 Use SQLAzure Data Sync Service.
B、 Use SQL Server replication.
C、 Use SQL Server backup and restore.
D、 Use SQL Server database snapshots.

正确答案:A

TestKing.com uses a SQL Server 2005 database. This database

题目

相似问题和答案

更多相关问题

相关内容