1. Categories >> Software >> Databases >> Oracle >> Oracle DBA (Database Administration)
  2. Suggest New Category
Oracle DBA (Database Administration) Interview Questions
Questions Answers Views Company eMail

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

 301

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

 279

Which function is used to find the largest integer less than or equal to aspecific value?

 291

Explain procedure to change characterset of a database.

 323

What is oracle archived redo log?

 279

what does the no logging option do? Why would we use it?

 267

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

 282

List five most important parameter in 9i affecting performance?

 273

What is the difference between rman and a traditional hotbackup?

 1 766

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

 271

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

 285

What does the no logging option do? Why would we be careful of using it?

 272

Tell me about standby database? What are some of the configurations of it?

 266

When using oracle export/import what character set concerns might come up? How do you handle them?

 299

Which date function is used to find the difference between two dates?

 268

Post New Oracle DBA (Database Administration) Questions

Un-Answered Questions { Oracle DBA (Database Administration) }

Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?

269

What are the beneficial tools for administering the database?

278

When should an artificial (or derived) primary key be used?

325

What skills should a dba have?

280

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

282




What is the difference between a database and instance? What is the relation between them?

279

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

265

Does dba need to know programming?

279

If you see statistics that deal with "undo" what are they really talking about?

378

What are the different types of database users?

276

How can you find out how many users are currently logged into the database?

313

What is oracle log switch?

290

What is an artificial (derived) primary key?

263

What is pga_aggregate_target?

291

What is the advantage of using rman?

348

For More Un-Answered { Oracle DBA (Database Administration) } Questions Click Here