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

What is the difference between NAME_IN and COPY ?

2 38689

Identify package function from the following ?

1 3974

How does the command POST differs from COMMIT ?

2 6817

What the PAUSE package procedure does ?

1 4109

What package procedure is used for calling another form ?

3 8619

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

1 4071

Error_Code is a package proecdure ?

1 4229

EXIT_FORM is a restricted package procedure ?

1 4715

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 4089

List the system variables related in Block and Field?

1 4777

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

3 13389

What is an User Exits ?

1 3909

What are the type of User Exits ?

1 4015

What do you mean by a page ?

1 3834

How many pages you can in a single form ?

1 3609

Un-Answered Questions { Oracle }

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

663

What does the no logging option do? Why would we be careful of using it?

661

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2264

What are the different types of failures that occur in Oracle database?

1126

What are the limitations of check constraint?

1078

What is pga_aggregate_target?

633

How to use in conditions in oracle?

1119

Explain the truncate in oracle?

1015

What is the minimum client footprint required to connect c# to an oracle database?

1167

Explain the different normalization forms?

1161

What are the functions of administration?

612

How is incremental backup different from differential backup?

What is a nvl function? How can it be used?

1102

What is an external table?

1086

Explain about your project and its relation to the current job position you are applying to?

1080

For More Un-Answered { Oracle } Questions Click Here