Answer Posted / eshwer

create trigger on emp table with last_transaction with datatype as date or timestamp,

now you have to use dml commands on emp table, when ever u done any modifications on the table these will be inserted in
last_transaction with sysdate with last modification time,

based on time we can find out the last transactions

based on

Explain foreign key in sql?

968

---

which tcp/ip port does sql server run on? : Sql dba

962

---

How many types of indexes are there in sql?

932

---

What is gpt format?

894

---

What are the parts of a sql statement?

1024

---

Is sql a scripting language?

921

---

Write the alter statement to enable all the triggers on the t.students table.

1066

---

Is sql injection illegal?

963

---

How can I change database name in sql?

1000

---

How can I tell if sql is running?

990

---

Can there be more than one function with a similar name in a pl/sql block?

922

---

Give the order of sql select?

1082

---

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

925

---

What is trigger point?

947

---

Why should I use postgresql?

966

---