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

Briefly explain what is literal? Give an example where it can be used?

1093

Explain about the analyze command in oracle?

1113

Difference between cartesian join and cross join?

1093

Point the difference between translate and replace?

1152

What are the major difference between truncate and delete?

1138

What is a sub query? Describe its types?

1075

What is the difference between count (*), count (expression), count (distinct expression)?

1049

Point out the difference between user tables and data dictionary?

1039

What do you mean by merge in oracle and how can you merge two tables?

1010

Difference between the “verify” and “feedback” command?

1431

What do you mean by merge in oracle?

1035

Describe an oracle table?

1105

What are the differences between primary key and unique key?

1067

What is the difference between substr and instr?

1093

Describe varray?

1118

Un-Answered Questions { Oracle }

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2523

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1333

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4236

How can I combine multiple rows into a comma-delimited list in oracle?

1124

How to do a full database export?

1154

If you see statistics that deal with "undo" what are they really talking about?

702

What is the use of aggregate functions in oracle?

1075

How to create Drill down report?

2188

What is oracle forms system.currentblock?

What is connection pooling in oracle?

1021

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

2441

How will you write a query to get a 5th rank student from a table student_report?

1926

Explain what are clusters?

1161

When do I need to use a semicolon vs a slash in oracle sql?

1148

What is mrc and what is its use? : oracle accounts receivable

1312

For More Un-Answered { Oracle } Questions Click Here