Computer Science Engineering (CSE) Exam  >  Computer Science Engineering (CSE) Questions  >  Properties of ‘DELETE’ and &lsquo... Start Learning for Free
Properties of ‘DELETE’ and ‘TRUNCATE’ commands indicate that
  • a)
    After the execution of ‘TRUNCATE’ operation, COMMIT, and ROLLBACK statements can be performed to retrieve the lost data, while ‘DELETE’ does not allow it.
  • b)
    After the execution of ‘DELETE’ and ‘TRUNCATE’ operation retrieval is easily possible for the lost data
  • c)
    After the execution of ‘DELETE’ operation, COMMIT and ROLLBACK statements can be performed to retrieve the lost data., while TRUNCATE do not allow it
  • d)
    After the execution of ‘DELETE’ and ‘TRUNCATE’ operation no retrieval is possible for the lost data
Correct answer is option 'C'. Can you explain this answer?
Most Upvoted Answer
Properties of ‘DELETE’ and ‘TRUNCATE’ commands...
TRUNCATE
  • Is a DDL command hence it cannot be rolled back.
  • It resets the identity of the table and locks that state of the table.
  • Hence, Commit and Rollback will have no effect after TRUNCATE.
     
DELETE
  • Is a DML command hence it can be rolled back
  • It does not rest the identity of the table, it just locks the table row
  • Hence Commit and Rollback can have effect depending on the lock techniques used.
Hence, it can be said that after the execution of ‘TRUNCATE’ operation, COMMIT, and ROLLBACK statements cannot be performed to retrieve the lost data, while ‘DELETE’ allows it.
It can also be said that after the execution of ‘DELETE’ operation, COMMIT and ROLLBACK statements can be performed to retrieve the lost data, while TRUNCATE does not allow it
NOTE
In official ISRO CS 2020, both option 1 and 3 were correct and hence option is slightly modified to get only correct answer.
Explore Courses for Computer Science Engineering (CSE) exam

Similar Computer Science Engineering (CSE) Doubts

Top Courses for Computer Science Engineering (CSE)

Properties of ‘DELETE’ and ‘TRUNCATE’ commands indicate thata)After the execution of ‘TRUNCATE’ operation, COMMIT, and ROLLBACK statements can be performed to retrieve the lost data, while ‘DELETE’ does not allow it.b)After the execution of ‘DELETE’ and ‘TRUNCATE’ operation retrieval is easily possible for the lost datac)After the execution of ‘DELETE’ operation, COMMIT and ROLLBACK statements can be performed to retrieve the lost data., while TRUNCATE do not allow itd)After the execution of ‘DELETE’ and ‘TRUNCATE’ operation no retrieval is possible for the lost dataCorrect answer is option 'C'. Can you explain this answer?
Question Description
Properties of ‘DELETE’ and ‘TRUNCATE’ commands indicate thata)After the execution of ‘TRUNCATE’ operation, COMMIT, and ROLLBACK statements can be performed to retrieve the lost data, while ‘DELETE’ does not allow it.b)After the execution of ‘DELETE’ and ‘TRUNCATE’ operation retrieval is easily possible for the lost datac)After the execution of ‘DELETE’ operation, COMMIT and ROLLBACK statements can be performed to retrieve the lost data., while TRUNCATE do not allow itd)After the execution of ‘DELETE’ and ‘TRUNCATE’ operation no retrieval is possible for the lost dataCorrect answer is option 'C'. Can you explain this answer? for Computer Science Engineering (CSE) 2024 is part of Computer Science Engineering (CSE) preparation. The Question and answers have been prepared according to the Computer Science Engineering (CSE) exam syllabus. Information about Properties of ‘DELETE’ and ‘TRUNCATE’ commands indicate thata)After the execution of ‘TRUNCATE’ operation, COMMIT, and ROLLBACK statements can be performed to retrieve the lost data, while ‘DELETE’ does not allow it.b)After the execution of ‘DELETE’ and ‘TRUNCATE’ operation retrieval is easily possible for the lost datac)After the execution of ‘DELETE’ operation, COMMIT and ROLLBACK statements can be performed to retrieve the lost data., while TRUNCATE do not allow itd)After the execution of ‘DELETE’ and ‘TRUNCATE’ operation no retrieval is possible for the lost dataCorrect answer is option 'C'. Can you explain this answer? covers all topics & solutions for Computer Science Engineering (CSE) 2024 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for Properties of ‘DELETE’ and ‘TRUNCATE’ commands indicate thata)After the execution of ‘TRUNCATE’ operation, COMMIT, and ROLLBACK statements can be performed to retrieve the lost data, while ‘DELETE’ does not allow it.b)After the execution of ‘DELETE’ and ‘TRUNCATE’ operation retrieval is easily possible for the lost datac)After the execution of ‘DELETE’ operation, COMMIT and ROLLBACK statements can be performed to retrieve the lost data., while TRUNCATE do not allow itd)After the execution of ‘DELETE’ and ‘TRUNCATE’ operation no retrieval is possible for the lost dataCorrect answer is option 'C'. Can you explain this answer?.
Solutions for Properties of ‘DELETE’ and ‘TRUNCATE’ commands indicate thata)After the execution of ‘TRUNCATE’ operation, COMMIT, and ROLLBACK statements can be performed to retrieve the lost data, while ‘DELETE’ does not allow it.b)After the execution of ‘DELETE’ and ‘TRUNCATE’ operation retrieval is easily possible for the lost datac)After the execution of ‘DELETE’ operation, COMMIT and ROLLBACK statements can be performed to retrieve the lost data., while TRUNCATE do not allow itd)After the execution of ‘DELETE’ and ‘TRUNCATE’ operation no retrieval is possible for the lost dataCorrect answer is option 'C'. Can you explain this answer? in English & in Hindi are available as part of our courses for Computer Science Engineering (CSE). Download more important topics, notes, lectures and mock test series for Computer Science Engineering (CSE) Exam by signing up for free.
Here you can find the meaning of Properties of ‘DELETE’ and ‘TRUNCATE’ commands indicate thata)After the execution of ‘TRUNCATE’ operation, COMMIT, and ROLLBACK statements can be performed to retrieve the lost data, while ‘DELETE’ does not allow it.b)After the execution of ‘DELETE’ and ‘TRUNCATE’ operation retrieval is easily possible for the lost datac)After the execution of ‘DELETE’ operation, COMMIT and ROLLBACK statements can be performed to retrieve the lost data., while TRUNCATE do not allow itd)After the execution of ‘DELETE’ and ‘TRUNCATE’ operation no retrieval is possible for the lost dataCorrect answer is option 'C'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of Properties of ‘DELETE’ and ‘TRUNCATE’ commands indicate thata)After the execution of ‘TRUNCATE’ operation, COMMIT, and ROLLBACK statements can be performed to retrieve the lost data, while ‘DELETE’ does not allow it.b)After the execution of ‘DELETE’ and ‘TRUNCATE’ operation retrieval is easily possible for the lost datac)After the execution of ‘DELETE’ operation, COMMIT and ROLLBACK statements can be performed to retrieve the lost data., while TRUNCATE do not allow itd)After the execution of ‘DELETE’ and ‘TRUNCATE’ operation no retrieval is possible for the lost dataCorrect answer is option 'C'. Can you explain this answer?, a detailed solution for Properties of ‘DELETE’ and ‘TRUNCATE’ commands indicate thata)After the execution of ‘TRUNCATE’ operation, COMMIT, and ROLLBACK statements can be performed to retrieve the lost data, while ‘DELETE’ does not allow it.b)After the execution of ‘DELETE’ and ‘TRUNCATE’ operation retrieval is easily possible for the lost datac)After the execution of ‘DELETE’ operation, COMMIT and ROLLBACK statements can be performed to retrieve the lost data., while TRUNCATE do not allow itd)After the execution of ‘DELETE’ and ‘TRUNCATE’ operation no retrieval is possible for the lost dataCorrect answer is option 'C'. Can you explain this answer? has been provided alongside types of Properties of ‘DELETE’ and ‘TRUNCATE’ commands indicate thata)After the execution of ‘TRUNCATE’ operation, COMMIT, and ROLLBACK statements can be performed to retrieve the lost data, while ‘DELETE’ does not allow it.b)After the execution of ‘DELETE’ and ‘TRUNCATE’ operation retrieval is easily possible for the lost datac)After the execution of ‘DELETE’ operation, COMMIT and ROLLBACK statements can be performed to retrieve the lost data., while TRUNCATE do not allow itd)After the execution of ‘DELETE’ and ‘TRUNCATE’ operation no retrieval is possible for the lost dataCorrect answer is option 'C'. Can you explain this answer? theory, EduRev gives you an ample number of questions to practice Properties of ‘DELETE’ and ‘TRUNCATE’ commands indicate thata)After the execution of ‘TRUNCATE’ operation, COMMIT, and ROLLBACK statements can be performed to retrieve the lost data, while ‘DELETE’ does not allow it.b)After the execution of ‘DELETE’ and ‘TRUNCATE’ operation retrieval is easily possible for the lost datac)After the execution of ‘DELETE’ operation, COMMIT and ROLLBACK statements can be performed to retrieve the lost data., while TRUNCATE do not allow itd)After the execution of ‘DELETE’ and ‘TRUNCATE’ operation no retrieval is possible for the lost dataCorrect answer is option 'C'. Can you explain this answer? tests, examples and also practice Computer Science Engineering (CSE) tests.
Explore Courses for Computer Science Engineering (CSE) exam

Top Courses for Computer Science Engineering (CSE)

Explore Courses
Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
10M+ students study on EduRev