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?

561

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?

618

How do I become a dba?

576

You see a wait on lms process in statspack, what does that mean?

564

What are the different types of backup available in the oracle?

579

Which dba certification is best?

560

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

543

What is an artificial (derived) primary key?

604

Why do we need a database?

584

Do you need a commit after ddl statements?

555

What are roles in oracle?

559

How do I become a database administrator?

567

Discuss row chaining, how does it happen?

558

Which database is best to learn?

560

What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?

573