SQL Server Overview - Quiz Explanation

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

1.	Before you actually construct a database, what should you do? Please select the best answer.
	A.	Nothing. Begin constructing the database immediately.
	B.	Construct a physical model.
	C.	Construct a logical model.
	D.	Construct your tables.
	The correct answer is C. Before you actually construct a database, you should construct a logical model. The logical model helps you visualize how the tables that comprise the database will relate to each other. A is incorrect because it's best to construct the logical model before diving in to the database itself. B is incorrect because you cannot accurately construct a physical model before you know how the tables relate to each other by constructing a logical model. D is incorrect because not only do you need to plan your database first, you cannot construct tables without constructing a database to put them into.

2.	Which SQL Server tool would you use if you wanted to browse the objects in a Timesheet database? Please select the best answer.
	A.	A browser
	B.	The Enterprise Manager
	C.	The Query Analyzer
	D.	A Web Assistant
	The correct answer is B. The Enterprise Manager enables you to browse and drill down hierarchical database objects. A is incorrect because a browser does not enable you to browse SQL Server objects. C is incorrect because although you can query database objects with the Query Analyzer, you cannot browse objects. D is incorrect because the Web Assistant does not enable you to browse objects.

3.	Before you can issue a query to SQL Server 2012, which service do you start first? Please select the best answer.
	A.	MSDTC
	B.	MSSQLServer
	C.	SQLServerAgent
	C.	DCOM Distributed Service
	The correct answer is B. Before you can issue a query to SQL Server 2012, you must first start the MSSQLServer service. A is incorrect because although this is a valid SQL Server 2012 service, it is used to manage transactions across computers. C is incorrect because SQLServerAgent manages scheduling within SQL Server 2012. Answer D is not relevant to the question.

4.	Which SQL Server tool would you use if you wanted to issue an ad hoc query against a Timesheet database? Please select the best answer.
	A.	A browser
	B.	The Enterprise Manager
	C.	The Query Analyzer
	D.	A Web Assistant
	The correct answer is C. The Query Analyzer enables you to type an ad hoc SQL statement and issue it to SQL Server for the purpose of viewing the results. A, B, and D are all incorrect because none of these tools enables you to issue an ad hoc query.