Answer Posted / devendra sharma

Yes it is possible that a primary key can be non clustered

create table abc(eid int PRIMARY KEY
NONCLUSTERED,ename varchar(50),vid int)

create clustered index abc_clustered on abc (vid)


now if you will check the index on eid cloumne it will be
unique and vid will have a clustered index.

Give it a try if you don't belive......

what are database files and filegroups? : Sql server database administration

936

---

What are the benefits of normalization?

1100

---

What happens when transaction log is full?

923

---

What is replace and stuff function in sql server?

1055

---

What is query optimization process?

1001

---

What are examples of triggers?

1074

---

what is a self join? : Sql server database administration

1024

---

How to insert multiple rows with a subquery?

1121

---

What is forward - only cursors / read only cursor?

1080

---

What is microsoft sql server?

961

---

Tell me extended events in sql server 2008?

988

---

Does group by or order by come first?

950

---

Explain various data region available in ssrs with their use?

921

---

How to delete database objects with "drop" statements in ms sql server?

1076

---

What area unit the various kinds of info compression introduced in sql server 2008?

1071

---