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.

1031

Explain mutating triggers.

1029

Give the different types of rollback segments.

1031

How can you use check constraints for self referential integrity?

970

How many types of database triggers exist?

1135

Give the various exception types.

993

List the parts of a database trigger.

1050

Explain oracle’s server parameter file.

992

Explain overloading. Can functions be overloaded?

986

Give the advantages and disadvantages of clusters.

1050

Define oracle database

1044

Explain oracle instance.

1177

What is ceil and floor in oracle?

1069

Can a parameter be passed to a cursor?

1126

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

1068

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are the restrictions on external table columns?

1053

When do we use group by clause in a sql query?

1035

What is a trigger oracle?

1086

How to change program global area (pga) in oracle?

1093

What is a initialization parameter file in oracle?

1035

Is oracle an operator?

923

What happens if you use a wrong connect identifier?

1065

What is the difference between $oracle_base and $oracle_home?

1089

What is an oracle transaction?

1146

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1916

What do you understand by a database object? Can you list a few of them?

1018

Explain rename?

981

Is oracle a language?

946

What are group functions in oracle?

1041

What is a proxy class?

1053

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