Answer Posted / shivaleela

DELETE:-

1.it is a DML stmt
2.it can include WHERE condition
3.it is only delete, so it can be rolled back can be ROLL
BACK

TRUNCATE:-

1.it is a DDL stmt
2.it can not include WHERE cnd
3.it is delete+commit ,so we cant roll back can not be ROLL
BACK


Both commands accomplish identical tasks (removing all data
from a table), but TRUNCATE is much faster

Reason:When you type DELETE.all the data get copied into
the Rollback Tablespace first.then delete operation get
performed.Thatswhy when you type ROLLBACK after deleting a
table ,you can get back the data(The system get it for you
from the Rollback Tablespace).All this process take
time.But when you type TRUNCATE,it removes data directly
without copying it into the Rollback Tablespace.Thatswhy
TRUNCATE is faster.Once you Truncate you cann't get back
the data.

Give the syntax of exception handling used in DBMS?

1236

---

What are different types of blocks used in stored procedure?

1172

---

Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.

1944

---

What is the Lock Based Protocol used for?

1135

---

How to do Stored procedure testing? Who does this testing (Developer or tester)?

1875

---

What are different types of clusters present?

1112

---

If the master device is full, how do I make the master database bigger?

1062

---

i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name

2137

---

What is replicaset?

1062

---

What is the DIF format and when we will use in teradata

2537

---

What is Data Modelling?

1125

---

Explain storage manager?

1098

---

Explain database partitioning.

1124

---

What is database schema name?

1100

---

how to configure oracle 10g in java1.5 and tell me know how to set class path in system?

2079

---