Answer Posted / sandeep chawdekar

there are mainily 3 types of triggers
1> dml trigger
2>instead of trigger written on only view
3>system trigger

dml trigger written on table that gets fired on dml events
like
insert or delete or update operation
that trigger may fire
1>after dml event
2> before dml event these are timings for trigger firing

instead of trigger written only on view that view is not
modifiable that also gets fired
when dml event occurs

system trigger gets fired on system event like
before log off or after log on or before shutdown
this trigger may be written on
database level
schema level

Do we need to rebuild index after truncate?

1154

---

What is your daily office routine?

2353

---

what is collation? : Sql dba

1242

---

what are aggregate and scalar functions? : Sql dba

1142

---

Can we use distinct and group by together?

1147

---

what is dbms? : Sql dba

1070

---

what are the advantages of sql ? : Sql dba

1154

---

What is the current version of sql?

1106

---

define sql insert statement ? : Sql dba

1110

---

how many tables will create when we create table, what are they? : Sql dba

1156

---

Does group by remove duplicates?

1120

---

How do I remove duplicates in two columns?

1202

---

Can we rollback truncate?

1083

---

If a cursor is open, how can we find in a pl/sql block?

1252

---

what is schema? : Sql dba

1163

---