Chapter1ReviewQuestions

A/An ______ uniquely identifies each row in a table

primary key

A relational database consist of one or more ______

tables

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

cell

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

Use comments to describe what each statement does

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

back-end processing

Although the American National Standards Institute (ANSI) published 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

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

sql query

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

type

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

DDL

The SQL dialect that Microsoft SQL Server uses is called ___

T-SQL

If you define a column as an identify column,

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

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

data access API

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

network

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

one-to-many