Answer Posted / c.jagadish

In sqlserver we have two types of indexes (1) Clustered (2)
non clustered indexes.

Indexes may be simple index or composite index.

Index formed based on single column values is called simple
index

index formed based on multiple column values is called
composite index.

Default index is NON CLUSTERED INDEX

When a table contains a primary key column then sqlserver
automatically creates a unique clustered index.

Unique--- automatically creates a non clustered index

so for this reason PRIMARY KEY IS NOT EQUAL TO UNIQUE + NOT
NULL.

how would you troubleshoot blocking? : Sql server database administration

1025

---

What is temporal table?

934

---

Explain what are the authentication modes in sql server?

1069

---

What is an sql server agent?

1111

---

What is the difference between delete and truncate statements?

1127

---

What is the difference between Triggers and Stored Procedure?

1151

---

Which table keeps information about stored procedures?

982

---

What are indexers?

1131

---

Do you know what is rank function?

1124

---

Explain the commands in sql server?

1095

---

Explain the difference between delete,drop and truncate in SQL Server?

1159

---

What is server-level principal?

122

---

How to provide values to user defined function parameters?

1058

---

State the difference between union and union all?

985

---

How to use old values to define new values in update statements in ms sql server?

1330

---