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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

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

2 4695

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

1 3955

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

1 3967

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 4346

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

1 4386

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

2 4502

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

1 4415

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

1 3931

What is RULE-based approach to optimization ?

1 5300

What is COST-based approach to optimization ?

5 8832

How do you rate yourself in oracle and sql server ?

Keane India Ltd,

2 8495

What is E-R diagram ?

CGI, Keane India Ltd,

2 12467

Draw E-R diagram for many to many relationship ?

Keane India Ltd,

3627

Design database draw er diagram for a certain scenario ?

Keane India Ltd, TATA,

4579

Un-Answered Questions { Oracle }

What are the types of data contol?

613

what is the difference between substr and instr function in oracle?

1090

How to create a stored procedure in oracle?

1102

What are the main components of an oracle rac system?

If you are not sure what command does a particular unix function what is the best way to determine the command?

565

How can you tell if an index on particular table is used or not used in 9i?

564

where the dff data will be stored

2437

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

2324

What is a select query statement in oracle?

967

What is a cursor and what are the steps need to be taken?

1202

What are summary column and placeholder column in reports?

What is the use of Markers?

595

Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?

how to do daily transactions with out sql* loader control file regesterd in apps?

1686

What is meant by a deadlock situation?

1109

For More Un-Answered { Oracle } Questions Click Here