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
All of the above
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
Integration testing is combination of Black box and White box testing.