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 9599

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

2510

how the indexes are stored in the Oracle Database?

2271

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

Oracle,

2344

various types of hints and their usage

2699

various types of joins

9 10281

what is the difference between UNION AND UNIONALL

4 12962

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

2265

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

1 4852

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

2022

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

2203

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

1 4231

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

2 14316

how do u setup a replication site?

1985

what is a Nested Loop join?

2113

Un-Answered Questions { Oracle }

What is bind variable in oracle 11g?

1039

If you have an example table, what is the best way to get sizing data for the production table implementation?

554

How to create a table index?

1151

Oracle

2376

What are the benefits of oracle rac?

Explain the use of online redo log files in oracle.

1037

Why use resource manager in Oracle?

1105

How can you determine if an index needs to be dropped and rebuilt?

564

Can a formula column be obtained through a select statement ?

2324

What happens if recursive calls get out of control?

1082

How to declare a local variable?

1115

State all possible different index configurations a table can possibly have?

1001

Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1982

Explain what are the type of synonyms?

1111

How many types of canvases are there.

For More Un-Answered { Oracle } Questions Click Here