+91-85588-96644
TCYonline

Login

Sign Up

Please enter a Username or Email ID
Please enter a password
Keep me logged in
Login with OTP
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

App Image

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.