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 4738

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

1 3967

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

1 3883

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

1 4356

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

1 4515

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

1 5249

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

1 7463

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

2 4641

What is the User-Named Editor?

1 3621

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

1 4232

What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?

1 12210

What is an LOV?

2 4553

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

1 4387

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

1 10822

What are the built_ins used the display the LOV?

1 3989

Un-Answered Questions { Oracle }

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2290

When should an artificial (or derived) primary key be used?

601

What is private procedure oracle?

1014

How to convert a string to a date in oracle database?

1057

What is the use of oracle?

1031

What is bind variables in oracle reports?

What is ELT? Or What is the difference between ODI and other ETL Tools?

689

You see multiple extents in the temporary tablespace. Is this a problem?

593

How many segment are present in Oracle Manufacturing

2320

Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.

575

How to recover a dropped table in oracle?

1048

Why do we use materialized view instead of table or views?

Is insert autocommit in oracle?

1074

How to define an external table with a text file?

1076

Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?

For More Un-Answered { Oracle } Questions Click Here