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

What is the relation between database and instance?

291

What is the difference between sga and pga?

313

What do you mean by oracle database?

261

What are the important tasks of common oracle dba?

277

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

281

What are the possible ways to gain information regarding the control file?

278

What is the difference between cold backup and hot backup?

307

What are the various ingredients of sga?

276

What do you understand by the oracle?

256

Explain the term 'oracle grid architecture'?

290

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

296

What are the main benefits of using spfile over pfile?

306

What do you understand by the term 'normalization'? Explain the various modes of normalization?

259

What are the different responsibilities of a dba?

300

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

286


Post New Oracle DBA (Database Administration) Questions

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

What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?

304


What is the difference between a database and instance?

344


What is the full form of dba?

301


What are dba privileges?

257


How do you prevent oracle from giving you informational messages during and after a sql statement execution?

280






What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?

263


How do I become a dba?

292


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

286


List five most important parameter in 9i affecting performance?

277


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

279


How does one create a new database?

305


What is a dba?

281


Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

295


Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.

287


What does an oracle dba do?

301