You create the following PL/SQL block: DECLARE var1 CONSTANT NUMBER := 50; var2 NUMBER := 0; BEGIN SELECT acctno INTO var2 FROM bank_acct WHERE name = 'JORDAN'; var1 :=var2 + 2000; END; Which of the following lines in this block of PL/SQL code will produce an error?
var2 NUMBER := 0;
INTO var2
WHERE name = 'JORDAN';
var1 :=var2 + 2000;
There are no errors in this PL/SQL block
What statements must be used in order to raise a user-defined exception in PL/SQL?
RAISE
PRAGMA EXCEPTION_INIT
OTHERS
EXCEPTION
What will be the output of the following: void main() { int i; for(i=1;i<=4;i++) { printf("%d",i); continue; } }
1
1234
123
234
What will be the output of the following: void main() { float a=0.7; if(a<0.7) printf("c++"); else printf("c"); }
c++
c
Compile time error
None of these
What will be the output of the following: void main() { char * const ptr="abc"; ptr="xyz"; printf("%s",ptr); }
abc
xyz
What will be the output of the following: void main() { char const *ptr="abc"; ptr="xyz"; printf("%s",ptr); }
What will be the output of the following: void main() { register int a; printf("%d",a); }
0
Garbage value
What is the use of the double trailing "@@" in an input statement?
loads a new record into the input buffer if an end-of-record is found in the current record
holds the current data line in the buffer for another input statement to process
can be used to read multiple observations from a single data line
is a syntax error
The following SAS program is submitted: data work.month; date = put('13mar2000'd,ddmmyy10.); run; Which one of the following represents the type and length of the variable DATE in the output data set?
numeric, 8 bytes
numeric, 10 bytes
character, 8 bytes
character, 10 bytes
A raw data file is listed below: --------10-------20-------30 1901 2 1905 1 1910 6 1925 . 1941 1 The following SAS program is submitted and references the raw data file above: data coins; infile 'file-specification'; input year quantity; run; Which one of the following completes the program and produces a non-missing value for the variable TOTQUANTITY in the last observation of the output data set?
totquantity = sum(totquantity + quantity);
totquantity + quantity;
totquantity 0; sum totquantity;
retain totquantity 0; totquantity = totquantity + quantity;