12th class (Fsc) computer unit 3 MCQs
chapter 3 MCQs 12th Class computer
Database Design Process:
1. All the hardware costs are considered during:
a. Feasibility study
b. Project planning
c. Data analysis
d. Requirements analysis
2. Which of the following activities are involved in data analysis?
a. Decision trees
b. Data flow diagram
c. Decision tables
d. All
3. An entity related to itself in an ERD model refers to:
a. Many-to-many relationship
b. Recursive relationship
c. One-to-one relationship
d. One-to-many relationship
4. In ERD model, the relationship between two entities is represented by a:
a. Oval symbol
b. Diamond symbol
c. Line
d. Rectangular box
5. In an E-R diagram, a rectangle represents a(n):
a. Relationship
b. Entity
c. Attribute
d. None
6. ……… is used to define characteristics of an entity/object.
a. Records
b. Object
c. Files
d. Attributes
7. In an E-R diagram, a diamond represents a(n):
a. Entity
b. Attributes
c. Modality
d. Relationship
8. Customers, cars and parts are examples of:
a. Cardinals
b. Entities
c. Relationships
d. Attribute
9. Which one is not related to an entity?
a. Action
b. Person
c. Object
d. Concept
10. Color of car is an example of:
a. Relation
b. Entity
c. Relationship
d. Attributes
11. Which one of the following is used to associate entities with each other?
a. Entities
b. Attributes
c. Cardinals/Identifier
d. Relationship
12. An entity related to itself in an ERD model refers to relationship:
a. Many to many
b. Recursive
c. One to one
d. One to many
13. A relationship between countries and capitals is an example of relationship:
a. Many-to-Many
b. One-to-one
c. Many-to-One
d. One-to-Many
14. Which of the following defines the nature of the relationship?
a. Modality
b. Decision tree
c. Both A & B
d. None
15. E-R diagram represents:
a. Cardinals
b. Attribute
c. Entity
d. Relationship
16. Which of the following is used to describe the characteristics of an object:
a. Cardinality
b. Attribute
c. Modality
d. Relationship
17. How many types of relationship?
a. 3
b. 5
c. 6
d. 4
18. A person’s name and birthday are examples of:
a. Relationships
b. Entities
c. Descriptions
d. Attributes
19. Which of the following is used to associate entities with one another?
a. Identifier
b. Entity
c. Relationship
d. Attribute
20. Which is not included in the definition of an entity?
a. Concept
b. Person
c. Action
d. Object
21. A person’s name, birthday and social security number are example of:
a. Relationships
b. Attributes
c. Descriptors
d. Entities
22. Which of the following are ingredients of data modeling?
a. Relationship
b. Entities/objects
c. Attribute
d. All
23. The relationship can be:
a. Many-to-many
b. One-to-one
c. One-to-many
d. All
24. Which of the following represent the entities?
a. Aero plane
b. Teacher
c. Student
d. All
25. Which of the following is related to modality?
a. Optional
b. Mandatory
c. Unidirectional
d. Both A & B