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

How to compare dates in oracle sql?

1162

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

1111

How to handle a single quote in oracle sql?

1101

Is there a function to split a string in plsql?

1109

How to speed up webrick?

1130

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

1108

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

1091

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

1075

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

1149

How do I escape a reserved word in oracle?

1264

How to best split csv strings in oracle 9i?

1099

What is different types of joins?

1081

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

1050

How to get last row id?

1062

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

1090

Un-Answered Questions { Oracle }

How do I connect to oracle database?

1204

What is pga_aggregate_target?

632

How can I introduce multiple conditions in like operator?

1056

Explain the difference between a procedure and a function? What do you understand by those terms?

1136

Where is the multi connections are used in ORACLE DATA INTEGATOR?

674

Mention what are the tools provided in oracle enterprise manager?

What is catalog in Oracle?

1443

Can you create a synonym without having a table?

1097

List the various oracle database objects?

1115

What are a collation and state the different types of collation sensitivity?

1252

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

2389

What is data file?

1155

What is a named program unit?

1140

What are the ways tablespaces can be managed and how do they differ?

2455

How to join two tables in a single query using oracle?

1054

For More Un-Answered { Oracle } Questions Click Here