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

What is the relation between database and instance?

310

What is the difference between sga and pga?

335

What do you mean by oracle database?

283

What are the important tasks of common oracle dba?

295

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

298

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

295

What is the difference between cold backup and hot backup?

325

What are the various ingredients of sga?

298

What do you understand by the oracle?

273

Explain the term 'oracle grid architecture'?

307

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

314

What are the main benefits of using spfile over pfile?

319

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

275

What are the different responsibilities of a dba?

324

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

299


Post New Oracle DBA (Database Administration) Questions

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

How can you find dead processes?

300


How do you install statspack?

411


Which database is best to learn?

298


What are the main benefits of using spfile over pfile?

319


Why are recursive relationships bad? How do you resolve them?

303






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

301


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

295


What do you understand by the term 'normalization'?

307


You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?

294


How can you find all the processes on your system?

316


Why do we need a database?

300


What exactly does a dba do?

310


What does an oracle dba do?

319


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

298


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

330