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

How do you install statspack?

386

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

276

How do you analyze table partition using oracle provided package?

252

Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)

335

What is oracle partial backup?

298

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

264

How do you put database is archivelog mode, explain procedure?

275

Do you need a commit after ddl statements?

268

Explain the wait events in statspack report 'enqueue'?

274

What is the difference between raid 5 and raid 10? Which is better for oracle?

283

What is the difference between truncate and delete? Why is one faster?

275

Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?

257

What are bind variables and why are they important?

272

Explain force logging feature in 9i.

281

Which rman command is used to create an exact replica of a database innew host?

253


Post New Oracle DBA (Database Administration) Questions

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

What are the five functions of a database?

297


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?

295


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

270


What are four common errors found in an alert .log?

271


How do I become an administrator?

270






What are the main functions of dba?

262


You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?

255


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

263


What is pct free/pct used/pct increase parameter in segment?

291


What is the full form of dba?

289


What does dba stand for in technology?

271


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

321


What is the relation between database and instance?

282


What is the finger command?

286


What is the easiest method to create a file on unix?

275