Answer Posted / hannan

First, you must understand what a cluster is in Oracle.

A cluster is simply a method for storing more then 1 table
on the same block. Normally
-- a block contains data for exactly 1 table. In a cluster
-- you have data from many
tables sharing the same block.

For example -- if you join the data from EMP and DEPT by
DEPTNO frequently -- you might
consider clustering this data by DEPTNO. In that fashion
all of the rows from EMP for
deptno=10 and the row in DEPT for deptno=10 will reside on
the same exact block (one IO
to get all of the data instead of some IO's to EMP and DEPT).

In order to organize data in such an object, we create a
cluster KEY -- deptno in our
above example. We must index this cluster key. This index
on deptno in the cluster is
called a CLUSTER INDEX and is used to locate the blocks that
contain data about deptno=10

What are the security related catalog views? : sql server security

925

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

902

---

What is the maximum row of a size?

968

---

Can a function call a stored procedure in sql server?

924

---

What are the differences between clustered and non-clustered index?

968

---

what's the information that can be stored inside a bit column? : Sql server database administration

983

---

When do you think a developer should use sql server-based cursors?

990

---

What are the advantages of using a stored procedure?

959

---

What are the kinds of subquery?

967

---

What are the advantages of passing name-value pairs as parameters?

1127

---

What is the osql utility?

927

---

What is meant by Active-Passive and Active-Active clustering setup?

1095

---

What are triggers in ms sql server?

1122

---

What is the difference between osql and query analyzer?

948

---

How to see existing views in ms sql server?

1004

---