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

What are the steps involved in instance recovery in oracle?

277

What is oracle log switch?

291

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

290

What do you mean by oracle dba and what is its role?

275

What is the advantage of using rman?

350

What are the beneficial tools for administering the database?

278

Which files are vital that should be backed up?

297

What do you understand by a control file?

265

What do you understand by recovery catalog?

291

What do you understand by the term 'system change number (scn)'?

308

What is the difference between a database and instance?

344

What do you mean by oracle dba?

277

What is the meaning of database backup?

278

What do you understand by the term 'normalization'?

284

Explain the various modes of normalization?

278


Post New Oracle DBA (Database Administration) Questions

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

What is a database instance?

280


What is the main function of database?

283


What is da in database?

271


What are the skills required for oracle dba?

289


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

311






When should the default values for oracle initialization parameters be used as is?

290


What are the different types of database users?

276


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

263


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?)

343


What are the daily activities of oracle dba?

307


You are getting busy buffer waits. Is this bad? How can you find what is causing it?

286


Explain the term 'oracle grid architecture'?

287


What are roles in oracle?

275


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

267


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

292