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

Difference between inner join vs where ?

996

How to store only time; not date and time?

978

What is the minimum client footprint required to connect c# to an oracle database?

1041

Is there a combination of "like" and "in" in sql?

1024

How can I introduce multiple conditions in like operator?

940

How to load a large xml file?

1013

What is the difference between "as" and "is" in an oracle stored procedure?

959

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

1100

What is the difference between a user and a schema in oracle?

1002

What are the oracle differences between nvl and coalesce

1091

What is the best way to do multi-row insert in oracle?

1031

How do I spool to a csv formatted file using sqlplus?

981

What exactly do quotation marks around the table name do?

932

How to do paging with oracle?

963

How do I limit the number of rows returned by an oracle query after ordering?

1117

Un-Answered Questions { Oracle }

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1920

How to loop through a cursor variable?

1031

What is rac?

What do you know about normalization? Explain in detail?

900

What is the difference between single instance environment and rac environment?

How to find out what oracle odbc drivers are installed?

993

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1348

Explain database link?

1071

Difference between varchar and varchar2 data types?

1136

Explain the difference between a procedure and a function?

1107

What is ora-1555 snapshot too old error? Explain in detail?

633

How to turn on or off recycle bin for the session?

1054

What is a canvas in oracle forms?

1036

What is supporting issues GL AP and AR?

2484

How many categories of data types in oracle?

987

For More Un-Answered { Oracle } Questions Click Here