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.

979

Give the different types of rollback segments.

986

How can you use check constraints for self referential integrity?

924

How many types of database triggers exist?

1078

Give the various exception types.

952

List the parts of a database trigger.

997

Explain oracle’s server parameter file.

953

Explain overloading. Can functions be overloaded?

945

Give the advantages and disadvantages of clusters.

1004

Define oracle database

1000

Explain oracle instance.

1118

What is ceil and floor in oracle?

1019

Can a parameter be passed to a cursor?

1059

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

1021

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is the relationship among database, tablespace and data file?

938

What is format trigger?

2024

What is partitioned table in Oracle?

1120

How do I manually create a database in oracle?

970

What are oracle functions?

988

How to connect the oracle server as sysdba?

1023

How to filter out duplications in the returning rows using oracle?

989

How to pass parameters to procedures?

983

What is a database schema in oracle?

1065

What is the difference between PFILE and SPFILE in Oracle?

1002

Is postgres faster than oracle?

980

What is a nested table and how is it different from a normal table?

996

How to declare a local variable?

1063

Can you have more than one content canvas view attached with a window ?

2274

Explain cascading triggers.

1020

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