Database Tables  «Prev  Next»

 

SQL Server Databases - Quiz

Each question is worth one point. Select the best answer for each question.

1. John is trying to modify a database, but he keeps getting an error. He double-checks the syntax of the ALTER DATABASE statement, but still cannot modify the database. What is the most likely cause of the problem?
Please select the best answer.
  A. ALTER DATABASE is not the correct statement.
  B. Transact-SQL cannot be used to modify a database; John should be using the Enterprise Manager instead.
  C. Because the syntax can be tricky, John needs to check it again to find the problem.
  D. John does not have the correct permissions to modify a database.

2. Mary has a database that is currently 5 MB, with a log file also of 5 MB. What will happen when Mary issues the following Transact-SQL statement? 
ALTER DATABASE employee
MODIFY FILE (NAME = "employee_Log", SIZE = 2MB)

Please select the best answer.
  A. An error will occur.
  B. The database will be altered to a size of 2 megabytes.
  C. The transaction log will be altered to a size of 2 megabytes.
  D. A new database named "employee" will be created.

3. What can you NOT do when you use the CREATE DATABASE Transact-SQL statement?
Please select the best answer.
  A. Create a database named "sales" with a database size of 50 megabytes and a transaction-log size of 50 megabytes.
  B. Create a database named "sales" and a database named "inventory."
  C. Specify a database growth increment of 12%.
  D. Alter the default database file locations.


Correct answers:

Your Score: 0