…………… command helps to see the structure of a table/relation.

1. Show
2. Select
3. Describe
4. Order by

Which of the following types of table constraints will prevent the entry of duplicate rows?

1. Unique
2. Distinct
3. Primary Key
4. NULL

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