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.

1022

Explain mutating triggers.

1025

Give the different types of rollback segments.

1027

How can you use check constraints for self referential integrity?

965

How many types of database triggers exist?

1126

Give the various exception types.

990

List the parts of a database trigger.

1047

Explain oracle’s server parameter file.

986

Explain overloading. Can functions be overloaded?

981

Give the advantages and disadvantages of clusters.

1050

Define oracle database

1041

Explain oracle instance.

1171

What is ceil and floor in oracle?

1068

Can a parameter be passed to a cursor?

1116

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

1067

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are dml statements in oracle?

1089

How do I uninstall oracle client from windows?

1007

How to lock and unlock a user account in oracle?

1103

How to export data to a csv file?

1296

Explain an exception?

991

Explain the function of optimizer in oracle?

1139

Define oracle database

1041

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

969

What is integrity and what is constraint??Explain with example

2280

How to start a new transaction in oracle?

1083

How do you bind variables in oracle?

979

How to convert times to characters in oracle?

1025

What is oracle thin client?

1021

How to define a cusotmer as a supplier in ORACLE R12

2228

What are the restrictions on external table columns?

1052

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