SQL Data Definition Multiple Choice Questions with Answers – PDF Download

MCQ 1: The command that is used to add attributes to an existing relation, is said to be:

1. Alter
2. Modify
3. Tailor
4. Eliminate

MCQ 2: The term that allows specification of not only a set of relations, but also information about each relation, is known as:

1. Data manipulation language
2. Data Declaration language
3. Data Declaration language
4. Data Definition language

MCQ 3: When comparing a char type with a varchar type, one may expect extra spaces to be added to the:

1. char type
2. varchar type
3. Both A and B
4. None of the above

MCQ 4: Any tuple in the relation must correspond to values of the primary key attributes of some tuple in relation s, is said to be:

1. Unique key attribute
2. Primary key attribute
3. Candidate key attribute
4. Foreign key attribute

MCQ 5: All tuples in the relation are assigned null as the value for the new attribute, in the:

1. Tailor command
2. Eliminate command
3. Alter command
4. Modify command