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 2590

What is difference between SUBSTR and INSTR?

1 2938

Display the number value in Words?

1 3024

What is difference between SQL and SQL*PLUS?

1 2858

What are various joins used while writing SUBQUERIES?

2 3912

What a SELECT FOR UPDATE cursor represent.?

1 2843

Display the records between two range?

2 3547

Select the Nth lowest value from a table?

4 5340

What is difference between Rename and Alias?

1 4401

Difference between an implicit & an explicit cursor.?

2 7302

What is a OUTER JOIN?

1 2726

What is the purpose of a cluster?

1 3256

What is OCI. What are its uses?

1 3161

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

2 3678

Display Odd/ Even number of records?

3 6465

Un-Answered Questions { Oracle }

What is the disadvantage of User defind function?

2251

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2269

What is oracle real application clusters?

What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

2113

What are Oracle Schema Objects?

1060

What should a dba know?

490

What is the difference between flex mode and confined mode?

1002

How to use "for" statements in oracle?

1028

What is explain plan and how is it used?

552

What are the general rules on data consistency?

964

Have you created fact table and dimension tables?

601

ABOUT IDENTITY?

2014

What is the difference between recovery and restoring of the oracle database?

1158

What are bind variables and why are they important?

511

Have you attended the client meetings?

568

For More Un-Answered { Oracle } Questions Click Here