Sunday, August 29, 2010

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?

Interview Questions

set operators

My weak concepts...

constraints for calling functions in sql

Open Questions

When do we use " instead of '?
A PL/SQL program is terminated and executed by a slash (/) on a line by itself.

Notes

Oracle9i can scale tens of thousands of concurrent users, support up to 512 petabytes of data (a petabyte is 1,000 terabytes), and can handle any type of data, including text, spatial, image, sound, video, and time series as well as traditional structured data.
Prior to Oracle9i, user defined functions can be only single-row functions. Starting with Oracle9i, user-defined functions can also be defined as aggregate functions.