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 5096

What dynamic data replication ?

2 6547

How can you Enforce Refrencial Integrity in snapshots ?

1 4254

What are the options available to refresh snapshots ?

2 5991

what is snapshot log ?

2 7632

When will the data in the snapshot log be used ?

2 5329

What are the benefits of distributed options in databases ?

1 4463

Whatz the main diff between Subquery and a Join

Oracle, Zeta Interactive,

14 33454

Define Transaction ?

5 10583

When does a Transaction end ?

2 7506

What does COMMIT do ?

4 10531

What is SAVE POINT ?

5 9565

What is Read-Only Transaction ?

3 6556

What is the function of Optimizer ?

1 4454

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

2 5188

Un-Answered Questions { Oracle }

How to do clean up if create database failed?

1026

How many types of segments in Oracle?

1064

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2946

How to best split csv strings in oracle 9i?

1040

What is difference between sid and service name in oracle?

950

What are the benefits of oracle real application clusters (rac)?

Can you tell me how to add new column in existing views?how?How is possible?

1434

Explain procedure to change characterset of a database.

618

What is the Tune Query

2287

What is an Oracle Data Segment?

1041

If you are working Microsoft excel, which type of file you used .excel or .csv?

638

How I can use srw.run_report in reports6i?

What are the various constraints used in oracle?

1039

What is merge in oracle?

1052

What is oracle log switch?

611

For More Un-Answered { Oracle } Questions Click Here