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 oledb driver?

491

---

Is bulk insert faster than insert?

491

---

What is the difference in an abstract class and an interface?

511

---

How to retrieve the user id which is provided while windows authentication?

588

---

What are the advantages of ado.net?

509

---

---

How we can provide data to ado.net?

545

---

List all the steps in order, to access a database through ado.net?

583

---

What is an orm, and why would you use one instead of plain old ado.net?

572

---

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

526

---

What is ado oledb and odbc?

503

---

What is openrowset?

494

---

What is ado.net tutorial?

503

---

Define bubbled event?

512

---

Which is faster dataset or datareader?

522

---

How would you connect to a database by using .NET?

475

---