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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

statement string in open is null or 0 length ORA-40735

RoboSoft, Unilog,

1 9507

types of indexes and the rationale behind choosing a particular index for a situation.

2445

how the indexes are stored in the Oracle Database?

2214

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

Oracle,

2291

various types of hints and their usage

2627

various types of joins

9 9962

what is the difference between UNION AND UNIONALL

4 12783

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2220

what are the things that you consider while creating indexes on partitioning tables?

1 4746

what happened to the global index when I truncate the data in one of the partition?

1965

what are the advantages of running a database in archive log mode?

2144

what are the advantages of running a database in NO archive log mode?

1 4147

what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?

2 14194

how do u setup a replication site?

1926

what is a Nested Loop join?

2041

Un-Answered Questions { Oracle }

What are the steps involved in instance recovery in oracle?

499

How to declare a local variable?

1055

What do you understand by recovery catalog?

518

What is the difference between a hot backup and a cold backup in oracle?

961

Explain what are synonyms used for?

983

What are object group?

What is olr?

How do I limit the number of oracle database connections generated by weblogic server?

1008

What is clustered table in Oracle?

1108

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2214

What is path setting for dll?

Which directory will you copy your new reports, what would be its extension (.rdf or .rex)?

Explain the blob datatype?

1016

Please explain compound trigger in oracle?

996

What are the major difference between truncate and delete?

985

For More Un-Answered { Oracle } Questions Click Here