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?

892

What are the different oracle database objects?

1040

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

955

What is the difference between translate and replace?

1019

How can we delete duplicate rows in a table?

942

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

1143

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

927

How different is ms access and oracle?

995

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

1016

State some uses of redo log files?

957

What is coalesce function?

1026

How can we view last record added to a table?

978

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

971

What is the usage of merge statement?

1105

Explain the difference between a procedure and a function?

1104

Un-Answered Questions { Oracle }

What is logical backup in oracle?

978

Explain about your project and its relation to the current job position you are applying to?

953

What is oracle data type?

915

How to load data through external tables?

1085

What is blob data type in oracle?

1059

How to get the Installed Oracle Version Information ?

1090

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

1152

List the parts of a database trigger.

998

What are the constraints in odi?

575

What are the various types of snapshots ?

988

candidate key is subset of super key but not vice-verse explain

2027

How to filter out duplications in the returning rows using oracle?

991

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1950

What is ASM (Automatic Storage Management) in Oracle?

1147

What is the purpose of a staging area?

For More Un-Answered { Oracle } Questions Click Here