Oracle General Interview Questions
Questions Answers Views Company eMail

What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

2 3381

What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 3620

What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?

1 2933

What is RULE-based approach to optimization ?

1 4532

What is COST-based approach to optimization ?

5 6989

How do you rate yourself in oracle and sql server ?

Keane India Ltd,

2 7292

What is E-R diagram ?

CGI, Keane India Ltd,

2 11143

Draw E-R diagram for many to many relationship ?

Keane India Ltd,

3135

Design database draw er diagram for a certain scenario ?

Keane India Ltd, TATA,

4079


What is Normalization ?

ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,

55 73058

Difference between sub query and nested query ?

Keane India Ltd, TCS,

19 62174

Indexes in oracle ?

Keane India Ltd, L&T,

3 8650

Query to retrieve record for a many to many relationship ?

Keane India Ltd,

2058

Query to get max and second max in oracle in one query ?

CTS, Keane India Ltd, TCS, Wipro,

34 57114


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a table index in oracle?

601


Can you assign multiple query result rows to a variable?

525


What is the usage of save points in oracle database?

516


How to upsert (update or insert into a table)?

516


Why does for update in oracle 8 cause an ora-01002 error?

522






What to do if the binary spfile is wrong for the default instance?

542


What is the meaning of recursive hints in oracle?

510


Explain mutating triggers.

551


Is oracle a relational database?

501


What is max rowid in oracle?

538


How many anonymous blocks can be defined?

563


what is normalisation?what are its uses?

1730


What is translate in oracle?

594


What is the best way to do multi-row insert in oracle?

536


1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

1578