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,

1257

What is memory advisor in Oracle?

MCN Solutions,

1077

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

Atos Origin,

1032

What is background process in Oracle?

MCN Solutions,

1101

What is ASM (Automatic Storage Management) in Oracle?

MCN Solutions,

1196

How many types of table in Oracle?

MCN Solutions,

1121

What is Java Pool in Oracle?

MCN Solutions,

1169

How many types of synonyms in Oracle?

MCN Solutions,

1124

What is materialized view in Oracle?

MCN Solutions,

1074

What is Trigger in Oracle?

MCN Solutions,

1170

What is SQL access advisor in Oracle?

MCN Solutions,

1189

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

MCN Solutions,

1145

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

MCN Solutions,

1109

What is partitioned table in Oracle?

MCN Solutions,

1189

What is recovery manager in Oracle?

MCN Solutions,

1056

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is background process in Oracle?

1101

why dont we assign not null constraint as table level constraint.

2737

What is a parameter file in oracle?

1134

What do you mean by merge in oracle and how can you merge two tables?

948

What are internal user account in oracle?

1006

What is difference between truncate and delete?

1040

How to compare dates in oracle sql?

1102

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1044

How to create id with auto_increment on oracle?

990

What are the numeric comparison operations?

1111

How to use subqueries with the in operator using oracle?

1091

How to start your 10g xe server?

1041

What is transport network substrate (tns) in oracle?

1047

How to Truncate Table in Oracle

1154

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2185

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