header1.html

Monday, 8 April 2013

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