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 3916

What are the triggers associated with the image item?

1 3590

Give the sequence of execution of the various report triggers?

1 5869

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

1 3945

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

1 4899

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

1 4884

What is a record Group?

2 4604

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

1 4031

What is relation between the window and canvas views?

ABC,

2 10303

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

2 5228

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

1 4296

How image_items can be populate to field in forms 4.0?

1 3648

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

1 3811

What are the types of calculated columns available?

1 4232

What is a predefined exception available in forms 4.0?

1 3729

Un-Answered Questions { Oracle }

What is the difference between restoring a database and recovering a database?

What is an Oracle database Full Backup?

1087

How to drop an existing view in oracle?

905

How to make the project as .exe file in oracle forms & reports(d2k)?

What are the different pseudo commands? Explain in general?

1022

What are the predefined tablespaces in a database?

1011

Explain mutating triggers.

974

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1996

What are oracle functions?

976

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 ?

1967

How to work with data objects interactively?

927

Have you used lexical parameters in reports?

How to delete all rows a table in oracle?

1010

What are the various ingredients of sga?

523

What is meant by raw datatype?

1005

For More Un-Answered { Oracle } Questions Click Here