Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2026 Crash Course
NEET 2026 Crash Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
125 views
in Computer by (51.9k points)
closed by

Differentiate between the following statements:

i) ALTER and UPDATE
ii) DELETE and DROP

1 Answer

+1 vote
by (49.6k points)
selected by
 
Best answer

i) ALTER - ALTER statement is used to add/remove an attribute or to modify the datatype of an existing attribute or to add constraint in attribute.

UPDATE - It is used to make changes in the value(s) of one or more columns of existing records in a table. For example, we may require some changes in address, phone number or spelling of name, etc.

ii) DELETE - DELETE statement is used to delete/remove one or more records from a table.

DROP - We use a DROP statement to remove a database or a table permanently from the system. However, one should be very cautious while using this statement as it cannot be undone.

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...