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