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 4413

Whatz the main diff between Subquery and a Join

Oracle, Zeta Interactive,

14 33469

Define Transaction ?

5 10590

When does a Transaction end ?

2 7508

What does COMMIT do ?

4 10535

What is SAVE POINT ?

5 9576

What is Read-Only Transaction ?

3 6564

What is the function of Optimizer ?

1 4458

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

2 5194

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

2 4690

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

1 3949

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

1 3965

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

1 4124

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

1 4343

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

1 4384

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a table in oracle?

974

Explain the use of file option in exp command.

1127

Give the different types of rollback segments.

1028

Is postgres faster than oracle?

1025

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1908

How to see free space of each tablespace?

1033

Explain the use of full option in exp command.

1113

What are the different types of synonyms?

1135

What is index in Oracle?

1070

How to drop a tablespace?

1043

What is the data type of dual table?

991

How to create a table index in oracle?

1132

What is blob data type in oracle?

1117

Explain implicit cursor.

1022

In the oracle version 9.3.0.5.0, what does each number shows?

1293

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