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 meaning of object pooling?

1235

---

Why is ADO.NET serialization slower than ADO ?

1053

---

What is a dynaset in access?

1063

---

What is disconnected scenario in entity framework?

1115

---

What is the meaning of executenonquery?

1066

---

What are the namespaces used in ADO.Net to connect to a database?

1213

---

How to check if a datareader is closed or opened? IsClosed()

1029

---

Explain the difference between an ado.net dataset and an ado recordset?

1061

---

How to work with disconnected data - the dataset and sqldataadapter?

987

---

What is difference between datagridview and datagrid control in winforms?

1030

---

What is DataRowCollection?

1107

---

how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?

1015

---

Define data adapter?

958

---

What is the difference between ado.net and entity framework?

1049

---

Which parameter of ConnectionString is used to specify the name of the database?

1061

---