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 is the server name in sql server?

1072

---

explain declarative management framework (dmf) in sql server 2008?

1044

---

how to create a scrollable cursor with the scroll option? : Sql server database administration

1147

---

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1156

---

How to get a list of all tables with "sys.tables" view in ms sql server?

1088

---

Difference between LEN() and DATALENGTH() in sql server ?

1175

---

What is the distinction amongst delete and truncate?

1119

---

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1186

---

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

976

---

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4467

---

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

1027

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1056

---

How do I run sql server 2014?

1059

---

What is normalization? Explain different forms of normalization?

1235

---

Explain having clause and where clause?

1101

---