Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

Explain implicit cursor.

773

Explain mutating triggers.

784

Give the different types of rollback segments.

791

How can you use check constraints for self referential integrity?

724

How many types of database triggers exist?

762

Give the various exception types.

744

List the parts of a database trigger.

782

Explain oracle’s server parameter file.

754

Explain overloading. Can functions be overloaded?

788

Give the advantages and disadvantages of clusters.

783

Define oracle database

794

Explain oracle instance.

889

What is ceil and floor in oracle?

803

Can a parameter be passed to a cursor?

802

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

818

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2013

Explain oracle left join with an example?

767

Explain oracle instance.

889

How to change user password in oracle?

812

What is an oracle tablespace?

782

What is oracle analytical function?

744

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2038

How to assign values to data fields in record variables?

776

What are the differences between lov and list item?

758

How to convert numbers to characters in oracle?

784

what is insert all statement in sql

5940

What's dateware house and what's clustor with practicle example

1914

What is a trigger and what are its types?

807

What is the disadvantage of User defind function?

2028

How to loop through a cursor variable?

793

For More Un-Answered { Oracle General } Questions Click Here