单项选择题

YourcompanyhastwoSQLServer2005computersnamedSQL1andSQL2……

Your company has two SQL Server 2005 computers named SQL1 and SQL2. Transaction log shipping occurs from SQL1 to SQL2 by using default SQL Server Agent schedule settings. You need toreconfigure transaction log shipping to provide minimum latency on SQL2. What should you do?（）

A. On SQL1, reschedule the transaction log backup job so that it occurs every minute. On SQL2, maintain default schedule settings for both the log shipping copy and the restore jobs.
B. On SQL1, change the schedule type for the transaction log backup to Start automatically when SQL Server Agent starts. On SQL2, change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL Server Agent starts.
C. On SQL1, maintain default schedule settings for the transaction log backup job. On SQL2, change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL Server Agent starts.
D. On SQL1, reschedule the transaction log backup job so that it occurs every minute. On SQL2, reschedule both the log shipping copy and the restore jobs so that they occur every minute.

<上一题目录没有了>

热门试题

单项选择题AfullbackupofyourdatabasenamedDB1iscreatedautomaticallyatmidnighteveryday.DifferentialbackupsofDB1occurtwiceeachdayat10:00andat16:00.Adatabasesnapshotiscreatedeverydayatnoon.AdeveloperreportsthatheaccidentallydroppedthePricelisttableinDB1at12:30.ThelastupdatetoPricelistoccurredoneweekago.YouneedtorecoverthePricelisttable.Youwanttoachievethisgoalbyusingtheminimumamountofadministrativeeffort.Youmustalsominimizetheamountofdatathatislost.Whatshouldyoudo?（）

A. Restore the most recent backup into a new database named DB1bak. Apply the most recent differential backup. Copy the Pricelist table from DB1bak to DB1.
B. Delete all database snapshots except the most recent one. Restore DB1 from the most recent database snapshot.
C. Recover DB1 from the most recent backup. Apply the most recent differential backup.
D. Copy the Pricelist table from the most recent database snapshot into DB1.

多项选择题Yourcompanyusesamission-criticaldatabasenamedDB1,whichislocatedonaservernamedSQL1.YouwanttomirrorDB1onasecondservernamedSQL2.Beforeyoucanestablishdatabasemirroring,youneedtoprepareDB1andtheserversformirroring.Whichthreeactionsshouldyouperform?（）

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.