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.

969

Explain mutating triggers.

978

Give the different types of rollback segments.

986

How can you use check constraints for self referential integrity?

924

How many types of database triggers exist?

1077

Give the various exception types.

952

List the parts of a database trigger.

997

Explain oracle’s server parameter file.

953

Explain overloading. Can functions be overloaded?

944

Give the advantages and disadvantages of clusters.

1004

Define oracle database

1000

Explain oracle instance.

1117

What is ceil and floor in oracle?

1019

Can a parameter be passed to a cursor?

1059

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

1021

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain oracle instance.

1117

How to recover a dropped table in oracle?

988

What is tns entry?

1071

Explain implicit cursor.

969

What is a dead lock in oracle?

1055

How to Truncate Table in Oracle

1106

What are dml statements in oracle?

1050

How to load a large xml file?

1009

Explain the difference between sql and oracle?

1034

Define oracle database

1000

Explain how are indexes update?

1027

How to best split csv strings in oracle 9i?

997

Explain the use of compress option in exp command.

972

if you ctreate table identity

2320

What privilege is needed for a user to query tables in another schema?

930

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