What are the steps for performance tuning.

0 Answers  

---

What is a record in pl/sql?

0 Answers  

---

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

---

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

---

What is the difference between rename and alias?

0 Answers  

---

What is a database? Explain

0 Answers  

---

What is the mutating table and constraining table?

0 Answers  

---

Explain uses of cursor.

1 Answers  

---

What is the fastest way of accessing a row in a table?

5 Answers   TCS,

---

What is pivot table in sql?

0 Answers  

---

What is primary key and unique key?

0 Answers  

---

How many types of index are there?

0 Answers  

---