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 the different file extensions that are created by oracle reports?

1 8547

From which designation is it preferred to send the output to the printed?

1 3703

Is it possible to disable the parameter from while running the report?

1 4455

What is lexical reference?How can it be created?

1 4396

What is bind reference and how can it carate?

1 3686

What use of command line parameter cmd file?

1 3672

Where is a procedure return in an external pl/sql library executed at the client or at the server?

1 3655

Where is the external query executed at the client or the server?

Wipro,

2 5342

What are the default parameter that appear at run time in the parameter screen?

1 4282

Which parameter can be used to set read level consistency across multiple queries?

1 3459

What is term? What is use of term?

1 3867

Is it possible to insert comments into sql statements return in the data model editor?

1 3662

If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

1 4895

What are the sql clauses supported in the link property sheet?

1 4212

To execute row from being displayed that still use column in the row which property can be used?

1 3333

Un-Answered Questions { Oracle }

Hi Can any one tell me what are the API's used in requisition import.

1917

Explain the types of record group.

definition of cluster and non-clustered index?

3025

When should you increase copy latches?

639

What is partitioned table in Oracle?

1183

What is a nvl function? How can it be used?

1018

What is sequence?

1075

What do you understand by oracle forms and why are they required?

1009

What does the no logging option do? Why would we use it? Why would we be careful of using it?

548

Tell me some differences between ODI 10g and ODI 11g?

558

Explain how to close periods in ar. : oracle accounts receivable

1309

What is user managed backup in Oracle?

1134

In what script is snap$ created? In what script is the scott/tiger schema created?

2708

What is raw datatype?

1132

What is a dead lock in oracle?

1115

For More Un-Answered { Oracle } Questions Click Here