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?

1102

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

1056

How to handle a single quote in oracle sql?

1053

Is there a function to split a string in plsql?

1056

How to speed up webrick?

1076

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

1048

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

1020

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

1025

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

1090

How do I escape a reserved word in oracle?

1198

How to best split csv strings in oracle 9i?

1041

What is different types of joins?

1022

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

1001

How to get last row id?

992

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

1029

Un-Answered Questions { Oracle }

Does oracle partitioning improve performance?

992

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2261

key flexfield structure

2176

What are different types of transactions in ar? : oracle accounts receivable

1296

How to get a create statement for an existing table?

969

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2265

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1045

If you have an example table, what is the best way to get sizing data for the production table implementation?

554

How to invoke the data pump import utility?

1162

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2275

What is oracle rowcount?

1084

What are the goals of dba?

558

Explain the use of analyse option in exp command.

1128

Explain the blob datatype?

1071

what is the link between suppliers and banks in ap module in oracle apps? And also query?

2472

For More Un-Answered { Oracle } Questions Click Here