Answer / vani

Instead of triggers are the procedures that execute in
place of Data Manipulation language (DML)statement on a
table.

for example, if i have INSTEAD-OF-UPDATE Trigger on
TableA,and i execute an update statement on that table,the
code in the INSTEAD-OF-TRIGGER will be executed instead of
the update statement that I executed.

Answer / s.vanitha

The INSTEAD OF triggers execute instead
of the original data modification. INSTEAD OF trigger are
allowed for both tables and views.

Answer / apparao akki

None of the above answers are correct..

The Main objective of INSTEAD OF TRIGGERS is.. To handling
the complexity of View.,i.e; to manipulating the
non-updateable views(the views that have created by many
tables with help of joins, Group by operators or set operator's)

if u need more .. contact on my mail:

apparao.akki@oracle.com

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   HCL,

---

Explain Active/Active and Active/Passive cluster configurations?

1 Answers  

---

How can I track the changes or identify the latest insert-update-delete from a table?

0 Answers  

---

Explain how many types of relationship?

0 Answers  

---

Explain about merge replications?

0 Answers  

---

What is the difference between Userdefined function and stored procedure? Explain and give the example also

5 Answers  

---

What is the difference between truncate and delete commands?

0 Answers  

---

what is victor class

0 Answers  

---

Determine when to use stored procedure to complete sql server tasks?

0 Answers  

---

How can you set the threshold at which sql server will generate keysets asynchronously?

0 Answers  

---

Why the trigger fires multiple times in single login?

0 Answers  

---

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

0 Answers  

---