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,

1185

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,

979

What is background process in Oracle?

MCN Solutions,

1052

What is ASM (Automatic Storage Management) in Oracle?

MCN Solutions,

1126

How many types of table in Oracle?

MCN Solutions,

1065

What is Java Pool in Oracle?

MCN Solutions,

1094

How many types of synonyms in Oracle?

MCN Solutions,

1069

What is materialized view in Oracle?

MCN Solutions,

1044

What is Trigger in Oracle?

MCN Solutions,

1077

What is SQL access advisor in Oracle?

MCN Solutions,

1140

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

MCN Solutions,

1061

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

MCN Solutions,

1059

What is partitioned table in Oracle?

MCN Solutions,

1109

What is recovery manager in Oracle?

MCN Solutions,

996

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How translate command is different from replace?

1009

What happens if the update subquery returns multiple rows?

1049

Does facebook use oracle?

983

Where do we use decode and case statements?

945

How to define an anonymous block?

1075

What is tns entry?

1065

How to loop through data rows in the implicit cursor?

1016

How to change user password in oracle?

975

How do I reset a sequence in oracle?

1054

How to get the Installed Oracle Version Information ?

1076

Explain database link?

1062

How does one get the view definition of fixed views/tables?

969

What privilege is needed for a user to insert rows to tables in another schema?

957

How would you best determine why your MVIEW couldnt FAST REFRESH?

1839

WHAT IS ecc 6.0

2106

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