Which of the following will be a better compilation methodology for a Procedure that involves only looping structures.
NATIVE
INTERPRETTED
BOTH
NONE
You can commit inside a trigger
Yes, there is a workaround, but not directly
yes directly
no
I dont Know
The keyword IS & AS in Procedure definition
Both are same
IS will only work
AS will only work
Both cannot be used in procedure definition
Native dynamic sql works faster than dbms_sql
True
False
If a procedure that has overloaded procedures is called
Normal Procedure
Overloaded Procedure
Packaged Procedure
None of these
Which is performance friendly
VARRAY
PL/SQL TABLE
NESTED TABLE
NONE OF THESE
ascii() function would display the corresponding ASCII code of the string enclosed
In Program overloading, You have two procedures with same name. which of the following will not work
Having the data type different
Just interchange the input parameter
having the name diffferent
both a & b
CURSOR FOR loop can be opened with the command...
OPEN
FETCH
PARSE
None, cursor for loops handle cursor opening implicitly
In Oracle 9i, we can specify the FIRING order in which the that are created on a table