CH5

Question 1

Data Definition Language (DDL)

Answer 1

• Create
• Alter
• Drop

Question 2

Data Manipulation Language (DML)

Answer 2

• Insert
• Update
• Delete
• Select
• Into

Question 3

LIKE ‘ %a ‘ ;

Answer 3

Any value that ends with ‘a’

Question 4

WHERE AND HAVING

Answer 4

The difference between the having and where clause in SQL is that the where clause cannot be used with aggregates, but the having clause can

Question 5

IN

Answer 5

Used for comparison of a value with a set of values