找考题网-背景图
单项选择题

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.B.C.D.

A.
B.
C.
D.

单项选择题A.B.C.D.

A.
B.
C.
D.