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 provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

702

---

Which namespaces are used for data access?

822

---

Explain the namespaces in which .net has the data functionality class.

739

---

What is the difference between a datareader and a dataset?

687

---

What are all the different authentication techniques used to connect to MS SQL Server?

727

---

---

What are typed and untyped dataset?

742

---

Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

722

---

If a table contains 20000 records. In a page at each time 100 records to be displayed.

685

---

What is sql command in ado net?

682

---

What is ole access?

697

---

Can we load multiple tables in a dataset?

761

---

What you mean by filtering of data?

699

---

What are good ado.net object to replace to ado recordset object.

748

---

What is difference between dataset and datatable?

736

---

What are the main differences between classic ado and ado.net?

717

---