DECLARE CURSOR is executable.
True
False
Count(*) ignores null
subqueries cannot have union
Sqlcode foreign key constraint is
531
530
513
533
default of orderby is
DSC
ASC
DSS
ASS
Which of the following is not an isolation type
RR
CS
RS
SS
Which of the following statements about PL/I programs are TRUE? (2 answers)
a program must always begin with a PROCEDURE statement and end with an END statement
PL/I instructions can be coded between positions 1 and 72
you have to declare each variable that you are going to use
a program can be composed out of different procedures
comment lines have to be preceded by //
A PL/I programmer wants to repeat an instruction 5 times. How can he/she code this?
REPEAT 5 TIMES;instruction;END;
DO J=1 TO 5;instruction;END;
COUNTER = 1;DO WHILE COUNTER < 5;COUNTER = COUNTER + 1;instruction;END;
REPEAT VARYING COUNTER FROM 1 BY 1 UNTIL COUNTER = 5;instruction;END;
Which of the following names of variables for data items are syntactically correct? (2 answers)
READ
RECORD-IN
@_RECORD
IN/OUTRECORD
1_TELEPHONE
Where in a PL/I program are you obliged to code a ; (semi colon) ? (3 answers)
after each declaration of a variable
at the end of each instruction
to end a DO instruction
at the end of the program
to end an IF instruction