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 4733

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

1 3964

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

1 3876

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

1 4346

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

1 4511

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

1 5245

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

1 7456

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

2 4638

What is the User-Named Editor?

1 3613

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

1 4226

What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?

1 12200

What is an LOV?

2 4543

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

1 4377

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

1 10818

What are the built_ins used the display the LOV?

1 3984

Un-Answered Questions { Oracle }

How to create a temporary table in oracle?

1268

Differences between package and loadplans?

589

What is meant by an index?

1145

What is a Garbage Collection? and what is full recursive Garbage collection?

2902

Where does the clusterware write when there is a network or storage issue?

In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

1906

You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?

601

How can you find out how many users are currently logged into the database? How can you find their operating system id?

539

How to concatenate two text values in oracle?

1113

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

601

How do we get field detail of a table?

1080

What is object data modeling?

965

How do I manually uninstall oracle client?

1086

How can you find all the processes on your system?

570

What are the attributes of the cursor?

1004

For More Un-Answered { Oracle } Questions Click Here