Database Views Multiple Choice Questions (MCQ) PDF - 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