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 ?

2363

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,

2033

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

Oracle,

4 8170

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

Oracle,

1 6285

Can a formula column referred to columns in higher group ?

Oracle,

2510

Can a formula column be obtained through a select statement ?

Oracle,

2334

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

Oracle,

2572

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

Honeywell, Oracle,

1 4139

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

Oracle,

1 4984

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

Oracle,

1 3659

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,

2299

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

Oracle,

1 7052

What is trigger associated with the timer ?

Oracle,

1 6736

What are the trigger associated with image items ?

Oracle,

1 6854

What are the different windows events activated at runtime ?

Oracle,

2907

Un-Answered Questions { Oracle }

What are the goals of dba?

562

When should you increase copy latches? What parameters control copy latches?

574

Which process writes data from data files to database buffer cache?

614

Which data loaded are in target db?

577

What is the difference between truncate and delete? Why is one faster?

652

What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?

633

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

2572

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2561

How to write date and time interval literals in oracle?

1039

How to define default values for formal parameters?

1054

What is a tns file?

1003

What is the oracle implicit cursor?

1068

How to name query output columns in oracle?

1193

What are the types of windows (window style)?

Can group functions be mixed with non-group selection fields?

1026

For More Un-Answered { Oracle } Questions Click Here