Answer Posted / oracle_tigress

difference between truncate and delete

1.truncate removes rows in one execution..delete removes
rows one by one so truncate is fast..

2.truncate does not creates logs and hence canot be
rolledback and hence is a DDL stmt..DELETE creates rollback
segment hence can be rolled back and hence is a DML stmt.

3.truncate doesnot allow for conditional remove of records
(all records has to remove) DELETE allows conditonal remove
of records(where cluase etc can be used.)

4.triggers are not fired on truncate stmt but trgieers are
fired on DELETE stmt..

Why is normalization important?

1076

---

What are local and global variables and their differences?

1134

---

What are the two virtual tables available at the time of database trigger execution?

1266

---

What is function and procedure in pl sql?

1112

---

what are the different type of normalization? : Sql dba

1063

---

What is the largest value that can be stored in a byte data field?

1054

---

how to select unique records from a table? : Sql dba

1170

---

What is the best free sql database?

1098

---

how to drop an existing view in mysql? : Sql dba

1099

---

Do ddl statements need commit?

1016

---

what are the advantages of sql ? : Sql dba

1105

---

Can pl sql procedure have a return statement?

1067

---

What does count (*) mean?

981

---

How do you explain an index number?

1180

---

Differentiate between % rowtype and type record.

1386

---