What is the cache hit ratio, what impact does it have on
performance of an Oracle database and what is involved in
tuning it?
What are the components of Logical database structure of ORACLE database?
What is a subquery?
Explain oracle’s server parameter file.
Why required to run root.sh at the time of installation and what exactly it will do
After update how do u know how many records got updated
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How can we find the size of a database?
Difference between pre-select and pre-query
What are a query and state the different types of queries and their uses?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What is a nvl function? How can it be used?
Why does for update in oracle 8 cause an ora-01002 error?