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 9590

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

2502

how the indexes are stored in the Oracle Database?

2268

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

Oracle,

2336

various types of hints and their usage

2688

various types of joins

9 10248

what is the difference between UNION AND UNIONALL

4 12940

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

2262

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

1 4836

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

2014

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

2197

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

1 4215

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

2 14302

how do u setup a replication site?

1975

what is a Nested Loop join?

2103

Un-Answered Questions { Oracle }

What is oracle used for?

1020

How do I uninstall oracle client from windows?

1007

What are named parameters?

1086

What is a tns service name?

1001

Explain what are the characteristics of data files?

1081

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5533

explain what is odi?why is it different from the other etl tools.

605

Explain temporal data types in oracle

1089

What are data pump export and import modes?

1059

What are the file storage options provided by oracle database for oracle rac?

What is a oracle database?

1051

What does dba stand for in technology?

541

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

How do you store pictures in a database?

998

State some uses of redo log files?

995

For More Un-Answered { Oracle } Questions Click Here