Answer Posted / kumar srinivasalu

BY USING HINTS,
HASH JOINS,
PARTITION TABLES AND INDEXS,
RESERVE KEY INDEX,
BIT MAP INDEX,
COST BASED OPTIMIZATION,
Nested loops,full table scans,query rewrite with
materialisation views
BASED ON THIS WE OPTIMIZE THE SQL QUERIES.

What is java sql connection?

1063

---

Explain how exception handling is done in advance pl/sql?

999

---

What is bind reference and how can it be created?

1021

---

What pl/sql package consists of?

1088

---

what are the differences among rownum, rank and dense_rank? : Sql dba

1040

---

what does the t-sql command ident_incr does? : Transact sql

1081

---

how to calculate expressions with sql statements? : Sql dba

1037

---

Explain unique key in sql.

1017

---

Is pl sql useful?

997

---

Does sql backup shrink transaction log?

983

---

How subquery works in sql?

1074

---

Define concurrency control. : Transact sql

1193

---

Write a sql query to find the names of employees that begin with ‘a’?

1016

---

When to use inner join and left join?

961

---

Is inner join same as self join?

1120

---