問題詳情

12在SQL Server 2000中，要对数据库GoodsDB进行一次差异备份，将其备份到设备Backup 1上该设备已建立好，并要求该次备份操作清除Backupl中己有的备份内容。下列能实现该备份要求的语句是
(A)BACKUP DATABASE GoodsDB TO Backupl DIFFERENTIAL,WITH NOINIT
(B)BACKUP DATABASE GoodsDB TO Backupl WITH DIFFERENTIAL,NOINIT
(C)BACKUP DATABASE GoodsDB TO Backupl DIFFERENTIAL,WITHINIT
(D)BACKUP DATABA息E GoodsDB TO Backupl WITH DIFFERENTIAL,INIT

參考答案

答案：D
難度：適中0.5
統計：A(0),B(0),C(0),D(0),E(0)