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?

1052

Is there a function to split a string in plsql?

1055

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?

1024

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

1090

How do I escape a reserved word in oracle?

1197

How to best split csv strings in oracle 9i?

1041

What is different types of joins?

1021

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

1000

How to get last row id?

991

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

1029

Un-Answered Questions { Oracle }

how can you pass values to-and-fro from foreign function?

Which files are vital that should be backed up?

603

what is oracle forms?

1104

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4520

Where in the Oracle directory tree structure are audit traces placed?

2636

What is the load plans in odi?

633

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

1039

Have you created sequence? When will you use?

560

What are the various benefits of using rac architecture?

How many types of synonyms in Oracle?

1122

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

629

How can we identify the resources for which the sessions are waiting?

How many types of km's? And you what are the type's km are used in your project?

577

Explain the use of indexes option in imp command.

1179

What is a trigger oracle?

1085

For More Un-Answered { Oracle } Questions Click Here