网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
SQL Server中进行数据库恢复的SQL语句是（）。
A
INSERT DATABASE
B
BACKUP DATABASE
C
RESTORE DATABASE
D
UPDATE DATABASE
参考答案
参考解析
解析：
暂无解析
更多 “单选题SQL Server中进行数据库恢复的SQL语句是（）。A INSERT DATABASEB BACKUP DATABASEC RESTORE DATABASED UPDATE DATABASE” 相关考题
考题
使用SQL语言修改数据库，正确的命令是()A. CREATE DATABASEB. MODIFY DATABASEC. ALTER DATABASED. CHANGE 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语句是（）。AINSERT DATABASEBBACKUP DATABASECRESTORE DATABASEDUPDATE DATABASE
考题
SQL Server中进行数据库备份的SQL语句是（）。AINSERT DATABASEBBACKUP DATABASECRESTORE DATABASEDUPDATE DATABASE
考题
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
考题
在Visual FoxPro中，打开数据库设计器的命令是（）.A、CLEAR DATABASEB、USE DATABASEC、OPEN DATABASED、MODIFY DATABASE
考题
你发现在装有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触发器主要针对下列语句创建（）。A
SELECT、INSERT、DELETEB
INSERT、UPDATE、DELETEC
SELECT、UPDATE、INSERTD
INSERT、UPDATE、CREATE
考题
单选题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语句
热门标签
最新试卷
