Ch. 1 quiz (4430)

The extension to the SQL language that Oracle Database offers is called _____.

PL/SQL

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

Use comments to describe what each statement does.

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.

Which of the following types of statements isn't an action query?

Select

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

/DDL/,/Data Definition Language/

Which of the following isn't true about a stored procedure?

A stored procedure is compiled each time that it is executed.

Which of the following types of SQL statements isn't a DML statement?

Create Table

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

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

cell

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

data access API

A database driver is software that lets the

data access model communicate with the database

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

database

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

foreign key

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

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

primary key

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

type