My Interview Questions :)

IF : more than one if/elsif condition satisfied then all or first ?
FOR i IN 3..3 LOOP statement1; END LOOP; -- how many times?
Null AND FALSE?
NULL OR TRUE?


If a sub-query returns a NULL? any error?
If none of the legs of a Case statement executed in PL/SQL usage then?
Decode/Case : which can be used in PL/SQL?

How does a PL/SQL record helps?
How many coulumns an Index By table have? (Only One)
%Rowcount : rows fetched or total rows in active area? will increment if fetch fails? precuations when basing EXIT on it (use of %NOTFOUND)
%Notfound : what value before first fetch.
Is there a maximum limit to the number of opem cursors per user? (OPEN_CURSORS)
What steps follow a Open cursor statement?

Following is valid?:
WHEN exception1 [OR exception2 . . .] THEN
statement1;
statement2;

Can any thing follow OTHERS in EXCEPTION Bloc?
How many OTHERS clause we have in a EXCEPTION Bloc?
what are pseudoinstructions? and why are they called pseudoinstructions?

Are there any Pre-defined data types for PL/SqL record

Identifier scope and visibility?
Attempts to change the value of an IN parameter will result in an error?
Can IN OUT have a default value?

There must be at least one statement existing in between Begin... End?

can Exceptions appear in assignment statements or SQL statements? No.

Can we Define several exception handlers? How many of them will be processed by PL/SQL?

Can we initialize variable in package specification with a formula? yes.

what are the wildcards? Escape Sequences?

How to restrict insertion of data into a table during business hrs? (say 08.00 to 18.00)
Will rollback happen or not if a trigger fails?
Can we user Old and New qualifier in statement triggers?