Answer Posted / srividhya.s

Triggers are simply stored procedures that are executed
automatically by the database whenever
some event (usually a table update) happens.

sample:

CREATE [OR REPLACE]
TRIGGER trigger_name
BEFORE (or AFTER)
INSERT OR UPDATE [OF COLUMNS] OR DELETE
ON tablename
[FOR EACH ROW [WHEN (condition)]]
BEGIN
DBMS_OUTPUT.PUT_LINE(’Ur message to be
displayed ’ :NEW.NAME);
END;

What is the difference between sqlcommand and sqldataadapter?

942

---

What is difference between datareader and dataadapter?

993

---

Which object holds only data and does not interact with data source?

901

---

What is the difference between Response.Expires and Reponse.ExpiresAbsolute?

974

---

How to add a check box or a dropdown list to a column in a datagrid?

919

---

What is an example of ordinal data?

1044

---

What is difference between datatable and dataset?

988

---

Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?

1083

---

What are all the different methods under sqlcommand?

916

---

How many major types of connection objects in ADO.NET?

986

---

What is aggregate root?

997

---

How do you update a dataset in ado.net?

959

---

What is a serialized object?

937

---

What is ado full form?

966

---

Does ado.net use odbc?

894

---