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

What are different Oracle database objects?

1 2752

What is difference between SUBSTR and INSTR?

1 3144

Display the number value in Words?

1 3177

What is difference between SQL and SQL*PLUS?

1 3037

What are various joins used while writing SUBQUERIES?

2 4117

What a SELECT FOR UPDATE cursor represent.?

1 2982

Display the records between two range?

2 3726

Select the Nth lowest value from a table?

4 5667

What is difference between Rename and Alias?

1 4579

Difference between an implicit & an explicit cursor.?

2 7540

What is a OUTER JOIN?

1 2878

What is the purpose of a cluster?

1 3434

What is OCI. What are its uses?

1 3303

How you open and close a cursor variable.Why it is required?

2 3875

Display Odd/ Even number of records?

3 6721

Un-Answered Questions { Oracle }

What is the function of having virtual internet protocol address (vip) in oracle rac?

What are the various tools? - Name a few?

What is where clause in oracle?

1080

What is a read only transaction in oracle?

1084

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2441

What is coalesce function?

1149

How would you determine who has added a row to a table?

2389

What is catalog in Oracle?

1443

What is an artificial (derived) primary key?

658

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2568

Can you list down the different components of physical and logical database structure?

Is primary key indexed by default in oracle?

1055

What is autocashrule set? : oracle accounts receivable

1504

Can i create more than one Master Repository in ODI?

654

How is it different from a normal table?

1084

For More Un-Answered { Oracle } Questions Click Here