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

Can you change the alert messages at run-time?

2 5858

What are the ways to monitor the performance of the report?

1 4174

Give built-in routine related to a record groups?

1 4566

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?

1 4207

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size? If yes,how?

1 4748

At what point of report execution is the before Report trigger fired?

1 4209

Is it possible to attach same library to more than one form?

1 3985

List system variables available in forms 4.0, and not available in forms ?

1 4042

what ia an object groups?

1 4496

Explain the following file extention related to library?

1 4042

What is a physical page ? & What is a logical page ?

Techbooks,

2 13673

What is the built-in used to get and set lov properties during run-time?

1 4943

What are the various methods of performing a calculation in a report ?

1 3828

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

1 3991

what are different types of canvas views?

3 17906

Un-Answered Questions { Oracle }

Explain a data segment?

1062

Differentiate between transaction type and transaction source? : oracle accounts receivable

1114

How to create a stored procedure in oracle?

1100

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2130

Explain the hardware architecture used in oracle rac?

How to change system global area (sga) in oracle?

1004

How to create a single index for multiple columns?

1031

What does database administrator do?

548

How to connect the oracle server as sysdba?

1074

What is the dynamic sql in oracle?

1068

Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2855

in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

2902

If you are not sure what command does a particular unix function what is the best way to determine the command?

563

What are summary column and placeholder column in reports?

As an oracle dba what are the entire unix file you should be familiar with?

573

For More Un-Answered { Oracle } Questions Click Here