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

After removing a table from database, what other related objects have to be dropped explicitly?

1050

---

What is the default value of an integer data type in sql server 2005?

949

---

How to list all user defined functions in the current database?

1039

---

What is BCP? When does it used in sql server 2012?

1056

---

What does Master database contains?

1132

---

Explain what are the database objects? : SQL Server Architecture

1073

---

What are the differences between char and varchar in ms sql server?

1060

---

Why can there be only one clustered index and not more than one?

1001

---

What is difference between clustered and non clustered index?

982

---

What are wait types?

1104

---

What is faster join or union?

1200

---

How will you make an attribute not process? : sql server analysis services, ssas

1084

---

What is federation member?

116

---

What is role playing dimension with two examples? : sql server analysis services, ssas

1000

---

Why we use trigger in sql server with example?

956

---