Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 2592

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

1 3025

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

1 2286

What is RULE-based approach to optimization ?

1 3882

What is COST-based approach to optimization ?

5 5422

How do you rate yourself in oracle and sql server ?

Keane India Ltd,

2 5720

What is E-R diagram ?

CGI, Keane India Ltd,

2 9866

Draw E-R diagram for many to many relationship ?

Keane India Ltd,

2710

Design database draw er diagram for a certain scenario ?

Keane India Ltd, TATA,

3702


What is Normalization ?

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

55 60326

Difference between sub query and nested query ?

Keane India Ltd, TCS,

18 56753

Indexes in oracle ?

Keane India Ltd, L&T,

3 7320

Query to retrieve record for a many to many relationship ?

Keane India Ltd,

1657

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

CTS, Keane India Ltd, TCS, Wipro,

34 49250


Post New Oracle General Questions






Un-Answered Questions { Oracle General }

What is the difference between sharding and replication?

102


How to create a new table in your schema?

167


How do you find current date and time in oracle?

145


What is an oracle user account?

147


What are internal user account in oracle?

158






Can we create trigger on view in oracle?

109


What are the limitations oracle database 10g xe?

123


Please explain drop constraint oracle?

140


How to drop an index in oracle?

144


How to convert csv to table in oracle?

147


How to create a server parameter file?

131


What is Reduced List of Values?

1254


How to define a variable to match a table column data type?

146


What is hot backup and logical backup?

171


What are the restrictions on external table columns?

147