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

How to locate and take substrings with charindex() and substring() functions?

1016

---

What is page in sql server?

947

---

What are the differences between having and where clause.

966

---

What is the sql case statement used for?

1098

---

What is the command dbcc checkdb used for?

1010

---

What are the purposes and advantages stored procedure?

959

---

Explain SSRS Architecture?

195

---

What is a fan-out query in SQL Azure?

121

---

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

946

---

What are page splits? : SQL Server Architecture

989

---

what are constraints? Explain different types of constraints? : Sql server database administration

984

---

What are various aggregate functions that are available?

982

---

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

958

---

Differentiate between sql temp table vs table variable?

881

---

What is an example of a foreign key?

975

---