多项选择题
Your company uses a mission-critical database named DB1, which is located on a server named SQL1. You want to mirror DB1 on a second server named SQL2. Before you can establish database mirroring, you need to prepare DB1 and the servers for mirroring. Which three actions should you perform?（）
A. Set the recovery model of DB1 on SQL1 to bulk-logged recovery.
B. Set the recovery model of DB1 on SQL1 to full recovery.
C. Back up DB1 on SQL1. Restore the backup on SQL2; specify the NORECOVERY option.
D. Back up DB1 on SQL1. Restore the backup on SQL2; specify the STANDBY option.
E. Back up DB1 on SQL1. Restore the backup on SQL2; specify the RECOVERY option.
F. Create endpoints on all participating servers.
G. Set the AutoShrink property of DB1 on SQL1 to false.
相关考题
-
单项选择题
YourcompanyusesaSQLServer2005database.CustomerdatafromyourtradingpartnersisimportedintotheCustomerstableeverynight.YouneedtoensurethatthecustomerrecordisupdatedifitalreadyexistsintheCustomerstable.Iftherecorddoesnotexist,thedataneedstobeinsertedintotheCustomerstable.Whatshouldyoudo?（）
A. Create a FOR trigger.
B. Create an INSTEAD OF trigger.
C. Create an AFTER trigger.
D. Create a DDL trigger. -
单项选择题
YouarecreatingaviewtojointheCustomersandOrderstablesinaSQLServer2005database.Youneedtoensurethattheviewcannotbeaffectedbymodificationstounderlyingtableschemas.Youwanttoaccomplishthisgoalbyusingtheleastpossibleamountofoverhead.Whatshouldyoudo?（）
A.Create CHECK constraints on the tables.
B.Create a DDL trigger to roll back any changes to the tables if the changes affect the columns in the view.
C.Create the view, specifying the WITH SCHEMABINDING option.
D.Create the view, specifying the WITH CHECK option. -
多项选择题
Your company uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce your companys security policy of abstracting data. Some of these views perform slowly. You create indexes on those views to increase performance, while still maintaining the companys security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE() function. This view does not allow you to create an index. You need to create an index on the view. Which two actions should you perform?（）
A. Remove all deterministic function calls from within the view.
B. Remove all nondeterministic function calls from within the view.
C. Schema-bind all functions that are called from within the view.
D. Create the view and specify the WITH CHECK OPTION clause.
