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

What do you know about normalization? Explain in detail?

951

What are the different oracle database objects?

1091

State all possible different index configurations a table can possibly have?

1001

What is the difference between translate and replace?

1060

How can we delete duplicate rows in a table?

973

What is a cursor and what are the steps need to be taken?

1202

Compare and contrast between sql and sql server and explain its various functions?

964

How different is ms access and oracle?

1038

How to display employee records who gets more salary than the average salary in the department?

1065

State some uses of redo log files?

1007

What is coalesce function?

1072

How can we view last record added to a table?

1038

What is the maximum number of triggers that can be applied to a single table?

1024

What is the usage of merge statement?

1154

Explain the difference between a procedure and a function?

1169

Un-Answered Questions { Oracle }

How to rename a tablespace in oracle?

1086

How to commit the current transaction in oracle?

1120

What is meant by a deadlock situation?

1109

In the oracle version 9.3.0.5.0, what does each number shows?

1301

Can you joined two sources without common column?

616

Can we store pictures in the database and if so, how it can be done?

1044

What is the recommended interval at which to run statspack snapshots, and why?

2918

What is a connect identifier?

1039

What is responsibility and how u attach How to create user and how u attach with responsibility.

2041

What is Virtual Private Database in Oracle?

1090

How to use "in" parameter properly?

1071

Step by step explain for the Flat file?

673

What is archive log in Oracle?

1134

Can we invoke one form from another in a multi-forms application?

1131

What does the no logging option do? Why would we be careful of using it?

601

For More Un-Answered { Oracle } Questions Click Here