SQL Chapter 1 and 2

Ace your homework & exams now with Quizwiz!

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


Related study sets

Interpersonal Communications - Chapter 10: Intimate Relationships

View Set

ch 4 labs 4-1 through 4-6 server 2019

View Set

Chapter 31. Paint Application: ASE Type Questions

View Set

RESPIRATION - Check for understanding

View Set

Chapter 9 - Analyzing Causes and Effects

View Set

George Washington- First President

View Set