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;

Define data access layer?

932

---

What are all the classes that are available in System.Data Namespace?

996

---

How to store data in memory?

934

---

Can you explain how to enable and disable connection pooling?

949

---

What is data relation?

884

---

What does executequery return?

949

---

What is ole in excel?

921

---

What is connected architecture in ado.net?

1041

---

what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?

998

---

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

1015

---

Explain how to bind the controls(best practice) comboboxes to the data in the dataset?

1004

---

What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?

980

---

What connected data?

935

---

What is disconnected scenario in entity framework?

1092

---

What are the ado.net components?

1008

---