What output will the follwing statement produce? Select NVL2(NULL,'NOT NULL', NULL) from dual;
A -
NULL
B -
NOT NULL
C -
Function NVL2 is not defined
D -
None of the above
2-
Which three definitions are associated with implicit cursors?
A -
%rowtype, %toomanyrows, %found
B -
%found, %notfound, %rowcount
C -
%rowtype, %rowcount, %notfound
D -
None of the above
3-
In this PL/SQL statement, which of the following lines will produce an error?
A -
cursor CAPITALS is
B -
select CITY, STATE
C -
into my_city, my_state
D -
from CITIES
4-
In a PL/SQL block, a variable is declared as NUMBER without an initial value. What will its value be when it is first used in the executable section of the PL/SQL block?
A -
NULL
B -
0
C -
Results in a compilation error
D -
An exception will be raised
5-
PL/SQL raises an exception, in which TWO of the following cases:
A -
When a SELECT statement returns no rows
B -
When a SELECT statement returns more than one row
C -
When the datatypes of SELECT clause and INTO clause do not match
D -
When INTO statement is missing in the SELECT statement
6-
PL/SQL raises an exception, in which TWO of the following cases:
A -
When a SELECT statement returns no rows
B -
When a SELECT statement returns more than one row
C -
When the datatypes of SELECT clause and INTO clause do not match
D -
Both a & b
7-
What is the result if two NULL values are compared to each other?
A -
TRUE
B -
False
C -
Undefined
D -
NULL
8-
Functions for error trapping are contained in which section of a PL/SQL block?
A -
Header
B -
Declarative
C -
Executable
D -
Exception
9-
Which section of a PL/SQL block would most likely contain a RAISE statement?