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 9611

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

2511

how the indexes are stored in the Oracle Database?

2273

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

Oracle,

2351

various types of hints and their usage

2701

various types of joins

9 10309

what is the difference between UNION AND UNIONALL

4 12981

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

2266

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

1 4860

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

2027

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

2205

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

1 4234

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

2 14328

how do u setup a replication site?

1992

what is a Nested Loop join?

2120

Un-Answered Questions { Oracle }

what is semphore explian it?

2821

Please explain oracle left join with an example?

1053

What are the uses of synonyms?

1139

how to clone 9i Database on to 10g Database.

2344

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2183

what is the difference between substr and instr function in oracle?

1094

System tablespace cant be exported from one database and imported into another why?

561

Why do we need integrity constraints in a database?

1027

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

2002

You see a wait on lms process in statspack, what does that mean?

575

How to view existing locks on the database?

1057

What happens to the data files if a tablespace is dropped?

1062

Which files are vital that should be backed up?

603

Can we store pictures in the database and if so, how it can be done?

1047

as a technical developer in oracle applications which type errors feced in your experience sofar

2334

For More Un-Answered { Oracle } Questions Click Here