What are types of data model?
I have applied the following commands: now what will happen, will the database will give an error / it will work?
You have taken a manual backup of a datafile using os. How rman will know about it?
What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
What do you understand by the oracle?
What is the difference between truncate and delete? Why is one faster?
What do you understand by the term 'normalization'?
What is dba training?
Is oracle dba in demand?
Discuss row chaining, how does it happen? How can you reduce it?
What is ora-1555 snapshot too old error? Explain in detail?
How do you generate file output from sql?
What are bind variables and why are they important?
If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?