What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
282When using oracle export/import what character set concerns might come up? How do you handle them?
299Post New Oracle DBA (Database Administration) Questions
Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?
What are the beneficial tools for administering the database?
When should an artificial (or derived) primary key be used?
What skills should a dba have?
Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?
What is the difference between a database and instance? What is the relation between them?
Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
Does dba need to know programming?
If you see statistics that deal with "undo" what are they really talking about?
What are the different types of database users?
How can you find out how many users are currently logged into the database?
What is oracle log switch?
What is an artificial (derived) primary key?
What is pga_aggregate_target?
What is the advantage of using rman?