What is dump destination? What are bdump, cdump and udump?

621

List five most important parameter in 9i affecting performance?

610

How can you determine if an oracle instance is up from the operating system level?

605

What is the use of the drop option in the alter table command?

637

As an oracle dba what are the entire unix file you should be familiar with?

626

What os user should be used for the first part of an oracle installation (on unix)?

590

How much money does a dba make?

631

What parameters control copy latches?

638

What do you understand by the term 'normalization'? Explain the various modes of normalization?

597

What is ora-1555 snapshot too old error? Explain in detail?

739

What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?

675

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

602

How can you tell if an index on particular table is used or not used in 9i?

598

What is dba in sound level?

640

What do you understand by recovery catalog?

601