Answer Posted / swetha

There are 2 types of triggers

Insted of trigger:
Instead Of Trigger fires an operation instead of performing
user specified operation.


After trigger: After Trigger fires an operation after any
insert,update,delete operations performed on a table.

What are data files?

981

---

What is b tree index?

856

---

What is the difference between a view and a stored procedure?

968

---

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

890

---

Can we use where clause in union?

1000

---

Explain the properties of a relational table?

975

---

How to verify a user name with sqlcmd tool?

1017

---

What is a with(nolock)?

919

---

What is extent? Types of extents?

1083

---

What is the difference between coalesce() & isnull()?

1044

---

How many types of the database links?

1020

---

Tell me in brief how sql server enhances scalability of the database system?

933

---

What are joins in sql and what are the different types of joins?

961

---

What is the default fill factor value?

1009

---

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

1964

---