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

How to compare dates in oracle sql?

1066

What is the sql query to concatenate column values from multiple rows in oracle?

1013

How to handle a single quote in oracle sql?

989

Is there a function to split a string in plsql?

1006

How to speed up webrick?

1023

How can I get column names from a table in oracle?

1004

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

978

How to connect to oracle using service name instead of sid?

972

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

1042

How do I escape a reserved word in oracle?

1150

How to best split csv strings in oracle 9i?

1003

What is different types of joins?

985

How to fetch the row which has the max value for a column?

964

How to get last row id?

953

How to put more than 1000 values into an oracle in clause?

991

Un-Answered Questions { Oracle }

What is integrity and what is constraint??Explain with example

2232

how to handle exceptions in post production

1375

State the difference between a primary key and foreign key?

898

How are extents allocated to a segment?

1087

What is a trace file and how is it created in oracle?

997

What are the different types of backups that are available in oracle?

is there a tool to trace queries, like profiler for sql server?

1100

What Are Cross Validation & Adi?

1108

how report can be generated if we have the database designed in oracle 10g?

1848

Describe varray?

1011

Which flexfields you have customized?

How to load data through external tables?

1089

Is insert autocommit in oracle?

1035

What are different types of receipt reversals ? Explain them : oracle accounts receivable

1214

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

516

For More Un-Answered { Oracle } Questions Click Here