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 4488

Whatz the main diff between Subquery and a Join

Oracle, Zeta Interactive,

14 33919

Define Transaction ?

5 10758

When does a Transaction end ?

2 7609

What does COMMIT do ?

4 10722

What is SAVE POINT ?

5 9763

What is Read-Only Transaction ?

3 6698

What is the function of Optimizer ?

1 4555

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

2 5298

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

2 4814

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

1 4021

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

1 4041

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

1 4182

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

1 4415

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

1 4471

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain about integrity constraint?

1177

Can we write dml statement in function in oracle?

1125

What is oracle server autotrace in oracle?

1221

What is a view and how is it different from a table?

1128

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1096

What is SQL access advisor in Oracle?

1230

How to write text literals in oracle?

1118

How to use regular expression in pattern match conditions in oracle?

1075

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2066

How to create a stored procedure in oracle?

1150

What do you mean by merge in oracle?

1029

What is oracle open database communication (odbc)?

1083

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4685

What is a database table in oracle?

1070

What is BBED in Oracle?

1197

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