SQL Certification Exam Questions Answers – Test 16

MCQ 76: In SQL, a view is said to be updatable, if its Select clause does not have any:

1. Expressions
2. Aggregates
3. Distinct specification
4. All of the Above

MCQ 77: A predicate involving attributes is defined by the where clause of the relation from the:

1. From clause
2. Select clause
3. Define clause
4. IN clause

MCQ 78: Some SQL extensions allows view relations to be:

1. Stored
2. Prestored
3. Precomputed
4. Precompiled

MCQ 79: An updatable SQL view is the one with its Select clause containing:

1. Only 1 attribute
2. Only 2 attributes
3. Multiple attributes
4. No attributes

MCQ 80: The built-in aggregate function named count(*) is not allowed to be used with the clause:

1. Like clause
2. Distinct clause
3. Select clause
4. Define clause