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

What is the difference between NAME_IN and COPY ?

2 38579

Identify package function from the following ?

1 3875

How does the command POST differs from COMMIT ?

2 6703

What the PAUSE package procedure does ?

1 4020

What package procedure is used for calling another form ?

3 8356

What package procedure used for invoke sql plus from sql forms ?

1 3979

Error_Code is a package proecdure ?

1 4139

EXIT_FORM is a restricted package procedure ?

1 4632

When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

1 3987

List the system variables related in Block and Field?

1 4672

What is the difference between system.current_field and system.cursor_field ?

3 13256

What is an User Exits ?

1 3809

What are the type of User Exits ?

1 3926

What do you mean by a page ?

1 3762

How many pages you can in a single form ?

1 3534

Un-Answered Questions { Oracle }

What is the data pump import utility?

1029

Why does oracle 9i treat an empty string as null?

1045

What happens if the constraint name is left out of a constraint clause?

540

What are the types of profiles in ODI?

592

what systems can odi extract and load data into?

584

Explain constraining triggers.

1087

How oracle handles dead locks?

1064

Explain the difference between a procedure and a function?

1165

What is the difference between post-database commit and post-form commit?

1185

What is the sequence of firing in report trigger?

What is Redo Log Buffer in Oracle?

1200

Why do we need to rebuild indexes?

How to define and use table alias names in oracle?

937

Is there any function in oracle similar like group_concat of mysql?

1049

What is key preserved table?

1013

For More Un-Answered { Oracle } Questions Click Here