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

What is the relation between database and instance?

425

What is the difference between sga and pga?

433

What do you mean by oracle database?

397

What are the important tasks of common oracle dba?

391

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

418

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

409

What is the difference between cold backup and hot backup?

433

What are the various ingredients of sga?

394

What do you understand by the oracle?

381

Explain the term 'oracle grid architecture'?

400

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

428

What are the main benefits of using spfile over pfile?

434

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

402

What are the different responsibilities of a dba?

453

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

394


Post New Oracle DBA (Database Administration) Questions

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

What do you mean by oracle dba?

395


What is the meaning of database backup?

402


How can you determine if the sqlnet process is running for sqlnet v1? How about v2?

415


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

385


When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?

435


What does >> do?

422


What do you understand by the term 'normalization'?

447


What skills should a dba have?

394


How many databases should a dba manage?

428


Do you need a commit after ddl statements?

412


Explain the wait events in statspack report 'db sequential real'?

432


How many control files should you have? Where should they be located?

406


If you see contention for library caches how you can fix it?

404


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

454


What does a senior database administrator do?

434