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

What are elements of administration?

293

What does a senior database administrator do?

277

What is da in database?

265

What skills do you need to be an administrator?

269

What is the most common database language that a db administrator needs to know?

253

What are the data management skills?

228

What are types of data model?

277

How long does it take to learn database administration?

272

Who is a database user?

262

What are the types of locks in database?

285

What is end user in database?

282

Why do we need a database?

271

What is a junior dba?

279

What are the functions of administration?

283

Which database is best to learn?

270


Post New Oracle DBA (Database Administration) Questions

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

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

277


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

273


Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?

293


What are the different types of backup available in the oracle?

284


If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

293






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

277


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

286


What are database skills?

268


Explain the wait events in statspack report 'enqueue'?

274


A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.

294


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

269


What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

336


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?

261


What are the requirements of simple database?

272


How do you install statspack?

386