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,

2025

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

Oracle,

4 8154

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

Oracle,

1 6269

Can a formula column referred to columns in higher group ?

Oracle,

2506

Can a formula column be obtained through a select statement ?

Oracle,

2324

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

Oracle,

2559

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

Honeywell, Oracle,

1 4123

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

Oracle,

1 4972

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,

2292

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

Oracle,

1 7038

What is trigger associated with the timer ?

Oracle,

1 6728

What are the trigger associated with image items ?

Oracle,

1 6840

What are the different windows events activated at runtime ?

Oracle,

2900

Un-Answered Questions { Oracle }

What is a matrix report and how many minimum groups are required to prepare the same?

1139

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

1296

Can we modify approve purchase order?if yes what is navigation?

2010

how to implement data validations?

590

What is Java Pool in Oracle?

1169

What is the database name in oracle?

1021

What to do if the binary spfile is wrong for the default instance?

1069

How to create a stored function in oracle?

1105

Which flexfields you have customized?

What is the use of the drop option in the alter table command?

596

What is explain plan and how is it used?

607

What is a dba why is this position necessary?

573

What are the different optimizers that are used to optimize database?

Explain the dml?

981

How to bring a tablespace online?

1079

For More Un-Answered { Oracle } Questions Click Here