Answer / brijesh kumar

Index is used for fast retrival data from a table. There are
two types of index
1.clustered Index
2.Non-clustered Index
1. clustered index is created on primary key and it can be
only on per table
2.Non-clustered Index can be created any column and it can
be more than one in a table

Composite key:- Composite is the combination of more than
one attribute composite key is created when it is not
possible to identify any column in a table that has unique
value in such
a situation combination of more than column is chosen by
which
record can be identify easly clear it is just like primary
key.

How can we check the sql server version?

0 Answers  

---

What happens if the update subquery returns multiple rows in ms sql server?

0 Answers  

---

Why I am getting this error when renaming a database in ms sql server?

0 Answers  

---

What will be query used to get the list of triggers in a database?

0 Answers  

---

What is difference between cte and view?

0 Answers  

---

---

What is the difference between cartesian product and cross join?

0 Answers  

---

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 Answers  

---

What are the restrictions that views have to follow?

0 Answers  

---

What is merge replication?

0 Answers  

---

Can we use trigger new in before insert?

0 Answers  

---

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

---