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