Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.

579

What file will give you oracle instance status information? Where is it located?

625

Which dba certification is best?

577

You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.

594

How many databases should a dba manage?

659

What is tkprof and how is it used?

615

What kinds of responsibilities does a dba have in a database environment?

608

List five most important parameter in 9i affecting performance?

572

What degree do database administrators need?

553

The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?

581

What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?

645

What is da in database?

547

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?

571

What are dba privileges?

542

If you are not sure what command does a particular unix function what is the best way to determine the command?

569