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?
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?
How do I become a dba?
You see a wait on lms process in statspack, what does that mean?
What are the different types of backup available in the oracle?
Which dba certification is best?
Tell me about standby database? What are some of the configurations of it? What should we watch out for?
What is an artificial (derived) primary key?
Why do we need a database?
Do you need a commit after ddl statements?
What are roles in oracle?
How do I become a database administrator?
Discuss row chaining, how does it happen?
Which database is best to learn?
What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?