Why use resource manager in Oracle?
What is blob datatype?
What is Private Database Link ?
i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
What are inner join and outer join?
Explain 1st, 2nd, 3rd normalization form of data base
Explain the concept of the DUAL table.
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
What is using clause and give example?
Explain the use of analyse option in exp command.
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
How do you store pictures in a database?
query optmization techniques and quwry analyser+projects+ppts