Week 8 - SQL Part 2

Question 1

What does the ALTER command do in SQL?

Answer 1

The ALTER command makes changes to a table structure by adding, modifying, or dropping a column.

Question 2

What does the UPDATE command do in SQL?

Answer 2

The UPDATE command updates only data in existing rows

Question 3

What is the date structure in SQL?

Answer 3

The date structure in SQL is:

‘yyyy-mm-dd’

e.g. 8 July 2004 would be

‘2004-07-08’