Answer Posted / seema

Clustered Index :-
1.There can be only one Clustered index for a table
2.usually made on the primary key
3.the logical order of the index matches the physical stored
order of the rows on disk

Non-Clustered Index
1.There can be only 249 Clustered index for a table
2.usually made on the any key
3.the logical order of the index does not match the physical
stored order of the rows on disk

what is the system function to get the current user's user id? : Sql server database administration

1030

---

Describe different Processing Modes offered by SSRS?

251

---

Explain SSRS Architecture?

199

---

What is a unique index?

938

---

Write a program using SQL queries to find a unique entry in a table.

1000

---

Define clusters?

1089

---

How many ways to create table-valued functions?

999

---

What are the types of normalization?

1032

---

How can we delete Duplicate row in table?

1070

---

How you can change a cross join into an inner join?

979

---

You want to implement the one-to-one relationship while designing tables. How would you do it?

970

---

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

995

---

How can we rewrite sub-queries into simple select statements or with joins?

984

---

Does a server store data?

929

---

In what version of sql server were synonyms released?

946

---