Answer Posted / kinthada cnu

hi all

Trigger nothing but special kind of stored procedure
it's providing security to table data.And it is automatically
fire when the queary excuted.

ex:
create trigger <trigger name>
on <table name>
for <insert/update/delete>
as
begin
<statments>
end

What is the order in which the sql query is executed?

942

---

What are sp_configure commands and set commands?

1024

---

what is the primary use of the model database? : Sql server administration

1050

---

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1206

---

Can you type more than one query in the query editor screen at the same time?

1011

---

How do I find the port number for sql server?

971

---

What is forward - only cursors / read only cursor?

1091

---

How can we get count of the number of records in a table?

954

---

What is transact-sql ddl trigger?

1107

---

Explain go command in sql server?

1040

---

What happens if null values are involved in bitwise operations?

1029

---

Explain different types of Normalization.

1835

---

What are the components of dbms?

954

---

Explain trigger and trigger types?

987

---

Mention the different authentication modes in sql server.

1057

---