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?

725

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

590

How do you analyze table partition using oracle provided package?

559

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?)

828

What is oracle partial backup?

640

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

610

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

583

Do you need a commit after ddl statements?

610

Explain the wait events in statspack report 'enqueue'?

622

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

638

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

702

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

628

What are bind variables and why are they important?

593

Explain force logging feature in 9i.

654

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

631

Post New Oracle DBA (Database Administration) Questions

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

How many dba can you have?

579

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

590

How many types of database software are there?

629

I am getting error "no communication channel" after changing the domain name? What is the solution?

648

Explain procedure to change characterset of a database.

683

Explain force logging feature in 9i.

654

What is the difference between sga and pga?

667

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

619

How can I learn oracle dba?

601

What is the difference between internal & external schema?

809

What does dba stand for in technology?

591

What are some indications that you need to increase the shared_pool_size parameter?

615

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

611

How to drop an oracle database?

606

If you have an example table, what is the best way to get sizing data for the production table implementation?

601

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