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

How do you install statspack?

679

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

547

How do you analyze table partition using oracle provided package?

513

Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)

763

What is oracle partial backup?

577

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

575

How do you put database is archivelog mode, explain procedure?

541

Do you need a commit after ddl statements?

558

Explain the wait events in statspack report 'enqueue'?

574

What is the difference between raid 5 and raid 10? Which is better for oracle?

582

What is the difference between truncate and delete? Why is one faster?

643

Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?

580

What are bind variables and why are they important?

537

Explain force logging feature in 9i.

603

Which rman command is used to create an exact replica of a database innew host?

589

Post New Oracle DBA (Database Administration) Questions

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

What is difference between co-related sub query and nested sub query?

561

What are the different responsibilities of a dba?

706

Can you remove an open file under unix?

690

What is the advantage of using rman?

719

What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?

574

Tell me about standby database? What should we watch out for?

543

What is oracle log switch?

605

What is pga_aggregate_target?

566

How do I become a dba?

579

What is an artificial (derived) primary key?

607

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

609

What does a dba stand for?

569

How do I become a database administrator?

570

What is the use of the drop option in the alter table command?

594

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

554

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