Tag: databases

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.