computer MCQs - 12th class Chapter 03 Mcqs

1

Which activity is also called the preliminary investigation of the required database?

A

Data Analysis

B

Feasibility Study

C

Project Planning

D

Requirements Analysis

2

The process of identifying data objects and the relationships between them is called?

A

Data Analysis

B

Data Modeling

C

Database Design

D

Project Planning

3

Anything that is participating in the system and is properly identifiable is known as a(n) ____.

A

Attribute

B

Relationship

C

Entity/Object

D

Modality

4

Which of the following would be an attribute for a TEACHER entity?

A

Student

B

Book Store

C

Pay Scale

D

Aeroplane

5

The property that indicates how entities are connected or related to each other is called a ____.

A

Cardinality

B

Modality

C

Attribute

D

Relationship

6

The property that defines whether the occurrence of one object is related to another is known as ____.

A

Modality

B

Cardinality

C

Attribute

D

Relationship

7

In the context of relationships, 'One to one', 'One to many', and 'Many to many' are types of ____.

A

Modality

B

Entities

C

Cardinality

D

Attributes

8

The property that defines the nature of the relationship, such as optional or mandatory, is called ____.

A

Modality

B

Cardinality

C

Association

D

Connectivity

9

In modality, the value '1' represents a(n) ____ relationship.

A

Optional

B

Recursive

C

Mandatory

D

Bi-directional

10

In modality, an optional relationship is represented by ____.

A

0

B

1

C

M

D

N

11

A graphical representation of entities and their relationships is called a(n) ____.

A

DFD

B

Data Model

C

Flowchart

D

ERD

12

In an ERD, what is the primary objective?

A

To represent the physical storage

B

To represent Entities/Objects and their relationships

C

To plan the project budget

D

To normalize the data

13

Which of the following is NOT a primary component identified for an ERD in the text?

A

Data objects

B

Attributes

C

Normalization

D

Cardinality

14

In an ERD model, a relationship between two entities is represented by a ____.

A

rectangular box

B

oval symbol

C

diamond symbol

D

line

15

The major objective of Database design is to map the conceptual data model to a(n) ____.

A

Enterprise Data Model

B

Implementation model

C

Technology Model

D

Physical Model

16

The database design process is divided into how many main phases?

A

One

B

Two

C

Three

D

Four

17

The process of mapping conceptual data models to structures specific to a target DBMS is called ____.

A

Physical Database Design

B

Conceptual (Logical) Database Design

C

Data Analysis

D

Implementation

18

In logical design, each entity type from the E-R diagram is represented as a ____.

A

Primary Key

B

Foreign Key

C

Relation

D

Attribute

19

What does the identifier of an entity type become in the relational model?

A

A non-key attribute

B

The Primary key

C

A foreign key

D

The relation name

20

The process that refines relations to avoid unnecessary redundancy and update anomalies is called ____.

A

Merging

B

Representation

C

Normalization

D

Association

21

What is the last stage of the database design process?

A

Conceptual Design

B

Analysis

C

Physical Database Design

D

Implementation

22

Which of the following is a major input to Physical Database Design?

A

User processing requirements

B

Initial project idea

C

Market analysis report

D

Team member salaries

23

The process of estimating the size and usage patterns of the database is called ____.

A

Data Distribution Strategy

B

Data Volume and Usage Analysis

C

File Organization

D

Integrity Constraints

24

Which data distribution strategy involves locating all data at a single site?

A

Partitioned

B

Replicated

C

Hybrid

D

Centralized

25

Which strategy divides the database into fragments and assigns each to a particular site?

A

Centralized

B

Replicated

C

Partitioned

D

Hybrid

26

Storing a full copy of the database at more than one site is known as the ____ strategy.

A

Replicated

B

Partitioned

C

Centralized

D

Hybrid

27

In which strategy are non-critical fragments stored at one site and critical fragments at multiple sites?

A

Centralized

B

Partitioned

C

Replicated

D

Hybrid

28

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

A

Indexing

B

File Organization

C

Data Distribution

D

Integrity Constraint

29

What is a table used to determine the location of rows that satisfy a certain condition?

A

Relation

B

View

C

Index

D

File

30

The correctness and consistency of data is referred to as ____.

A

Security

B

Integrity

C

Precision

D

Availability

31

Protecting data from unauthorized operations is the main concern of ____.

A

Integrity

B

Security

C

Normalization

D

Recovery

32

NADRA and CRICKINFO are given as examples of what type of environment?

A

Centralized computing

B

Standalone systems

C

Distributed computing environment

D

Personal databases

33

DFD stands for ____.

A

Data Flow Diagram

B

Data File Diagram

C

Database Flow Design

D

Data Format Design

34

An entity related to itself in an ERD model refers to a ____ relationship.

A

one-to-many

B

recursive

C

many-to-many

D

one-to-one

35

According to the text, relationships between objects are generally ____.

A

uni-directional

B

tri-directional

C

non-directional

D

bi-directional

36

Which phase involves gathering possible inputs for the database and its required functionality?

A

Feasibility Study

B

Requirements Analysis

C

Project Planning

D

Data Analysis

37

Salaries of team members and hardware costs are considered during ____.

A

Data Modeling

B

Project Planning

C

Requirements Analysis

D

Data Analysis

38

The primary objective of physical database design is to implement the database as a set of ____.

A

logical relations

B

conceptual models

C

stored records, files, and indexes

D

user interfaces

39

Which of the following is a disadvantage of the centralized data distribution strategy?

A

Data is closer to local users

B

Maximizes local access

C

Database system fails totally if the central system fails

D

Low data communication costs

40

Which key does NOT necessarily hold a uniqueness property?

A

Primary Key

B

Candidate Key

C

Secondary Key

D

Foreign Key

41

The process of removing redundancy by combining two or more relations describing the same entity is called ____.

A

Normalization

B

Merge the Relations

C

Represent Relations

D

Create View

42

In an ERD, an entity is represented by a ____.

A

diamond symbol

B

rectangular box

C

oval symbol

D

line

43

Optional modality is represented by the number ____.

A

1

B

2

C

0

D

many

44

What is the first step of the logical design process shown in the diagram?

A

Represent Relationships

B

Merge the Relations

C

Normalize the Relations

D

Represent Entities

45

What is the final step in the logical design process before achieving the Logical Data Model?

A

Represent Entities

B

Merge the Relations

C

Normalize the Relations

D

Represent Relationships

46

The costs of storage are estimated during which phase of physical design?

A

File Organization

B

Data Distribution Strategy

C

Data Volume and Usage Analysis

D

Integrity Constraints

47

Which is NOT listed as a criterion for selecting a file organization?

A

Fast access for retrieval

B

Efficient use of storage space

C

Color of the user interface

D

Security from un-authorized use

48

Consistency rules that the database is not permitted to violate are called ____.

A

Security policies

B

Integrity Constraints

C

Access protocols

D

User permissions

49

In a distributed environment, connecting users to the server often requires the services of ____.

A

Project Managers

B

Network Administrators

C

System Analysts

D

Data Entry Operators

50

Which of the following is an example of an entity, as per the textbook?

A

Teacher Name

B

Gender

C

AEROPLANE

D

Pay Scale