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.

1072

Explain mutating triggers.

1086

Give the different types of rollback segments.

1075

How can you use check constraints for self referential integrity?

1012

How many types of database triggers exist?

1182

Give the various exception types.

1035

List the parts of a database trigger.

1107

Explain oracle’s server parameter file.

1037

Explain overloading. Can functions be overloaded?

1042

Give the advantages and disadvantages of clusters.

1096

Define oracle database

1091

Explain oracle instance.

1226

What is ceil and floor in oracle?

1118

Can a parameter be passed to a cursor?

1179

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

1130

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain rename?

1041

How to get a list of all background sessions in the database?

1035

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1089

Explain the difference between sap and oracle?

1081

Can multiple cursors being opened at the same time?

1112

Can we commit inside a function in oracle?

1009

How to assign values to variables?

1163

What are the ways tablespaces can be managed and how do they differ?

2440

What are privileges and grants?

1102

Explain the use of record option in exp command.

1064

What is ASM (Automatic Storage Management) in Oracle?

1240

What are the different types of failures that occur in Oracle database?

1116

What is SQL access advisor in Oracle?

1228

what is the difference between restoring and recovering?

1051

Why we use bulk collect in oracle?

1109

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