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 4439

Whatz the main diff between Subquery and a Join

Oracle, Zeta Interactive,

14 33578

Define Transaction ?

5 10632

When does a Transaction end ?

2 7528

What does COMMIT do ?

4 10577

What is SAVE POINT ?

5 9621

What is Read-Only Transaction ?

3 6588

What is the function of Optimizer ?

1 4482

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

2 5220

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

2 4724

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

1 3966

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

1 3981

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

1 4139

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

1 4358

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

1 4409

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to connect to the server with user account: sys?

1032

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3063

What are the uses of linked server and explain it in detail?

1072

What is the difference between translate and replace in oracle?

1178

Explain the difference between a procedure and a function?

1186

What is partitioned table in Oracle?

1206

What is a tns service name?

1021

Explain the different normalization forms?

1116

What is a cognitive schema?

988

How do I recompile a procedure in oracle?

976

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2133

Is oracle an open source?

1092

What is the difference between sharding and replication?

1064

How can we find out the current date and time in oracle?

1101

How to create a stored function in oracle?

1120

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