... can be used for input, to use both DD entries describing sequential datasets and DD

... can be used to write multiple output datasets.

... can contain a dummy data set in the input, which will indicate the end of the input.

... stored on different device types, can not be used for input.

We can override parameters on EXEC statements and add DD statements.

We can override, nullify and add parameters on all statements and add DD and/or OUTPUT

We can add and override parameters to all statements, but can only nullify parameters

We can nullify, override and add parameters to all statements, but can only add DD statements.

less than (

greater than (>)

less than or equal to (<=)

Any of the above.

_

%

*

None of the above

Removes duplicate rows from your result.

Selects all the rows.

Puts the rows in descending order.

None of the above

True

False

Can represent remote tables and views.

Can us used by anyone.

Does not need DB2 authority to use.

All the above.

SYSADM authority.

CREATEALIAS authority.

Either a or b

Both a & b

Control access to table.

Make data easier to use.

Only b

Both a and b

INSERT

UPDATE

DELETE

All the above.

WHERE clause

HAVING clause

Either of the above

None of the above

Embedded within application program.

Prepared during the execution of SQL application.

Is the result of a DB2 query.

None of the above

A list of package names

The bound form of SQl statements taken from one or more DBRMs.

Neither of the above

Both of the above

View

Synonym

Result table

Alias

WHERE

AND

IS NULL

BETWEEN

SUM

AVG

Both

None

INFO-PROGRAM-ID

INFO-FUNCTION-KEY

INFO-CONVERSATION

INFO-PASSOFF

INFO-PROGRAM-ID

INFO-CONVERSATION

INFO-PREVIOUS-PROGRAM-ID

INFO-FUNCTION-KEY

INFO-PROGRAM-ID

INFO-USERID

INFO-CONVERSATION

INFO-PASSOFF

INFO-PROGRAM-ID

INFO-PREVIOUS-PROGRAM-ID

INFO-CONVERSATION

INFO-PASSOFF