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

Oracle General (1803)
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 4828

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

1 4028

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

1 4046

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

1 4188

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

1 4421

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

1 4478

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

2 4619

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

1 4519

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

1 4022

What is RULE-based approach to optimization ?

1 5404

What is COST-based approach to optimization ?

5 9050

How do you rate yourself in oracle and sql server ?

Keane India Ltd,

2 8598

What is E-R diagram ?

CGI, Keane India Ltd,

2 12589

Draw E-R diagram for many to many relationship ?

Keane India Ltd,

3676

Design database draw er diagram for a certain scenario ?

Keane India Ltd, TATA,

4635

Un-Answered Questions { Oracle }

Explain the use of indexes option in exp command.

1213

How can we view last record added to a table?

1110

Are database administrators in demand?

620

How to write numeric literals in oracle?

1238

Have you attend the client meetings?

661

Can you remove an open file under unix?

730

What are the differences between interval year to month and interval day to second?

1070

What is a named program unit?

1140

What is the data pump export utility?

1137

What is variable? What is Flow of variable?

670

Why packages are used in oracle?

1124

Whether any commands are used for months calculation? If so, what are they?

1145

How to start a new transaction in oracle?

1138

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2181

In what sequence do triggers get fired by oracle forms?

1027

For More Un-Answered { Oracle } Questions Click Here