Q

D

N

I

Horizontal and Vertical

Forward and Backward

Left and Right

Front and Back

Field

Segment

Branch

Character

255

1000

453

No Limitation

Sequential Initial Load

Access only Key of segment

Used with G to Indicate that Hold is not allowed

None of the above

Basic and Complex

General and Specific

Qualified and Unqualified

None of these

Top to Bottom, Front to back, Left to right

Front to back, Left to right, Top to Bottom

Left to right, Top to Bottom, Front to back

Left to right, Front to back, Top to Bottom

IX

IQ

II

ID

AJ

AI

AC

Ak

Databases accessed must be online.

No data communication services are used.

Transactions are entered at the terminal and stored in a message queue.

True batch processing.

255

1000

No Limit

32

GU

GN

GNP

GHNP

True

False

COBOL

JAVA

REXX

VS PASCAL

Equi-join

Natural join

Outer join

Cartesian join

Hard-coded SQL statements in a program language such as Java

The process of making an application capable of generating specific SQL code on the fly.

Hard-coded SQL statements in a procedure.

Hard-coded SQL statements in a trigger.

Combines the output from no more than two queries and must include the same number of columns.

Combines the output from no more than two queries and does not include the same number of columns.

Combines the output from multiple queries and must include the same number of columns.

Combines the output from multiple queries and does not include the same number of columns.

Equi-join

Natural join

Outer join

All of the above.

Both consist of procedural code

Both have to be called to operate.

Both run automatically.

Both are stored in the database.

Uses the result of an inner query to determine the processing of an outer query.

Uses the result of an outer query to determine the processing of an inner query.

Uses the result of an inner query to determine the processing of an inner query.

Uses the result of an outer query to determine the processing of an outer query.