Database Design Quiz with Answers PDF Download – Test 141

MCQ 701: Among the undesirable property that a bad design may have, includes:

1. Repetition of information
2. Inability to represent some information
3. No integrity constraints
4. All of the Above

MCQ 702: If the where clause is omitted, in which case:

1. All tuples are deleted
2. All attribute are deleted
3. Specified tuples are deleted
4. Specified attributes are deleted

MCQ 703: Operation that outputs pairs of rows from the two input relations that have the same value on all attributes that have the same name, is known as:

1. Natural join
2. Union operation
3. Selection
4. Projection

MCQ 704: A schema can be defined by the languages:

1. Data Modification language
2. Data Definition language
3. Data Declaration language
4. Both A and B

MCQ 705: SQL provides a way of renaming the attributes of a result relation, with the clause:

1. Renew
2. Rename
3. AS
4. Modify