SQL Server Databases - Quiz Explanation

The answers you selected are indicated below, along with text that explains the correct answers.

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.
	The correct answer is D. Most likely, John does not have the correct permissions to modify the database. A is incorrect because `ALTER DATABASE` is the correct Transact-SQL statement to modify a database. B is incorrect because Transact-SQL can be used to modify a database. C is incorrect because, as John has already double-checked the syntax, chances are that's not the problem.

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.
	The correct answer is A. The syntax that Mary issued will result in an error because you cannot make a database smaller. B is incorrect for the same reason. C is incorrect not only because you cannot make a database smaller, but because Mary's statement does not address a transaction log, but the database file itself. D is incorrect because you must use the `CREATE DATABASE` statement to add a new database.

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.
	The correct answer is B. You cannot create two databases with the `CREATE DATABASE` Transact-SQL statement. A is incorrect because you can use the `CREATE DATABASE` Transact-SQL statement to create a database named "sales" with a database size of 50 megabytes and a transaction-log size of 50 megabytes. C is incorrect because you can use `CREATE DATABASE` to specify a database growth increment of 12%. And D is incorrect because you can use `CREATE DATABASE` to alter the default database file locations.