What is the difference between TRUNCATE and DELETE commands?
Question :
What is the difference between TRUNCATE and DELETE commands?
TRUNCATE is a DDL command whereas DELETE is a DML command. Hence DELETE operation can be rolled back, but TRUNCATE operation cannot be rolled back. WHERE clause can be used with DELETE and not with TRUNCATE.
Similar Questions
What is Django's middleware and how is it used?
- What are comments? Name the different types of comments used in Java.
- What are syntax errors? Give two examples.
- What are the different type of errors that may occur in a Java program?
- What is a bug? What is debugging?
- What is an accumulator?
- What is an expression?
- What is an operator? How is the classification of operators based upon?
- What is Type Conversion? Name the two type conversions in Java.
- What are separators?
- How are Decimal, Octal and Hexadecimal integer literals represented in Java?
- State two conventions you should follow while naming a class.
- What two conventions you should follow naming a class?
- State two rules you should follow for naming a class
- Why is a class called an object factory?
- What is an access specifier? Which two access specifier is used in a class declaration?
- Why is a class called a user defined data type?
- State two differences between a class and an object.
- State two differences between fundamental and user-defined data type.
- Explain the statement “Byte code is the object code for the JVMâ€