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 5879

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

1 4174

Give built-in routine related to a record groups?

1 4574

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 4217

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

1 4756

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

1 4216

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

1 3994

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

1 4068

what ia an object groups?

1 4505

Explain the following file extention related to library?

1 4048

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

Techbooks,

2 13685

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

1 4955

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

1 3832

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

1 3996

what are different types of canvas views?

3 17919

Un-Answered Questions { Oracle }

How to add a new column to an existing table with a default value?

1016

How to initialize variables with default values?

1243

What are the attributes of the cursor?

1004

How to drop a stored procedure in oracle?

1051

1) Does oracle have any table which contain all the exceptions and it's code internally?

1749

Explain view?

1034

Explain how one can iterate through items and records in a specified block?

1128

How do you put database is archivelog mode, explain procedure?

549

20. Using a set operator, display the client number of all clients who have never placed an order.

2187

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2265

What are the parameters that we can pass through a stored procedure?

1064

What are the data types in oracle?

1040

What is a database table in oracle?

1022

What is the difference between substr & instr functions?

1228

How to join two tables in a single query using oracle?

997

For More Un-Answered { Oracle } Questions Click Here