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,

1256

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,

1119

What is Java Pool in Oracle?

MCN Solutions,

1168

How many types of synonyms in Oracle?

MCN Solutions,

1121

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,

1187

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,

1187

What is recovery manager in Oracle?

MCN Solutions,

1054

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Is oracle a language?

944

How to do clean up if create database failed?

1027

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1882

What is java oracle used for?

1020

What are the attributes of cursor?

1054

What are the limitations oracle database 10g xe?

1046

How do I recompile a procedure in oracle?

964

How to define a specific record type?

1084

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1927

What is object data modeling?

962

How to use subqueries with the exists operator in oracle?

1027

How to start instance with a minimal initialization parameter file?

1040

How to drop an existing table in oracle?

1058

State the various uses of dbcc command?

1060

How to write date and time literals in oracle?

1002

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