MC	Given the following EER specialisation:<br><br><img class="img-fluid"  src="http://www.pdbmbook.com/static/quiz/fig3_6.png"><br><br>According to the model, which of the following statements is CORRECT?	All food products are either Fruits&Vegetables or meat. 	incorrect	A supermarket product can be a food and non-food product at the same time.	incorrect	A meat product does not have any attributes types.	incorrect	There are certain supermarket products that are not Fruits&Vegetables, not meat and not non-food.	correct	
MC	Which of the following statements about the (E)ER model is correct?	The (E)ER model allows to enforce consistency across multiple relationship types.	incorrect	One of the limitations of the ER model is that temporal constraints cannot be modelled. However, this limitation is not present in the EER model.	incorrect	An entity represents a set of entity types with similar properties.	incorrect	A weak entity type cannot have a key attribute type of its own. Therefore, a weak entity type borrows an attribute type of its owner entity type.	correct	
MC	Which of the following statements about the (E)ER model is correct?	One of the limitations of the ER model is that temporal constraints cannot be modelled. However, this limitation is not present in the EER model.	incorrect	A weak entity type cannot have a key attribute type of its own. Therefore, a weak entity type borrows an attribute type of its owner entity type.	correct	The (E)ER model allows to enforce consistency across multiple relationship types.	incorrect	An entity represents a set of entity types with similar properties.	incorrect	
MC	<img class="img-fluid" src="http://www.pdbmbook.com/static/quiz/fig2_3_6.png"><br>Which of the following statements about this EER model is correct?	An airline is existence dependent on a flight.	incorrect	A flight can be both commercial and private.	incorrect	A private flight can have zero to many customers.	incorrect	The attribute type 'flightNR' can be used to uniquely identify a flight.	correct	
MC	<img class="img-fluid" src="http://www.pdbmbook.com/static/quiz/fig2_3_11.png"><br>Which of the following statements about the above UML model is not correct?	A play's ShowDate and a TV Show's AirDate cannot be deleted. However, values can be added. 	incorrect	This UML data model applies the principle of information hiding. 	incorrect	An actor can star in several productions.	incorrect	A person is existence dependent on a production.	correct	
MC	Which statement about access modifiers is correct?	A private access modifier is denoted with a '+', public with '#' and protected with '-'.	incorrect	A private access modifier is denoted with a '-', public with '+' and protected with '#'.	correct	A private access modifier is denoted with a '-', public with '#' and protected with '+'	incorrect	A private access modifier is denoted with a '#', public with '+' and protected with '-'	incorrect	
MC	Which statement is CORRECT?	A ternary relationship type can always be represented as 3 binary relationship types without loss of semantics.	incorrect	In case a ternary relationship type is represented as 3 binary relationship types, then semantics will get lost.	correct	A ternary relationship type cannot have attribute types.	incorrect	3 binary relationship types between 3 entity types can always be replaced by 1 ternary relationship type between the 3 participating entity types.	incorrect	
MC	Given the following EER specialisation:<br><br><img class="img-fluid"  src="http://www.pdbmbook.com/static/quiz/fig3_6.png"><br><br>According to the model, which of the following statements is CORRECT?	All food products are either Fruits&Vegetables or meat. 	incorrect	A meat product does not have any attributes types.	incorrect	A supermarket product can be a food and non-food product at the same time.	incorrect	There are certain supermarket products that are not Fruits&Vegetables, not meat and not non-food.	correct	
MC	A composite aggregation...	has a maximum multiplicity of 1 and a minimum multiplicity of 0 or 1 at the composite side. 	correct	has a maximum multiplicity of n and a minimum multiplicity of 0 or 1 at the composite side. 	incorrect	has a maximum multiplicity of n and a minimum multiplicity of 0 at the composite side. 	incorrect	has a maximum multiplicity of 1 and a minimum multiplicity of 1 at the composite side. 	incorrect	
MC	Which statement about access modifiers is correct?	A private access modifier is denoted with a '+', public with '#' and protected with '-'.	incorrect	A private access modifier is denoted with a '#', public with '+' and protected with '-'	incorrect	A private access modifier is denoted with a '-', public with '+' and protected with '#'.	correct	A private access modifier is denoted with a '-', public with '#' and protected with '+'	incorrect