Ch.1 - An introduction to relational databases and SQL

Which of the following recommendations won't improve the readability of your SQL statements?

Use comments to describe what each statement does.

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

action

The processing that's done by the DBMS is typically referred to as

back-end processing

Although the American National Standards Institute publishes the specifications for a standard SQL language, each DBMS vendor has its own _______________ of SQL.

dialect

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

foreign key

A/An __________________ uniquely identifies each row in a table.

primary key

To retrieve or update the data in a database, the client sends a/an ________________ to the database.

query

A relational database consists of one or more ___________.

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.

When a column in a table is defined, it is given a data _________ that determines what kind of data it can store.

type

A view is a SELECT statement that is stored with the ______________.

database

The SQL dialect that Microsoft SQL Server uses is called _______________.

Transact-SQL

The most common type of relationship between two tables is a/an ___________________ relationship.

one-to-many

f you define a column as an identity column,

a number is generated for that column whenever a row is added to the table

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

commands, connections, and data readers

The intersection of a row and a column is commonly called a/an _______________.

cell

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

command

The interface between an application program and the DBMS is usually provided by the

data access API

SQL statements that define the tables in a database are referred to as _______________ statements.

data definition language

The three main hardware components of a client/server system are the clients, the server, and the ______________.

network