DBMS Quiz-2

DBMS Quiz-2

1.What is Relationship? It is an association among two or more entities. It is an association among the one entity It as an association among the three entities None of the above. 2.What is Relationship type? Relationship type defines a set of associations or a relationship Set among a given set of entity types. Relationship set among a given set of attributes Relationship its association among the three attributes None of the above 3.What is an Entity set in Entity relation Diagram? It is a collection of all attributes of particular entity type in the database It is a collection of all entities of particular entity type in the database It is a collection of all relationship of particular entity type in the Database None of the above. 4.What is an Entity? It is a Object in the real world with an independent existence. It is a ‘thing’ in the real world with a dependent existence. It is a ‘thing’ in the real world with a relationship existence None of the above. 5.What is an attribute? It is a particular property, which describes the entity. It is a particular property, which describes the Relationship. It is a particular property, which describes the attribute properties None of the above 6.The primary key constraint allows null values True False 7.Which of the integrity constraints enforces relationship between tables ( choose the most suitable option) Referential Constraint Referential key Referential integrity None of the above 8.A Composite Key is __________ A key composed of more than one column is called composite key or Concatenated Key A key composed only one column is called composite key or Concatenated Key A key which initiated the concatenated key None of the above 9. A user that manages the files of application in DBMS is called: Administrator Database analyst File Manager None of these 10. _________is the real world object, such as a person, place etc. Entity Attribute Records All of these