Answer / pawan

Clustered indexes can be created to order the rows in the
table in the same physical order as the desired result
set.Clustered indexes allow for a more linear access
pattern to data pages and more effective prefetching, and
help avoid sorts.Only one cluster index can be created on
table.

Answer / s

Clustering Index is an index defined with the CLUSTER
keyword and determines where the row should be inserted to
maintain the clustering sequene

wht are the restrictions for union ?

2 Answers   CTS,

---

what is the difference between declaring the cursor in WS section and Procedure division?

1 Answers   HCL,

---

Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

3 Answers  

---

What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,

---

What is difference between rollback and commit?

0 Answers  

---

Are views updateable?

0 Answers  

---

what is consistency token

3 Answers  

---

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

0 Answers  

---

Which command is used to remove all rows from a table?

0 Answers  

---

explain about index with examples

2 Answers   Syntel,

---

Explain the contention situations caused by locks?

0 Answers  

---

What is the physical storage length of the data types date, time, and timestamp?

0 Answers  

---