What are the types of locks in database?

Question Posted / divya_gupta

No Answer is Posted For this Question
Be the First to Post Answer

More Oracle DBA (Database Administration) Interview Questions

What are the goals of dba?

Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?

What is the difference between internal & external schema?

How many dba can you have?

Explain procedure to change characterset of a database.

What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?

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

What are the requirements of simple database?

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

How do you use automatic pga memory management with oracle 9i and above?

What is an artificial (derived) primary key?

What are the five main functions of a database administrator?

For more Oracle DBA (Database Administration) Interview Questions Click Here