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

Oracle General (1803)
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 5218

What dynamic data replication ?

2 6662

How can you Enforce Refrencial Integrity in snapshots ?

1 4364

What are the options available to refresh snapshots ?

2 6107

what is snapshot log ?

2 7748

When will the data in the snapshot log be used ?

2 5439

What are the benefits of distributed options in databases ?

1 4568

Whatz the main diff between Subquery and a Join

Oracle, Zeta Interactive,

14 33961

Define Transaction ?

5 10772

When does a Transaction end ?

2 7614

What does COMMIT do ?

4 10729

What is SAVE POINT ?

5 9770

What is Read-Only Transaction ?

3 6708

What is the function of Optimizer ?

1 4561

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

2 5304

Un-Answered Questions { Oracle }

What is an index associated with a constraint?

1094

Â What are the oracle DML commands possible through an update strategy?

1109

8. Supporting AP, AR and GL?

2362

How to pass parameters to procedures in oracle?

1086

How to convert dates to characters in oracle?

1096

Discuss row chaining, how does it happen?

621

What do you understand by anchoring in reports?

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

2269

What is the use of aggregate functions in oracle?

1077

Which database is best to learn?

616

Where do you use decode and case statements?

1047

What is oracle archived redo log?

639

List the various oracle database objects?

1115

What do you understand by a database object? Can you list a few of them?

1068

How to connect to a remote server?

1195

For More Un-Answered { Oracle } Questions Click Here