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

What are different Oracle database objects?

1 2665

What is difference between SUBSTR and INSTR?

1 3021

Display the number value in Words?

1 3084

What is difference between SQL and SQL*PLUS?

1 2944

What are various joins used while writing SUBQUERIES?

2 4010

What a SELECT FOR UPDATE cursor represent.?

1 2899

Display the records between two range?

2 3629

Select the Nth lowest value from a table?

4 5475

What is difference between Rename and Alias?

1 4479

Difference between an implicit & an explicit cursor.?

2 7417

What is a OUTER JOIN?

1 2802

What is the purpose of a cluster?

1 3348

What is OCI. What are its uses?

1 3221

How you open and close a cursor variable.Why it is required?

2 3774

Display Odd/ Even number of records?

3 6562

Un-Answered Questions { Oracle }

Is it possible to execute a dynamic sql from forms?

1066

How to use "in" parameter properly?

1060

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

981

What is oracle latest version?

1092

How can you use check constraints for self referential integrity?

963

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1997

Describe varray?

1054

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2128

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

1163

Explain enable novalidate constraint.

1073

What is concurrency in oracle?

1003

Is insert autocommit in oracle?

1065

Is rowid unique in oracle?

996

How to see the table columns used in an index?

1017

What is the history of ODI?

642

For More Un-Answered { Oracle } Questions Click Here