SQL Data Definition Multiple Choice Questions (MCQ) 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