Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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 6001

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

1 4246

Give built-in routine related to a record groups?

1 4646

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 4326

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

1 4830

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

1 4313

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

1 4059

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

1 4149

what ia an object groups?

1 4571

Explain the following file extention related to library?

1 4140

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

Techbooks,

2 13824

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

1 5060

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

1 3908

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

1 4077

what are different types of canvas views?

3 18055

Un-Answered Questions { Oracle }

Explain the importance of .pll extension in oracle?

1064

What are the different types of record groups in oracle? Explain each of them

1077

What do you understand by format trigger?

How to rollback the current transaction in oracle?

1107

How is incremental backup different from differential backup?

What are the various tools? - Name a few?

What is db_recovery_file_dest in oracle? When do you need to set this value?

1172

How to view the tablespaces in the current database?

1029

what is dynamic SGA and static SGA

4494

How to convert csv to table in oracle?

1050

what is load plans and types of load plans?

673

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

649

What is the difference between 10g OEM and 11g OEM?

1021

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1894

How to load data from multiple files to single target?

611

For More Un-Answered { Oracle } Questions Click Here