Chapter 2 - How to use Management Studio

Question 1

What is SQL Server Management Studio and what is it used for?

Answer 1

The primary graphical tool that a developer uses to work with a SQL Server 2012 database. You can use this tool to work directly with database objects and to develop and test SQL statements.

Question 2

What is SQL Server Configuation Manager and what is it used for?

Answer 2

A graphical tool that you can use to start and stop the database server.

Question 3

Where can you access documentation for SQL Server 2012?

Answer 3

Books Online which you can access from SQL Server Management Studio. To display books online, select Help-> View Help from Management Studio. See pg 79 in textbook for add’l info.

Question 4

What is a schema? What is the default schema in SQL Server 2012?

Answer 4

A container that holds objects.

If you don’t specify a schema when you create an object, it’s stored in the default schema, dbo.