Answer / s

primary key, foreign key, Joins are often performed on
primary and foreign key columns. columns frequently coded
in the WHERE clause, ORDER BY, GROUP BY, DISTINCT, columns
which are searched or joined over less than 5-10% of the
rows.

What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  

---

what are the SQL codes u freequently got?

2 Answers   Logica CMG,

---

How to know the primary key of a table without defining the primary key in the table?

5 Answers   Satyam,

---

Explain the use of the WHERE clause.

2 Answers   IBM,

---

What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,

---

why we go for SPUFI for creating tables or for sql queries?

4 Answers  

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---

How would the varchar column remarks defined?

0 Answers  

---

What is netezza database?

0 Answers  

---

What is a buffer pool?

2 Answers  

---

What is the difference between drop table and delete table?

0 Answers  

---

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

0 Answers  

---