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 4004

What are the triggers associated with the image item?

1 3669

Give the sequence of execution of the various report triggers?

1 5986

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

1 4037

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

1 4994

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

1 4990

What is a record Group?

2 4711

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

1 4160

What is relation between the window and canvas views?

ABC,

2 10450

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

2 5355

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

1 4401

How image_items can be populate to field in forms 4.0?

1 3743

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

1 3902

What are the types of calculated columns available?

1 4315

What is a predefined exception available in forms 4.0?

1 3807

Un-Answered Questions { Oracle }

Explain integrity constraint?

1164

What is responsibility and how u attach How to create user and how u attach with responsibility.

2042

What do you understand by format trigger?

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2132

How to increment dates by 1 in oracle?

1097

What is an external table?

1027

Explain the various types of canvas in form.

What are summary column and placeholder column in reports?

Query to retrieve record for a many to many relationship ?

2523

What is a password file in a database and why is it required when a user can be authenticated using data dictionary tables?

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2225

Does dba need to know programming?

575

What is the difference between a primary key & a unique key?

1092

Give one method for transferring a table from one schema to another?

608

What does a dba do all day?

558

For More Un-Answered { Oracle } Questions Click Here