What do you understand by recovery catalog?

529

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

531

Discuss row chaining, how does it happen? How do you correct it?

504

How does one coalesce free space?

514

How do you install statspack?

643

Explain the wait events in statspack report 'enqueue'?

537

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

520

What does a dba do all day?

510

What are the different types of database users?

533

You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?

566

How can you determine if an index needs to be dropped and rebuilt?

523

How do you prevent output from coming to the screen?

486

Which is the best option used to move database from one server to another serve on same network and why?

511

What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?

554

What is a dba?

553