What is the cache hit ratio, what impact does it have on
performance of an Oracle database and what is involved in
tuning it?
No Answer is Posted For this Question
Be the First to Post Answer
Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks
I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
How to retrieve first and last records from a table?
can you write commit in triggers?
What is index-organized table in Oracle?
what is port in oracle? how is it related to database application.
How to end the current transaction in oracle?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
Is it possible to enter only time value into a column of a table in sql?
What is the difference between translate and replace in oracle?