Which of the following is not correct for DELETE and TRUNCATE?

Options
- DELETE table can be rolled back
- TRUNCATE table cannot have triggers
- TRUNCATE table can have criteria
- DELETE table can have criteria


CORRECT ANSWER : TRUNCATE table can have criteria

Discussion Board
get certifide

its looking cool..........

legesse 03-26-2015 02:18 AM

Answer

By using Truncate Command you can delete all field values from the table but not a table i.e) Just a table with field names

sindhu 11-5-2014 05:22 AM

TRUNCATE command

What is the use of TRUNCATE command?

Saurabh Bajaj 07-27-2014 10:05 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement