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 4611

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

1 4510

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

1 4016

What is RULE-based approach to optimization ?

1 5393

What is COST-based approach to optimization ?

5 9023

How do you rate yourself in oracle and sql server ?

Keane India Ltd,

2 8592

What is E-R diagram ?

CGI, Keane India Ltd,

2 12578

Draw E-R diagram for many to many relationship ?

Keane India Ltd,

3670

Design database draw er diagram for a certain scenario ?

Keane India Ltd, TATA,

4626

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 212450

What is Normalization ?

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

55 89599

Difference between sub query and nested query ?

Keane India Ltd, TCS,

19 69057

Indexes in oracle ?

Keane India Ltd, L&T,

3 10650

Query to retrieve record for a many to many relationship ?

Keane India Ltd,

2576

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

CTS, Keane India Ltd, TCS, Wipro,

34 66467

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is an oracle database table?

1062

How to run create database statement again?

1218

How to do clean up if create database failed?

1067

What are the various types of snapshots ?

1082

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2204

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1165

How to see the table columns used in an index?

1070

What is a user role in oracle?

1183

Explain oracle instance.

1233

What is Undo Management Advisor in Oracle?

1151

how can we store any pdf file in oracle

2220

What is a lookup table in oracle?

1024

What are the limitations oracle database 10g xe?

1093

How can I combine multiple rows into a comma-delimited list in oracle?

1116

What are dml statements in oracle?

1130

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