Which of the following are DDL commands?

(A) Delete

(B) Create

(C) Update

(D) Alter

(E) Drop

1. (B), (D) and (E)
2. (A), (B) and (D)
3. (B), (C) and (D)
4. (A), (B) and (C)

Identify the correct statement(s):

Statement 1 (S1): Char data type in MySQL stores fixed length strings.

Statement 2 (S2): Char data type stores string smaller than the maximum field size.

1. (S1) : Correct, (S2) : Correct
2. (S1): Incorrect, (S2) : Correct
3. (S1): Correct, (S2) : Incorrect
4. (S1) : Incorrect, (S2) : Incorrect

The SQL statements always end with …………… .

1. ,
2. :
3. ;
4. "

Shivam wants to see the table structure in MySQL. Select an appropriate command to help him.

1. Use
2. Show
3. Desc
4. Display