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

Oracle General Interview Questions

Questions Answers Views Company eMail

What are the factors causing the reparsing of SQL statements in SGA?

1 4497

Whatz the main diff between Subquery and a Join

Oracle, Zeta Interactive,

14 33948

Define Transaction ?

5 10769

When does a Transaction end ?

2 7613

What does COMMIT do ?

4 10724

What is SAVE POINT ?

5 9770

What is Read-Only Transaction ?

3 6705

What is the function of Optimizer ?

1 4558

What are the different approaches used by Optimizer in choosing an execution plan ?

2 5302

What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

2 4825

What are the values that can be specified for OPTIMIZER MODE Parameter ?

1 4025

Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?

1 4046

What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?

1 4187

What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?

1 4417

What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 4476

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2376

6. Display the client name and order date for all orders using the traditional method.

2366

What is a snapshot in oracle database?

1075

How to use "in" parameter properly?

1121

Why do we need integrity constraints in a database?

1080

Can I create users through internet explorer in oracle 10g?

1160

What are the uses of synonyms?

1192

How to change user password in oracle?

1099

What is private procedure oracle?

1051

How to load data from external tables to regular tables?

1108

What are the differences between char and nchar in oracle?

1146

What do you mean by merge in oracle and how can we merge two tables?

1097

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1096

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

2564

What is a subquery in oracle?

1169

For More Un-Answered { Oracle General } Questions Click Here