Answer Posted / mohammadali.info

*The DELETE command is used to remove rows from a table. A WHERE clause can be used to only remove some rows. If no WHERE condition is specified, all rows will be removed. After performing a DELETE operation you need to
COMMIT or ROLLBACK the transaction to make the change permanent or to undo it.

*TRUNCATE removes all rows from a table. The operation cannot be rolled back. As such, TRUCATE is faster and doesn't use as much undo space as a DELETE.

*The DROP command removes a table from the database. All the tables' rows,
indexes and privileges will also be removed. The operation cannot be rolled back.

*DROP and TRUNCATE are DDL commands, whereas DELETE is a DML command. Therefore DELETE operations can be rolled back (undone), while DROP and TRUNCATE operations cannot be rolled back.

IF Answer is Correct Pls give Rate

1 01 101 01010

1556

---

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

590

---

What are the two modes of authentication in sql server?

514

---

What are the types of indexing?

590

---

What is shrink log file?

504

---

---

Is it possible to replicate data from sql server to oracle? : sql server replication

538

---

What are binary string data types in ms sql server?

646

---

Tell me about pre-defined functions of sql?

687

---

How to get a list of columns in a view using the "sp_help" stored procedure?

561

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

670

---

What is the difference between DataRow.Delete() and DataRow.Remove()?

714

---

How to create a stored procedure with a statement block in ms sql server?

568

---

How to get a list of columns using the "sys.columns" view in ms sql server?

551

---

What is Command line parameters in PLSQL.?

576

---

How can you manage sql azure security?

85

---