Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

Can we connect to ORACLE db using Windows Authentication?

MCN Solutions,

1183

What is memory advisor in Oracle?

MCN Solutions,

1027

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

Atos Origin,

978

What is background process in Oracle?

MCN Solutions,

1052

What is ASM (Automatic Storage Management) in Oracle?

MCN Solutions,

1124

How many types of table in Oracle?

MCN Solutions,

1063

What is Java Pool in Oracle?

MCN Solutions,

1094

How many types of synonyms in Oracle?

MCN Solutions,

1066

What is materialized view in Oracle?

MCN Solutions,

1043

What is Trigger in Oracle?

MCN Solutions,

1076

What is SQL access advisor in Oracle?

MCN Solutions,

1137

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

MCN Solutions,

1060

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

MCN Solutions,

1058

What is partitioned table in Oracle?

MCN Solutions,

1107

What is recovery manager in Oracle?

MCN Solutions,

993

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain the features of oracle?

991

What is a dynamic performance view in oracle?

949

What is null value in oracle?

1037

What is pragma autonomous transaction in oracle?

993

what are archived logs?

2144

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2078

What is procedure overloading in oracle?

994

What do you mean by a database transaction & what all tcl statements are available in oracle?

934

can u plz provide me oca sql dumps please i need them

1901

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

1012

How do we display rows from the table without duplicates?

920

How to return top 5 rows in oracle?

991

What is the usage of merge statement?

1097

How to change system global area (sga) in oracle?

960

What are the major difference between truncate and delete?

984

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