SQL Data Definition MCQ (Multiple Choice Questions) PDF Download

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

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

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

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

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

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