Database Views MCQ with Answers PDF Download – Test 24

MCQ 116: Any relation that is not part of the logical model, but is made visible to a user as a:

1. Natural relation
2. Absolute relation
3. Virtual relation
4. Linear relation

MCQ 117: Binary relationship sets in UML can be represented by just drawing a line connecting:

1. Entity sets
2. Relationships
3. Attributes
4. Objects

MCQ 118: The join preserves tuples only in the relation named after the right outer join operation, is to be:

1. Right outer join
2. Right inner join
3. Left inner join
4. Left outer join

MCQ 119: If the tuples are satisfying the where predicate, then they are placed into groups by the:

1. Having clause
2. Group by clause
3. Like clause
4. Distinct clause

MCQ 120: The clause that apply the aggregate functions to get a single result tuple for each group, is known to be:

1. Select clause
2. From clause
3. Where clause
4. Distinct clause