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