单项选择题

YouworkinacompanywhichusesSQLServer2008.YouaretheadministratorofthecompanydatabasE.NowyouareinchargeofaSQLServer2008EnterpriseEditioninstancE.ThereisadatabasenamedDB1intheinstancE.AbackupofDB1isperformedeveryday.YouhavetominimizethesizeofthefulldatabasebackupfilesofDB1.Intheoptionsbelow,whichTransact-SQLstatementshouldyouuse?()
A.BACKUPDATABASEDB1TODISK='t:/backups/db1.bak';
B.BACKUPDATABASEDB1TODISK='t:/backups/db1.bak'WITHCOMPRESSION;
C.BACKUPDATABASEDB1TODISK='t:/backups/db1.bak'WITHDIFFERENTIAL;
D.BACKUPDATABASEDB1TODISK='t:/backups/db1.bak'WITHCOMPRESSION,DIFFERENTIAL;

A.YouaretheadministratorofthecompanydatabasE.NowyouareinchargeofaSQLServer2008EnterpriseEditioninstancE.ThereisadatabasenamedDB1intheinstancE.AbackupofDB1isperformedeveryday.YouhavetominimizethesizeofthefulldatabasebackupfilesofDB1.Intheoptionsbelow,whichTransact-SQLstatementshouldyouuse?()
A.BACKUPDATABASEDB1TODISK='t:/backups/db1.bak';
B.BACKUPDATABASEDB1TODISK='t:/backups/db1.bak'WITHCOMPRESSION;
C.BACKUPDATABASEDB1TODISK='t:/backups/db1.bak'WITHDIFFERENTIAL;
D.BACKUPDATABASEDB1TODISK='t:/backups/db1.bak'WITHCOMPRESSION,DIFFERENTIAL;
热门 试题

单项选择题
A.2B.3C.4D.6
A.2
B.3
C.4
D.6
单项选择题
A.B.C.D.
A.
B.
C.
D.
单项选择题
A.B.C.D.
A.
B.
C.
D.
相关试题