Explain the use of Merge statement in oracle 11g
What do database buffers contain?
what is unique key?
14 Answers Amazon, Cap Gemini, Infosys, Wipro,
Can multiple cursors being opened at the same time?
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
How to convert times to characters in oracle?
List out the types of joins.
Explain rename?
What is Private Database Link ?
When do you get a .pll extension in oracle? Explain its importance
How many memory layers are in the shared pool?
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
What is Index and different types of Indexes?