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 are the two phases of block coordination?

1 4728

What are Most Common types of Complex master-detail relationships?

1 3953

What are the different types of Delete details we can establish in Master-Details?

1 3869

What are the different defaust triggers created when Master Deletes Property is set to Non-isolated?

1 4338

Whar are the different default triggers created when Master Deletes Property is set to Cascade?

1 4507

What are the different default triggers created when Master Deletes Property is set to isolated?

1 5239

What are the Coordination Properties in a Master-Detail relationship?

1 7451

What are the different types of Coordinations of the Master with the Detail block?

2 4627

What is the User-Named Editor?

1 3603

What are the Built-ins to display the user-named editor?

1 4213

What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?

1 12186

What is an LOV?

2 4533

What is the basic data structure that is required for creating an LOV?

1 4368

What is the "LOV of Validation" Property of an item? What is the use of it?

1 10809

What are the built_ins used the display the LOV?

1 3983

Un-Answered Questions { Oracle }

what is difference between group above and group left report

3814

What is the difference between PFILE and SPFILE in Oracle?

1058

What is odi studio?

579

How to list all tables in your schema?

1050

why dont we assign not null constraint as table level constraint.

2733

Explain the various types of canvas in form.

What is the difference between raid 5 and raid 10? Which is better for oracle?

583

How to resolve name conflicts between variables and columns?

1026

How can you determine what protocol is being used for interconnect traffic?

Explain procedure to change characterset of a database.

620

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1942

what is semphore explian it?

2808

Can we save images in a database and if yes, how?

1057

How is rman better than user-managed backup recovery process?

what is difference between inner join & nested query or subqueries

3029

For More Un-Answered { Oracle } Questions Click Here