Oracle DBA (Database Administration) Interview Questions
Questions Answers Views Company eMail

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

318

A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?

384

You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?

291

If you have an example table, what is the best way to get sizing data for the production table implementation?

295

What file will give you oracle instance status information? Where is it located?

298

A tablespace has a table with 30 extents in it. Is this bad? Why or why not.

304

How would you find total size of database in os level?

303

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

377

What is an artificial (derived) primary key?

285

What is different type of rman backup?

329

You see multiple fragments in the system tablespace, what should you check first?

297

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

295

Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?

319

How do you set up your tablespace on installation level: low?

304

If you see the value for reloads is high in the estat library cache report is this a matter for concern?

357


Post New Oracle DBA (Database Administration) Questions

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

What is a production dba?

302


What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?

329


What is main function of database administrator?

298


When configuring sqlnet on the client what files need to be set up?

273


What is difference between co-related sub query and nested sub query?

312






What is difference between logical standby database and physical standby database?

309


Explain the wait events in statspack report 'db sequential real'?

297


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

298


How can you find your id on a system?

289


What is an artificial (derived) primary key?

285


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

268


What skills do you need to be a database administrator?

288


Explain the term 'oracle grid architecture'?

307


If you have an example table, what is the best way to get sizing data for the production table implementation?

295


How many types of database software are there?

306