Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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 4420

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

1 4171

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

1 3981

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

1 4087

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

1 4038

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

1 3883

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

1 3744

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

1 3874

How can a cross product be created?

1 4464

What is an user exit used for?

1 3908

What are the three types of user exits available ?

1 4909

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

1 3859

what is a display item?

1 3847

What is a list item?

1 3740

What are the display styles of list items?

1 3838

Un-Answered Questions { Oracle }

What is connection pool in oracle?

1040

i am writing a query select EmpNo from Emp how can i call in after parameter form

2196

all steps of bitmap report?

2398

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2164

What are the possible ways to gain information regarding the control file?

620

How many types of canvases are there. Explain them

What is the disk migration? what is the steps involved in oracle disk migration?

1274

How I can use srw.run_report in reports6i?

How to define an oracle cursor variable?

1094

List out the types of joins.

1243

How do you recover a lost control file?

Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?

Difference between hot backup vs. Cold backup?

1043

How to add a new column to an existing table in oracle?

1192

What are the attributes of the cursor?

1061

For More Un-Answered { Oracle } Questions Click Here