The first time you use a database you should assess its _____________.

You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（） A. Mount the database B. Open the database in NORMAL mode C. Open the database in RESTRICTED mode D. Open the database with the RESETLOGS option

You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（） A: DBCC DBREINDEX B: SELECT * FROM sys.dm_db_index_physical_stats C: DBCC INDEXDEFRAG D: SELECT * FROM sys.indexe

You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（） A: DBCC DBREINDEX B: SELECT * FROM sys.dm_db_index_physical_stats C: DBCC INDEXDEFRAG D: SELECT * FROM sys.indexes

You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.（）

The core of the database system is ____. A: database B: database<br/>application system C: database<br/>management system D: database<br/>administrator

A tabular database ,a distributed database and an object-oriented database are different databases.

The core of the database system is（）. A: Data model B: Database administrator C: Database D: Database management system

删除数据库使用（ ）语句。 A: alter database B: drop database C: delete database D: erase database

删除数据库的命令为（） A: Create database B: use database C: alter database D: drop database