Tag: technology

NULLIF(X,Y)

COALESCE(X,Y)

ZEROIFNULL(X,Y)

NULLIFZERO(X,Y)

A

B

V

X

4

5

6

7

True

False

STOP RUN is the last executable statement of the main program. It returns control back to OS.

EXIT PROGRAM is the last executable statement of sub-program. It returns control back to main program.

GOBACK can be coded in main program as well as sub-program as the last statement. It just gives the control back from where it received the control.

None of the above.

True

False

GetSystemDate()

GetDate()

GetCurrentDateTime()

None

Return Top 3 Row in the Retailer Table

Return Error

Return No Record

Return all Records from Retailer Table

GetSystemDate()

GetDate()

GetCurrentDateTime()

None

Return Top 3 Row in the Retailer Table

Return Error

Return No Record

Return all Records from Retailer Table