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 4615

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

1 4515

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

1 4018

What is RULE-based approach to optimization ?

1 5402

What is COST-based approach to optimization ?

5 9046

How do you rate yourself in oracle and sql server ?

Keane India Ltd,

2 8596

What is E-R diagram ?

CGI, Keane India Ltd,

2 12586

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,

4633

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 212520

What is Normalization ?

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

55 89655

Difference between sub query and nested query ?

Keane India Ltd, TCS,

19 69080

Indexes in oracle ?

Keane India Ltd, L&T,

3 10661

Query to retrieve record for a many to many relationship ?

Keane India Ltd,

2581

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

CTS, Keane India Ltd, TCS, Wipro,

34 66570

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Please explain oracle left join with an example?

1095

Explain the use of tables option in exp command.

1172

Is it possible to split the print reviewer into more than one region ?

2345

What are joins, explain all types of joins?

2366

What happens if variable names collide with table/column names?

1269

How to define a data field as not null?

1163

How do you find current date and time in oracle?

1105

How can we find out the duplicate values in an oracle table?

1125

What is system global area (sga) in oracle?

1039

Explain the use of analyse option in exp command.

1200

What is data file?

1155

How to delete a column in an existing table?

1132

What are the most common interview questions on ETL Testing for experience?

1194

What is the quickest way to export a table to a flat file?

1017

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

2360

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