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

How can a square be drawn in the layout editor of the report writer?

1 3999

What are the triggers associated with the image item?

1 3662

Give the sequence of execution of the various report triggers?

1 5981

What is the difference between setting up of parameters in reports 2.0 reports ?

1 4028

Name of the functions used to get/set canvas properties?

1 4989

Can you attach an lov to a field at run-time? if yes, give the build-in name.

1 4985

What is a record Group?

2 4697

Does a grouping done for objects in the layout editor affect the grouping done in the datamodel editor?

1 4147

What is relation between the window and canvas views?

ABC,

2 10434

Is the After report trigger fired if the report execution fails?

2 5342

Can you attach an lov to a field at design time?

1 4391

How image_items can be populate to field in forms 4.0?

1 3735

What are the two ways to incorporate images into a oracle forms application?

1 3899

What are the types of calculated columns available?

1 4311

What is a predefined exception available in forms 4.0?

1 3804

Un-Answered Questions { Oracle }

hiding item in report how like that properly,thats manually but at runtime i want to do

3232

various types of hints and their usage

2697

What is the full form of dba?

602

What is the use of Markers?

595

how to handle exceptions in post production

1424

Can we invoke one form from another in a multi-forms application?

1131

How many data types are supported?

1079

How to write a left outer join with the where clause in oracle?

1084

What are the five main functions of a database administrator?

632

What are the goals of dba?

558

what is the difference between substr and instr function in oracle?

1090

You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?

541

How is rman better than user-managed backup recovery process?

You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?

609

What kinds of responsibilities does a dba have in a database environment?

606

For More Un-Answered { Oracle } Questions Click Here