Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

Differentiate simple and complex, snapshots ?

2 5115

What dynamic data replication ?

2 6568

How can you Enforce Refrencial Integrity in snapshots ?

1 4267

What are the options available to refresh snapshots ?

2 6004

what is snapshot log ?

2 7649

When will the data in the snapshot log be used ?

2 5338

What are the benefits of distributed options in databases ?

1 4475

Whatz the main diff between Subquery and a Join

Oracle, Zeta Interactive,

14 33527

Define Transaction ?

5 10611

When does a Transaction end ?

2 7519

What does COMMIT do ?

4 10555

What is SAVE POINT ?

5 9597

What is Read-Only Transaction ?

3 6577

What is the function of Optimizer ?

1 4468

What are the different approaches used by Optimizer in choosing an execution plan ?

2 5202

Un-Answered Questions { Oracle }

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2969

What should a dba know?

530

Differentiate between post-database commit and post-form commit?

1049

What is the difference between translate and replace in oracle?

1167

What is an oracle tablespace?

1045

What is a tns service name?

1009

What is an external table?

1024

A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.

603

What is the dba role in oracle?

577

How do I uninstall oracle 11g?

1121

Explain the use of rows option in exp command.

1094

What is transaction control statement and how many types of transaction control statement in Oracle?

1162

What is the function of cache fusion in oracle rac?

Oracle Data Integrator Interview Questions and answers?

654

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2294

For More Un-Answered { Oracle } Questions Click Here