Call Support +91-85588-96644
TCY online

Login

Sign Up

Please enter a Username or Email ID
Please enter a password
Keep me logged in
Please enter your name
Please enter your mobile number
You can't leave Captcha Code empty
By submitting this form, you agree to the Terms & Privacy Policy.
OR

Sign Up via Facebook

Sign Up via Google

Sign Up via Twitter

Download Software
Tests given

Download TCY App

OR
App Image
Discussion

Official Java/Oracle /C/C++ Preparation for Information Technology

Posted on 18 Jan, 2016 6:24 PM

Which command is used to remove rows from a table?

 
DELETE
REMOVE
TRUNCATE
BOTH a & b

Reply


Please type your answer before submitting.
Submit

Truncated

Sanjeev

Delete and Truncate are the right answers but they are not specified. There is a difference between delete and truncate. While deleting rows, holes will be created and if changes are not committed, by doing rollback, we can get the data back. It is a data manipulation language (DML) statement. Whereas Truncate is Data definition language (DDL) and we cannot get data back

Both 1 and 3 are the answers, which is not mentioned in the options.