Answer Posted / hiral bhatt

No, its not possible to hving Primary key with Non Clusterd
Index, because whenever we have to make a column as Primary
Key, it will create a Clusterd Index on that Column
automatically, it is due to the concept of paging, thats
why we can have only 1 primay key and 1 clusterd index per
Table...Enjoy :-)

What is normalization? Explain different forms of normalization?

1160

---

What are the system database in sql server 2005?

1044

---

Why do you need a sql server?

1109

---

What is a covering index?

984

---

What is postgresql server?

1001

---

How to select some specific columns from a table in a query in ms sql server?

1005

---

How much does sql server 2016 cost?

1072

---

explain the storage models of olap? : Sql server database administration

959

---

Explain stored procedure?

1053

---

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

954

---

Can two tables share the same primary key?

917

---

how can you attach more than 20 ldf files in sql server

2001

---

What is self contained scalar sub query?

974

---

Mention the command used to rename the database.

1006

---

What security features are available for stored procedure?

1036

---