Modification of Database Quiz PDF: Questions and Answers - 47

MCQ 231: SQL supports basic set operations on relations that includes

1. Union
2. Intersect
3. Except
4. All of the above

MCQ 232: Since duplicate retention is the default, we shall not use

1. Distinct
2. All
3. Describe
4. Whole

MCQ 233: The command to delete the relation is

1. Delete from *example*
2. Delete about *example*
3. Abort from *example*
4. Abort about *example*

MCQ 234: A special character, can be used to delimit the different attributes of a record, such as

1. Question mark
2. new-line character
3. curly braces
4. Comma

MCQ 235: Indices whose search key formation is different from the sequential order of the file, are known to be

1. Non-clustering indices
2. Secondary indices
3. Primary indices
4. Both A and B