Answer Posted / prakash

Cluster index :-

1) CLUSTERED INDEX IS PHYSICALLY STORED THE DATA.

2)ONE TABLE CAN HAVE ONLY ONE CLUSTERED INDEX
BECAUSE IT STORED IN ORDER OF THE CLUSTERED KEY.

3)CREATING A CLUSTERED INDEX ON A TABLE RE-ARRANGES
THE DATA IN A SEQUENTIAL MANNER

4)ONCE WE DEFINED A COLUMN WITH PRIMARY KEY CONSTRAINT, SQL
SERVER AUTOMATICALLY CREATES UNIQUE CLUSTERED INDEX ON THAT
COLUMN




5) THE LEAF LEVEL OF A CLUSTERED INDEX IS THE ACTUAL
DATA


__________________________________________________________
NON-CLUSTERED INDEX:-

1)NON- CLUSTERED INDEX IS LOGICALLY STORED DATA.

2) ONE TABLE CAN HAVE 249 NON- CLUTTERED INDEX IN SERVER-2005
AND 999 IN SERVER-2008

3)NON-CLUSTERED INDEX IS CREATED ON A TABLE, THE DATA IS NOT
PHYSICALLY
RE-ARRANGED IN SEQUENTIAL ORDER.


4)ONCE WE DEFINED A COLUMN WITH UNIQUE KEY CONSTRAIN , SQL
SERVER AUTOMATICALLY CREATE NON CLUSTERED INDEX.

5) NON-CLUSTERED INDEX THE LEAF LEVEL IS
ACTUALLY A POINTER TO THE DATA IN ROWS

What is entity data services?

591

---

What is the difference between a "where" clause and a "having" clause?

625

---

Do you know the capabilities of cursors?

543

---

Explain can SSRS reports Cache results?

112

---

Do you know what are acid properties?

582

---

---

Does windows server 2016 come with sql server?

511

---

What are scalar functions in sql?

619

---

How to enter binary string literals in ms sql server?

596

---

What is the function of sql server agent windows service?

547

---

can you instantiate a com object by using t-sql? : Sql server database administration

529

---

How to create a trigger for insert only?

611

---

When multiple after triggers are attached to sql table, how to control the order of execution?

538

---

What is shared lock?

503

---

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

624

---

What is transaction server distributed transaction?

572

---