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 is raid and what are different types of raid levels?

775

---

How to fine-tune reports?

211

---

How do I determine how many instances of sql server are installed on a computer?

714

---

What is the difference between grant and with grant while giving permissions to the user?

726

---

What is the difference between set and select?

739

---

---

What is the syntax to execute the sys.dm_db_missing_index_details?

741

---

What is the difference between the application object and session object?

799

---

What is an execution plan?

738

---

Explain isolation levels that sql server supports?

761

---

What are the built in functions in sql server?

655

---

Write an sql query to find first weekday of the month?

662

---

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

744

---

What do you understand by hotfixes and patches in sql server?

689

---

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

748

---

How do you handle datasets larger than 50 gb?

154

---