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 is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

2 4493

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

1 4414

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

1 3924

What is RULE-based approach to optimization ?

1 5297

What is COST-based approach to optimization ?

5 8821

How do you rate yourself in oracle and sql server ?

Keane India Ltd,

2 8486

What is E-R diagram ?

CGI, Keane India Ltd,

2 12455

Draw E-R diagram for many to many relationship ?

Keane India Ltd,

3625

Design database draw er diagram for a certain scenario ?

Keane India Ltd, TATA,

4577

Difference between primary key and unique key ?

Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,

77 210044

What is Normalization ?

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

55 87852

Difference between sub query and nested query ?

Keane India Ltd, TCS,

19 68461

Indexes in oracle ?

Keane India Ltd, L&T,

3 10511

Query to retrieve record for a many to many relationship ?

Keane India Ltd,

2516

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

CTS, Keane India Ltd, TCS, Wipro,

34 65357

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain self joins in oracle?

1013

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2291

What is a parameter file in oracle?

1131

Name the various constraints used in oracle?

1015

What privilege is needed for a user to create indexes in oracle?

1026

How do I spool in oracle?

1000

What is oracle thin client?

1021

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2119

What is Undo Management Advisor in Oracle?

1093

How can Oracle users be audited?

1106

What is an oracle database?

1033

Where is the export dump file located?

1141

What is catalog in Oracle?

1359

Why do we use bulk collect in oracle?

1058

How would you change old and new values in an insert, delete and update triggers?

1018

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