Can a Tablespace hold objects from different Schemes ?
Answers were Sorted based on User's Feedback
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).
What is currency type in database ?
How can we create the complete backup of data in the oracle.
0 Answers IPEC, Satyam, SunTec,
What is difference between a formal and an actual parameter?
difference between imlicit cursor and explicit cursor ?
what are bitmap indexes? How does they work?
What is query image?
Is oracle a relational database?
Explain user account with reference to oracle.
What is the recommended interval at which to run statspack snapshots, and why?
Explain the types of exception?
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.