ch 1 sql

A/An _________________ statement is used to retrieve selected columns and rows from a base table.

select

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

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

Use comments to describe what each statement does

A/An ____________________________ diagram can be used to show how the tables in a database are defined and related..

entity relationship

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

back end processing

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

data access api

A database driver is software that lets the

data access model communicate with the database

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

data definition language

The type of operation that retrieves data from two or more tables is called a

join

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

type