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 are the most important characteristics of pl/sql?

578

---

Does sql view stored data?

537

---

Explain the difference between triggers and constraints?

521

---

What can you do with pl sql?

567

---

How do I start sql profiler?

561

---

---

How to rename a table?

558

---

How do you write an inner join query?

517

---

What are the various levels of constraints?

666

---

What is difference between pls_integer and integer?

521

---

How to avoid duplicate records in a query?

579

---

How can you fetch first 5 characters of the string?

554

---

Explain two easy sql optimizations.

604

---

What is error ora-01000: maximum open cursors exceeded

604

---

Which software is used for pl sql programming?

523

---

How do I use google cloud in sql?

544

---