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 9517

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

2453

how the indexes are stored in the Oracle Database?

2219

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

Oracle,

2299

various types of hints and their usage

2633

various types of joins

9 10010

what is the difference between UNION AND UNIONALL

4 12806

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

2230

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

1 4756

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

1969

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

2149

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

1 4161

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

2 14210

how do u setup a replication site?

1936

what is a Nested Loop join?

2051

Un-Answered Questions { Oracle }

Explain the dml?

928

What is tns entry?

1071

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

2453

How to create a new tablespace in oracle?

939

What is ODI console?

637

How many types of dimensions in oracle?

526

What are the four Oracle system processes that must always be up and running for the database to be useable?

961

Explain the use of indexes option in imp command.

1102

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3006

Which is the best option used to move database from one server to another serve on same network and why?

511

How to display employee records who gets more salary than the average salary in the department?

1009

Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

7917

how to dynamically change the page size of d2k reports?

What is an index associated with a constraint?

982

State some uses of redo log files?

951

For More Un-Answered { Oracle } Questions Click Here