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

What is the difference between sga and pga?

312


What do you mean by oracle database?

259


What are the important tasks of common oracle dba?

275


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

279


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

274


What is the difference between cold backup and hot backup?

305


What are the various ingredients of sga?

274


What do you understand by the oracle?

255


Explain the term 'oracle grid architecture'?

285


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

294


What are the main benefits of using spfile over pfile?

302


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

257


What are the different responsibilities of a dba?

298


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

282


How can be determining the size of the log files?

270