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?

644

What is the difference between sga and pga?

618

What do you mean by oracle database?

572

What are the important tasks of common oracle dba?

560

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

589

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

569

What is the difference between cold backup and hot backup?

583

What are the various ingredients of sga?

572

What do you understand by the oracle?

551

Explain the term 'oracle grid architecture'?

587

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

586

What are the main benefits of using spfile over pfile?

641

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

556

What are the different responsibilities of a dba?

722

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

550

Post New Oracle DBA (Database Administration) Questions

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

What is explain plan and how is it used?

607

How can you determine if an oracle instance is up from the operating system level?

559

What are dba privileges?

534

Tell me about standby database? What are some of the configurations of it?

568

What is oracle full backup?

570

What is dump destination? What are bdump, cdump and udump?

562

What file will give you oracle instance status information? Where is it located?

625

What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?

577

What is the meaning of database backup?

626

What does an oracle dba do?

602

What are functions of dba?

551

Are database administrators in demand?

565

How many control files should you have?

591

How can you determine the space left in a file system?

649

You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?

541

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