True

False

Group containing alphabetic fields

Group containing numeric fields

Group containing alphabetic and numeric fields

None of the above

True

False

256

253

255

None of the above

REDEFINES

REPLACING

REUSE

REORG

DD NAME

SYSIN Parameter

PARAM

RETURN CODE

SET

SEARCH

PERFORM

All the above

Unique index and base clusters

Primary index and base clusters

Alternate index and base clusters

Secondary index and base clusters

Output files

Input files

Both the files

All the above is correct

Create Database

Update Table

Drop Views

Reverse Table

SELECT COUNT(*) FROM Persons

SELECT COLUMNS() FROM Persons

SELECT COLUMNS(*) FROM Persons

SELECT COUNT() FROM Persons

SELECT

OPEN

GET

EXTRACT

SELECT FirstName FROM Persons

SELECT Persons.FirstName

EXTRACT FirstName FROM Persons

EXTRACT Persons.FirstName

SELECT DISTINCT

SELECT DIFFERENT

SELECT UNIQUE

SELECT SAME

LEFT JOIN

RIGHT JOIN

FULL JOIN

SELF JOIN

True

False

True

False

Alternate Key

Foreign Key

Unique Key

Alias Key

COUNT()

GROUP BY()

SUM()

MAX()

A REXX clause can be coded in uppercase, lowercase or mixed case.

Multiple instructions can be coded on 1 line, as long as they are separated by a ','

A REXX program should start with a comment clause /* REXX */

Continuation of REXX instructions is achieved by using a ',' as a continuation indicator