Answer / anil kumar abbireddy

1.Cost based Optimization (CBO)
2.Rule Based Optimization (RBO)

Answer / sohail

Two types of optimization.
1.logical optimization
2.physical optimization.

Answer / sanket mishra

local optimization
global optimization

with respect to intermidiate code optimizer in Compiler

Answer / parameswara reddy.challa

logical optimization
physical optimization

Answer / rajesh

full optimization
on-page optimization
off-page optimization

Answer / esther eleonu

Amount optimum
symmetrical optimum
variant optimum

What will you get by the cursor attribute sql%notfound?

0 Answers  

Explain Connect by Prior?

2 Answers  

Can we insert in view in sql?

0 Answers  

What is t-sql? : Transact sql

0 Answers  

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,

What are the differences between Database Trigger and Integrity constraints ?

4 Answers  

Is mariadb nosql?

0 Answers  

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F

6 Answers   IBM,

What is flag in sql?

0 Answers  

Is a secondary key the same as a foreign key?

0 Answers  

how to add a new column to an existing table in mysql? : Sql dba

0 Answers  

How many parts of a pl sql block are optional?

0 Answers