SQL Chapter 1 and 2

tables

A relational database consists of one or more what?

restore

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

Results tab

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

foreign key

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

commands, connections, and data readers

To work with the data in a SQL Server database from a .NET application, you can use ADO.NET objects like

primary key

What uniquely identifies each row in a table?

SQL Server

When you set the compatibility level of SQL Server 2016, you make sure it is compatible with a specific version of

Select

Which of the following types of statements isn't an action query?

Query Designer

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

any combination of the tables in a database

You can create a database diagram for