Tag: mainframe

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