2nd Year Computer Chapter 3 MCQs with Answers

You can get 2nd Year Computer Chapter 3 MCQs with Answers on this page. Tackle MCQs to test your core concepts from Chapter 3 (Database Design Process) and confidently prepare for your exams! All the correct answers have been bolded.

12th Class Chapter 3 Computer Science MCQS

Here is the 12th computer science chapter 3 mcqs with answers:

1. During______phase, the project requirements are gathered and identified.

a. Project planning

b. Requirement Analysis

c. Feasibility study

d. Data Analysis

2. All the hardware costs are considered during:

a. Project planning

b. Requirement Analysis

c. Feasibility study

d. Data Analysis

3. Which of the following activities are involved in data analysis?

a. Data Flow diagram

b. Decision Tables

c. Decision Trees

d. All

4. Which of the following are ingredients of data modeling?

a. Entities

b. Attribute

c. Relationship

d. All

5. Which of the following is used to describe the characteristics of an object?

a. Attribute

b. Relationship

c. Cardinality

d. Modality

6. Which of the following is used to associate entities with one another?

a. Combination

b. Association

c. Extraction

d. Relationship

7. Customers, cars, and parts are examples of:

a. Entities

b. Attributes

c. Cardinals

d. Relationships

8. Which of the following symbols is not used in an ERD?

a. Rectangle

b. Oval

c. Diamond

d. Triangle

9. In the ERD model, the relationship between two entities is represented by:

a. Diamond symbol

b. Rectangular box

c. Oval symbol

d. Triangle symbol

10. In an ER diagram, a rectangle represents:

a. Entity

b. Optional one

c. Relationship

d. Attribute

11. In an ER diagram, a diamond represents:

a. Entity

b. Attribute

c. Relationship

d. File

12. Which of the following is NOT included in the definition of an entity?

a. Person

b. Object

c. Concept

d. Action

13. A person’s name birthday and social security number are examples of:

a. Attributes

b. Entities

c. Relationships

d. Description

14. Which of the following represents an entity?

a. Teacher

b. Student

c. Airplane

d. All

15. The relationship can be:

a. One to one

b. One to many

c. Many to many

d. All

16. The logical representation of an organization’s data is called:

a. Database management system

b. Entity-relationship model

c. Relationship systems design

d. Database entity diagram

17. An entity related to itself in an ERD model refers to:

a. Recursive relationship

b. One-to-many relationship

c. Many-to-many relationships

d. One-to-one relationship

18. How many types of relationships are used?

a. 2

b. 3

c. 4

d. 5

19. Which of the following is an example of a one-to-one relationship?

a. Student-RegNo

b. Person-automobile

c. Mother-daughter

d. Person-phone number

20. Which of the following is a one-to-many relationship?

a. Student-RegNo

b. Person-automobile

c. Mother-daughter

d. Both b and c

21. A relationship between a country and capital is an example of a relationship.

a. One-to-One

b One-to-Many

c. Many-to-Many

d. Many-to-One

22. Which of the following defines the nature of the relationship?

a. Modality

b. Decision Tree

c. Primary key

d. Attribute

23. Which of the following is related to modality?

a. Optional

b. Mandatory

c. Unidirectional

d. a and b

24. Which of the following models uses concepts such as attributes, relationships, and entities is classified as?

a. Conceptual data model

b. Graphical data model

c. Representative data model

d. Physical data model

25. A technique for physically arranging the records of a file on secondary storage devices is called:

a. Physical pointer

b. Retrieval program

c. File organization

d. Update program

26. A factor to consider when choosing a file organization is:

a. Fast retrieval

b. Security

c. Efficient storage

d. All

27. The database development process involves mapping the conceptual data model into:

a. Object-oriented data model

b. Network data model

c. Implementation model

d. Hierarchical data model

28. Merging the relation is also known as:

a. View integration

b. View entities

c. View relationships

d. View constraints

29. Organizing the database in computer disk storage is done in:

a. Logical design

b. Physical design

c. Analysis

d. Implementation

30. Which of the following is a basic data distribution strategy?

a. Centralized

b. Partitioned

c. Replication

d. All

Related Articles