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

Is it possible to set a filter condition in a cross product group in matrix reports?

1 4346

If a break order is set on a column would it effect columns which are under the column?

1 4023

With which function of summary item is the compute at options required?

1 3908

What is the purpose of the product order option in the column property sheet?

1 4010

How can a button be used in a report to give a drill down facility?

1 3944

What are the two ways by which data can be generated for a parameter's Using static values?

1 3767

What are the two panes that Appear in the design time pl/sql ?

1 3641

What are three panes that appear in the run time pl/sql interpreter?

1 3797

How can a cross product be created?

1 4348

What is an user exit used for?

1 3826

What are the three types of user exits available ?

1 4827

How can I message to passed to the user from reports?

1 3780

what is a display item?

1 3745

What is a list item?

1 3638

What are the display styles of list items?

1 3755

Un-Answered Questions { Oracle }

what are the tools used for oracle 10g in real time.

2436

How do I spool in oracle?

998

Name the various constraints used in oracle?

1011

Why should I use oracle database?

984

What is oracle rownum?

947

What is a staging area? Do we need it?

What is a named program unit?

1068

What is Trigger in Oracle?

1163

Explain the use of table functions.

2466

What are the conditions kept in mind while connecting the oracle rac with the network?

How to recover a dropped table in oracle?

1035

Explain the dml?

973

How to resolve name conflicts between variables and columns?

1026

How do I call oracle stored procedures that take no parameters?

1104

What is the difference between raid 5 and raid 10? Which is better for oracle?

583

For More Un-Answered { Oracle } Questions Click Here