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 service broker?

768

---

We need to perform what steps in the following order to work with a cursor?

918

---

What is the difference between dropping a database and taking a database offline?

911

---

Explain the cursor lock types?

748

---

Sql server reporting services vs. Crystal reports.

112

---

What are subqueries in sql server?

800

---

What is clr ddl trigger?

733

---

Where cross join is used?

693

---

How to find Duplicate Records In table?

763

---

what is a self join? : Sql server database administration

701

---

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5696

---

How to convert a unicode strings to non-unicode strings?

750

---

What are cursors and when they are useful?

754

---

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

790

---

Explain what is the difference between a local and a global temporary table?

716

---