The structure of simple explicit cursor is
open cursor; ---some statements close;
open cursor; fetch into variables; ---some statements close cursor;
open cursor; fetch into variables; ---some statements close;
All of the above
What does the cursor attribute ‘%rowcount’ do?
Check whether cursor has fetched any row
Check whether cursor has not fetched any row.
Check the number of rows returned by the cursor
Both A and C
The data type returned by a ‘%FOUND’ cursor attribute is
NUMBER
BOOLEAN
CHARACTER
STRING
True of False :A package specification can exist without a body
True
False
In which property does a NUMBER datatype differs from a PLS_INTEGER datatype
Padding
Length
Storage
How many types of triggers are there?
4
8
12
16
A database storage is stored in the database as
In compiled form
As source code
Both A and B
None of the above
What are the modes of parameters that can be passes to a procedure?
IN
IN, OUT
IN, OUT,INOUT
IN, OUT, INOUT , OUTIN
The default mode of parameters that can be passes to a procedure?
OUT
OUTIN
INOUT
What are the types of cursors available in plsql?
user defined
implied
implicit and explicit
Implied and user defined