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 center an object horizontally in a repeating frame that has a variable horizontal size ?

2355

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

Oracle,

2023

Can a field be used in a report without it appearing in any data group ?

Oracle,

4 8148

The join defined by the default data link is an outer join yes or no ?

Oracle,

1 6263

Can a formula column referred to columns in higher group ?

Oracle,

2505

Can a formula column be obtained through a select statement ?

Oracle,

2321

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

Oracle,

2557

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

Honeywell, Oracle,

1 4119

When a form is invoked with call_form, Does oracle forms issues a save point ?

Oracle,

1 4970

Can a property clause itself be based on a property clause ?

Oracle,

1 3649

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

Oracle,

2291

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

Oracle,

1 7036

What is trigger associated with the timer ?

Oracle,

1 6726

What are the trigger associated with image items ?

Oracle,

1 6831

What are the different windows events activated at runtime ?

Oracle,

2900

Un-Answered Questions { Oracle }

How would you best determine why your MVIEW couldnt FAST REFRESH?

1889

what systems can odi extract and load data into?

589

What is a nested table and how is it different from a normal table?

1048

What are the different oracle database objects?

1091

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1294

Query to retrieve record for a many to many relationship ?

2518

I need to run a report at scheduled timings only. I don't want to run the report on sundays. How to do this?

What do you understand by format trigger?

What is the history of ODI?

646

Explain parameter file in oracle.

1028

What are the types of windows (window style)?

What is an Oracle Data Segment?

1041

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2969

In topology manager where the data are stored?

677

What is bulk collect in oracle?

996

For More Un-Answered { Oracle } Questions Click Here