SQL Server中进行数据库备份的SQL语句是（）。A、INSERT DATABASEB、BACKUP DATABASEC、RESTORE DATABASED、UPDATE DATABASE
SQL Server中进行数据库备份的SQL语句是（）。
- A、INSERT DATABASE
- B、BACKUP DATABASE
- C、RESTORE DATABASE
- D、UPDATE DATABASE
相关考题：
在SQL Server 2000中，要对数据库GoodsDB进行一次差异备份，将其备份到设备Backup 1上(该设备已建立好)，并要求该次备份操作清除Backupl中己有的备份内容。下列能实现该备份要求的语句是A．BACKUP DATABASE GoodsDB TO Backupl DIFFERENTIAL,WITH NOINITB．BACKUP DATABASE GoodsDB TO Backupl WITH DIFFERENTIAL,NOINITC．BACKUP DATABASE GoodsDB TO Backupl DIFFERENTIAL,WITHINITD．BACKUP DATABA息E GoodsDB TO Backupl WITH DIFFERENTIAL,INIT
SQL Server2005触发器主要针对下列语句创建()。A.SELECT、INSERT、DELETEB.INSERT、UPDATE、DELETEC.SELECT、UPDATE、INSERTD.INSERT、UPDATE、CREATE
You are the administrator of several SQL Server 2000 computers. You want to retrieve information from an archived inventory database. You have a full tape backup of the database. The backup’s header information shows that the backup uses the SQL_Latin1_General_CR437_BIN collation.However, the existing SQL server computers in your office are configured to use theSQL_Latin1_General_CP1_CI_AS collation.You do not want to join tables in the inventory database with tables in other databases. You need to restore the inventory database to a SQL Server 2000 computer by using the least amount of administrative effort.What should you do?A．Use the rebuildm utility to rebuild the system database on an existing SQL server computer. Configure all the databases on that server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the server.B．Restore the inventory database to an existing SQL server computer. Accept the SQL_Latin1_General_CR437_BIN collation for that database.C．Install a new named instance of SQL Server 2000 on an existing SQL Server 2000 computer. Configure the named instance to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the named instance.D．Install SQL Server 2000 on a new computer. Configure the new server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the new server.
SQL Server中进行数据库恢复的SQL语句是（）。A、INSERT DATABASEB、BACKUP DATABASEC、RESTORE DATABASED、UPDATE DATABASE
SQL Server触发器主要针对下列语句创建（）。A、SELECT、INSERT、DELETEB、INSERT、UPDATE、DELETEC、SELECT、UPDATE、INSERTD、INSERT、UPDATE、CREATE
关于HQL与SQL，以下说法正确的是（）A、HQL与SQL没什么差别B、HQL面向对象，而SQL操纵关系数据库C、在HQL与SQL中，都包含select，insert，update，delete语句D、HQL仅用于查询数据，不支持insert，update和delete语句
SQL Server2005触发器主要针对下列语句创建（）。A、SELECT、INSERT、DELETEB、INSERT、UPDATE、DELETEC、SELECT、UPDATE、INSERTD、INSERT、UPDATE、CREATE
你发现在装有SQL SERVER 2005计算机上的msdb数据库被损坏并且必须被恢复才能正常使用。数据库每天都进行了备份，备份文件位于一个网络共享位置上，但是每个备份文件的文件名称都不能明确的指出是那个数据库的备份文件。你需要最快的找到正确的备份文件。已知备份文件列表的第一个文件的名称为DB_Backup.bak；你应该使用下面哪一个SQL语句？（）A、RESTORE LABELONLYFROM DISK = N//Server1/Backup/DB_Backup.bakB、RESTORE HEADERONLYFROM DISK = N//Server1/Backup/DB_Backup.bakC、RESTORE VERIFYONLYFROM DISK = N//Server1/Backup/DB_Backup.bakD、RESTORE DATABASE MSDBFROM DISK = N//Server1/Backup/DB_Backup.bak
You discover that the ms db database on a SQL Server 2005 computer is corrupt and must be restored. Databases are backed up daily. The database backup files are written to a network share， but the file names do not clearly indicate which databases are in each file. You need to locate the correct backup file as quickly as possible. The first file in the list isnamed DB Backup.bak. Which Transact-SQL statement should you use？（）A、RESTORE LABELONLYFROM DISK = N//Server1/Backup/DB Backup.bakB、RESTORE HEADERONLYFROM DISK = N//Server1/Backup/DB Backup.bakC、RESTORE VERIFYONLYFROM DISK = N//Server1/Backup/DB Backup.bakD、RESTORE DATABASE MSDBFROM DISK =N//Server1/Backup/DB Backup.bak
You are designing a strategy for synchronizing a SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships. You need to recommend an approach for ensuring that all changes in the remote databases synchronize with the SQL Azure database. What should you recommend？（）A、 Use SQLAzure Data Sync Service.B、 Use SQL Server replication.C、 Use SQL Server backup and restore.D、 Use SQL Server database snapshots.
单选题You are designing a strategy for synchronizing a SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships. You need to recommend an approach for ensuring that all changes in the remote databases synchronize with the SQL Azure database. What should you recommend？（）A Use SQLAzure Data Sync Service.B Use SQL Server replication.C Use SQL Server backup and restore.D Use SQL Server database snapshots.
单选题SQL Server中进行数据库备份的SQL语句是（）。AINSERT DATABASEBBACKUP DATABASECRESTORE DATABASEDUPDATE DATABASE
单选题SQL Server中进行数据库恢复的SQL语句是（）。AINSERT DATABASEBBACKUP DATABASECRESTORE DATABASEDUPDATE DATABASE
单选题SQL Server触发器主要针对下列语句创建（）。ASELECT、INSERT、DELETEBINSERT、UPDATE、DELETECSELECT、UPDATE、INSERTDINSERT、UPDATE、CREATE