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

How many functions are there in sql?

1027

---

give the syntax of grant and revoke commands? : Sql dba

1153

---

Can we use update in sql function?

1064

---

what is 'mysqldump'? : Sql dba

1109

---

How do I start pl sql?

949

---

what is a composite key ? : Sql dba

1062

---

what are all the different types of indexes? : Sql dba

1048

---

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1072

---

Can we create table in function?

965

---

Can %notfound return null after a fetch?

1060

---

What is sql lookup?

920

---

Can we call stored procedure in function?

959

---

How can you fetch first 5 characters of the string?

1018

---

Is primary key an index?

991

---

How to look at the current sql*plus system settings?

1149

---