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 2671

What is difference between SUBSTR and INSTR?

1 3034

Display the number value in Words?

1 3093

What is difference between SQL and SQL*PLUS?

1 2953

What are various joins used while writing SUBQUERIES?

2 4017

What a SELECT FOR UPDATE cursor represent.?

1 2912

Display the records between two range?

2 3635

Select the Nth lowest value from a table?

4 5488

What is difference between Rename and Alias?

1 4482

Difference between an implicit & an explicit cursor.?

2 7426

What is a OUTER JOIN?

1 2805

What is the purpose of a cluster?

1 3355

What is OCI. What are its uses?

1 3227

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

2 3790

Display Odd/ Even number of records?

3 6579

Un-Answered Questions { Oracle }

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2399

What is Data Dictionary Cache in Oracle?

1163

What do you understand by the oracle?

551

How to increment dates by 1 in oracle?

1085

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

558

What are active transformation / passive transformations?

How do I become a database administrator?

572

i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1980

What causes the "snapshot too old" error? How can this be prevented or mitigated?

519

What is the difference between hot backup and cold backup in oracle?

1014

please explain.. DB architecture ...

2020

can u plz provide me oca sql dumps please i need them

1948

Is oracle a language?

946

What is the difference between BPA AND Contract What are documents and test cases u followed

2379

How to use select statement to count the number of rows in oracle?

1044

For More Un-Answered { Oracle } Questions Click Here