问答题

Youneedtoensurethatthecompany’sstandardpasswordpolicyisenforcedforallloginsthatareusedtoaccessSQLServer2005.Whichtwoactionsshouldyouperform？（）

A.SettheappropriatelocalpasswordpoliciesforallcomputersonwhichSQLServerisinstalled.
B.SettheserverauthenticationmodeofallSQLServerinstancestoWindowsAuthenticationmode.
C.InstallallinstancesofSQLServer2005oncomputersthatrunWindowsServer2003orlater.
D.CreateSQLServerloginsthathaveCHECK_POLICYenabled.

你可能感兴趣的试题

单项选择题

YouaremaintaininganOLTPdatabaseinOracle10g.YousetthevalueoftheLOG_ARCHIVE_TRACEparametertozero.Whatistheimpactofthissetting？（）

A.Thetracefileswillbedisabledonlyforaspecificsession.
B.Tracingwillbedisabledforaclientidentifier.
C.TracingwillbedisabledonlyfortheARCnprocess.
D.TheSQLTracefacilitywillbedisabledfortheinstance.

问答题

Yourcompanyusesamission-criticaldatabasenamedDB1,whichislocatedonaservernamedSQL1.YouwanttomirrorDB1onasecondservernamedSQL2.Beforeyoucanestablishdatabasemirroring,youneedtoprepareDB1andtheserversformirroring.Whichthreeactionsshouldyouperform?（）
A.SettherecoverymodelofDB1onSQL1tobulk-loggedrecovery.
B.SettherecoverymodelofDB1onSQL1tofullrecovery.
C.BackupDB1onSQL1.RestorethebackuponSQL2;specifytheNORECOVERYoption.
D.BackupDB1onSQL1.RestorethebackuponSQL2;specifytheSTANDBYoption.
E.BackupDB1onSQL1.RestorethebackuponSQL2;specifytheRECOVERYoption.
F.Createendpointsonallparticipatingservers.
G.SettheAutoShrinkpropertyofDB1onSQL1tofalse.

A.YouwanttomirrorDB1onasecondservernamedSQL2.Beforeyoucanestablishdatabasemirroring,youneedtoprepareDB1andtheserversformirroring.Whichthreeactionsshouldyouperform?（）
A.SettherecoverymodelofDB1onSQL1tobulk-loggedrecovery.
B.SettherecoverymodelofDB1onSQL1tofullrecovery.
C.BackupDB1onSQL1.RestorethebackuponSQL2;specifytheNORECOVERYoption.
D.BackupDB1onSQL1.RestorethebackuponSQL2;specifytheSTANDBYoption.
E.BackupDB1onSQL1.RestorethebackuponSQL2;specifytheRECOVERYoption.
F.Createendpointsonallparticipatingservers.
G.SettheAutoShrinkpropertyofDB1onSQL1tofalse.