单选题SQL Server中进行数据库恢复的SQL语句是()。AINSERT DATABASEBBACKUP DATABASECRESTORE DATABASEDUPDATE DATABASE
单选题
SQL Server中进行数据库恢复的SQL语句是()。
A
INSERT DATABASE
B
BACKUP DATABASE
C
RESTORE DATABASE
D
UPDATE DATABASE
参考解析
解析:
暂无解析
相关考题:
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中进行数据库备份的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 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 Server2005触发器主要针对下列语句创建()。ASELECT、INSERT、DELETEBINSERT、UPDATE、DELETECSELECT、UPDATE、INSERTDINSERT、UPDATE、CREATE
单选题SQL Server中进行数据库备份的SQL语句是()。AINSERT DATABASEBBACKUP DATABASECRESTORE DATABASEDUPDATE DATABASE
单选题SQL Server触发器主要针对下列语句创建()。ASELECT、INSERT、DELETEBINSERT、UPDATE、DELETECSELECT、UPDATE、INSERTDINSERT、UPDATE、CREATE
单选题关于HQL与SQL,以下说法正确的是()AHQL与SQL没什么差别BHQL面向对象,而SQL操纵关系数据库C在HQL与SQL中,都包含select,insert,update,delete语句DHQL仅用于查询数据,不支持insert,update和delete语句