how the Oracle Prepares the Execution Plan and how it
chooses the Optimal one?
No Answer is Posted For this Question
Be the First to Post Answer
What is the order of defining local variables and sub procedures/functions?
How to open a cursor variable?
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
what is the scenario where you take the database to NoArchivelog mode?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What is concurrency in oracle?
Difference between inner join vs where ?
How to export your connection information to a file?
How does oracle handle read consistency?
What is oracle analytical function?