How to define an oracle cursor variable?
State any two functions of oracle?
In what script is snap$ created? In what script is the scott/tiger schema created?
Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What is a system tablespace and when it is created?
The join defined by the default data link is an outer join yes or no ?
what is dynamic SGA and static SGA
Can we store pictures in the database and if so, how it can be done?
Write a trigger example in oracle?
What is an Extent ?
What is an Index ?
when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?