Chapter 2 - How to use Management Studio Flashcards

1
Q

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

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Where can you access documentation for SQL Server 2012?

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly