Chapter 1 & 2 Quiz

Management Studio allows you to back up a database. Then, if you accidentally modify or delete data, you can easily ________________ it.

restore

When a column in a table is defined, what determines the kind of data it can store?

a data type

You can create a database diagram for

any combination of the tables in a database

Which of the following is not a SQL DML statement?

CreateTable

When using the Query Designer, where is the generated SQL statement displayed?

Criteria Pane

When using the Query Designer, you can sort the sequence for the query in the?

Criteria pane

To relate one table to another, a/an ________________ in one table is used to point to the primary key in another table.

Foreign key

Which of the following isn't a common error when entering and executing SQL statements?

Forgetting to attach the required database

Within the Management Studio, you can build a SQL statement without having to write your own code by using the ________________.

Query Designer

In Management Studio, if a statement returns data, that data is displayed in the __________ tab.

Results tab

A relational database consists of one or more what?

tables

If you define a column with a default value, that value is used whenever a row

that doesn't include a value for that column is added to the table

To run a SELECT statement from an application program, you store the statement in the ________________ object for the database connection.

command

What uniquely identifies each row in a table?

primary key

In Management Studio, if you want to modify a column, or view more detailed information about the columns in a table, what tool would you use?

Table Designer

Insert, Update, and Delete statements can be referred to as ________________ queries.

Action

If you have the files for an existing SQL Server database, the easiest way to create the database is to ________________ those files to the database server.

Copy

A database ________________ is a schematic drawing that shows you the relationships between the tables you're working with.

Diagram

If you want to use the Management Studio to modify the data for a table, you can right-click on the table and select what?

Edit Top 200 Rows command

What can you use to combine data from two or more tables into a single result set?

Join

A SQL Server database consists of two files: a database file and a ___________.

log file

What is the most common type of relationship between two tables?

one-to-many

One limitation of the Query Designer is that you can't use it for

Certain types of complex queries

A graphical tool that you can use to start and stop the database server is called what?

SQL Server Configuration Manager

The Query Editor of the Management Studio lets you enter and execute all types of

SQL statements