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;

Do you use stored procedure in ado.net?

546

---

Explain the architecture of ado.net?

541

---

What do you know about ado.net's objects?

499

---

How to creating a SqlCommand Object?

593

---

What does datareader object do?

539

---

---

What is a non query?

518

---

What is ole in vb?

510

---

What is ado or jdbc?

516

---

Explain how can we load multiple tables in to dataset?

500

---

Which method is used by command class to execute SQL statements that return single value?

555

---

What do you mean by performing asynchronous operation using command object?

510

---

What is difference between datatable and dataset?

526

---

What are the classes in System.Data.Common Namespace?

709

---

How to enable and disable connection pooling?

511

---

What are all components of ADO.Net data provider?

609

---