Oracle DBA (Database Administration) Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle DBA (Database Administration) Interview Questions

Questions Answers Views Company eMail

What is the relation between database and instance?

597

What is the difference between sga and pga?

566

What do you mean by oracle database?

538

What are the important tasks of common oracle dba?

520

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

541

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

515

What is the difference between cold backup and hot backup?

547

What are the various ingredients of sga?

528

What do you understand by the oracle?

515

Explain the term 'oracle grid architecture'?

546

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

546

What are the main benefits of using spfile over pfile?

594

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

520

What are the different responsibilities of a dba?

658

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

514

Post New Oracle DBA (Database Administration) Questions

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

What is dba in sound level?

542

Which process writes data from data files to database buffer cache?

572

What is da in database?

500

What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?

554

What is the main function of database?

560

Explain procedure to change characterset of a database.

573

You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?

568

How would you find total size of database in os level?

520

What are the roles and responsibilities of oracle dba?

603

What are the beneficial tools for administering the database?

508

What is a database instance?

548

What are the requirements of simple database?

527

What is different type of rman backup?

622

What are the five functions of a database?

567

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

539

For More Un-Answered { Oracle DBA (Database Administration) } Questions Click Here