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.

982

Give the different types of rollback segments.

986

How can you use check constraints for self referential integrity?

926

How many types of database triggers exist?

1080

Give the various exception types.

952

List the parts of a database trigger.

997

Explain oracle’s server parameter file.

957

Explain overloading. Can functions be overloaded?

946

Give the advantages and disadvantages of clusters.

1004

Define oracle database

1000

Explain oracle instance.

1121

What is ceil and floor in oracle?

1021

Can a parameter be passed to a cursor?

1062

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

1024

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is meant by joins? List out the types of joins.

969

How to create a table index?

1077

Is truncate autocommit in oracle?

1037

How many types of synonyms in Oracle?

1076

How to use group functions in the select clause using oracle?

1035

What is the quickest way to export a table to a flat file?

928

Explain alias?

1088

How to recover a dropped table in oracle?

990

What do you understand by a database object?

994

What is meant by raw datatype?

1017

What are the restrictions in a oracle read only transaction?

981

What is literal?

960

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

995

What are set operators?

1035

What is dynamic proxy?

969

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