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

1 4842

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

1 4054

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

1 3989

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

1 4463

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

1 4599

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

1 5342

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

1 7536

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

2 4728

What is the User-Named Editor?

1 3694

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

1 4306

What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?

1 12284

What is an LOV?

2 4639

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

1 4443

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

1 10912

What are the built_ins used the display the LOV?

1 4063

Un-Answered Questions { Oracle }

How to define a cusotmer as a supplier in ORACLE R12

2310

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2424

all steps of bitmap report?

2398

What is split brain syndrome in rac?

Explain the payment term in ar. : oracle accounts receivable

1155

Explain what are the advantages of views?

1110

What is transaction control statement and how many types of transaction control statement in Oracle?

1246

What are the tools for Oracle ?

1114

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

596

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 ?

2067

What are the different pseudo commands? Explain in general?

1129

What is the difference between internal & external schema?

809

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2152

Is there an oracle sql query that aggregates multiple rows into one row?

1032

How to create a temporary table in oracle?

1337

For More Un-Answered { Oracle } Questions Click Here