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