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.

963

Explain mutating triggers.

974

Give the different types of rollback segments.

980

How can you use check constraints for self referential integrity?

920

How many types of database triggers exist?

1068

Give the various exception types.

949

List the parts of a database trigger.

990

Explain oracle’s server parameter file.

949

Explain overloading. Can functions be overloaded?

937

Give the advantages and disadvantages of clusters.

996

Define oracle database

993

Explain oracle instance.

1107

What is ceil and floor in oracle?

1011

Can a parameter be passed to a cursor?

1053

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

1012

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

what is the difference between substr and instr function in oracle?

1036

How do we display rows from the table without duplicates?

920

what is the use of system.effective.date variable in oracle?

1056

What are oracle functions?

976

Can group functions be used in the order by clause in oracle?

940

Why does for update in oracle 8 cause an ora-01002 error?

934

What are temporal data types in oracle?

1066

Explain drop constraint oracle?

991

What is the difference between formal parameters and actual parameters?

1005

What is a view and how is it different from a table?

972

How to synchronize 2 schema's objects?

2117

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

2997

Explain index?

1204

How view is different from a table?

968

What is a select query statement in oracle?

901

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