12th Class Class Computer Mcqs Chapter No 3 | 2nd Year Computer Mcqs Chapter Wise Pdf

written by Assad Javaid | August 6, 2021

Chapter No 3

Database Design Process

1. Which of the following keys does not hold uniqueness property 

  1. Candidate key
  2. foreign key 
  3. Primary key
  4. secondary key 

2. An entity related to itself in an ERD model refers to 

  1. recursive relationship
  2. one-to-many relationship
  3. many-to-many relationship
  4. one-to-one relationship 

3.           is called the preliminary investigation of the required database choose which one is correct:

  1. Project planning
  2. Feasibility study
  3. Requirement Analysis
  4. Data Analysis

4. In          activities, the possible inputs for the database are collected choose which one is correct:

  1. Project planning
  2. Feasibility study
  3. Requirement Analysis
  4. Data Analysis

5. In           activities, the cost factors are taken into consideration choose which one is correct: 

  1. Project planning
  2. Feasibility study
  3. Requirement Analysis
  4. Data Analysis

6. Database development process involve mapping of conceptual data model into

  1.  object oriented data model
  2. network data model 
  3. implementation model
  4. Hierarchical data model

7. In ERD model, the relationship between two entities is represented by a

  1. diamond symbol
  2. rectangular box
  3. oval symbol
  4. line

8.         tools in involved to the Data Analysis choose which one is correct: 

  1. Data Flow Diagram
  2. Decision Table
  3. Decision Tree
  4. All of these

9. The process to identify the data objects and the relationships between them is choose which one is correct:

  1. Data Modeling
  2. Data Flow Diagram
  3. Data table
  4. None the these 

10. The relationship between the entities is represented graphically by using choose which one is correct:

  1. E-R Diagram
  2. Data Flow Diagram
  3. Flowcharts
  4. Decision Tables

11. In hybrid distribution which kind of fragments are stored at only one site

  1. critical fragments
  2. non-critical fragments
  3. critical and non-critical fragments
  4. only large fragments 

12. What indicates the connection between entities 

  1. Relationship
  2. Attributes
  3. Occurences
  4. Data

13. Which one is the ingredient of data modeling choose which one is correct: 

  1. Objects
  2. Attributes
  3. Relationships
  4. All of these

14. In E-R diagram, a rectangular box is used to represent a(n) choose which one is correct: 

  1. Entity
  2. Attribute
  3. Relationship
  4. None of these 

15. In E-R diagram, an oval shape is used to represent a(n) choose which one is correct: 

  1. Entity
  2. Attribute
  3. Relationship
  4. None of these 

16. In E-R diagram, a diamond shape is used to represent a(n) choose which one is correct: 

  1. Entity
  2. Attribute
  3. Relationship
  4. None of these

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

  1. Indexes
  2. Integrity Constraints 
  3. File Organization
  4. None of above 

18. An index may be created on 

  1. Primary Key
  2. Secondary Key
  3. Foreign Key
  4. All of above 

19.       represents entity choose which one is correct:

  1. Student
  2. Teacher 
  3. Train
  4. All of these

20.          is not related to an entity choose which one is correct: 

  1. Person
  2. Concept 
  3. Action
  4. Object

21.             is used to associate entities with one another choose which one is correct:

  1. Attributes
  2. Relationship
  3. Occurrences
  4. Identifier

22.           is a type of relationship choose which one is correct: 

  1. One-to-One
  2. One-to-Many
  3. Many-to-Many
  4. All of these

23.           is an example of one-to-one relationship choose which one is correct:

  1. Country – Capital
  2. Mother – Daughter 
  3. Teacher – Student
  4. Both (a) & (c)

24. The relationship between entities is represented graphically by using.

  1. E-R Diagram
  2. Context Level Diagrams 
  3. Decision Table
  4. Data Flow Diagram

25. Data is stored at single site while following 

  1. Centralized Strategy
  2. Distributed Strategy 
  3. Hybrid Strategy
  4. Partitioned Strategy

26. Which Involves the area identification and selection 

  1. Feasibility Study
  2. Initial Study
  3. Feasibility Analysis
  4. Initial Analysis

27. In which phase proper market analysis is also worked out 

  1. Initial Analysis
  2. Initial Study
  3. Feasibility Analysis
  4. Feasibility Study

28.            is an example of one-to-many relationship choose which one is correct:

  1. Country – Capital
  2. Mother – Daughter
  3. Father – Son
  4. Both (b) & (c)

29.            defines the nature of the relationship choose which one is correct: 

  1. Cardinality
  2. Modality 
  3. Both (a) and (b)
  4. None of these 

30. The optional relationship is represented by choose which one is correct: 

  1. O
  2.  | 
  3. |<
  4. None of these 

31.            is related of modality choose which one is correct:

  1. Optional
  2. Mandatory 
  3. Cardinality
  4. Both (a) & (b)

32. What is the major objective of database design choose which one is correct?

  1. To draw E-R diagrams. 
  2. To map the conceptual data model to an implementation model. 
  3. To design the database model.
  4. None of these 

33. Possible inputs and the required functionality output of system is determined during 

  1. Feasibility Analysis
  2. Requirement Analysis
  3. Project Planning
  4. Analysis

34. All the hardware costs are considered during 

  1. Project Planning
  2. Requirement Analysis
  3. Feasibility Analysis
  4. Analysis

35. All the relationships are 

  1. Uni-directional
  2. Bi-directional
  3. Tri-directional
  4. All of Above 

36. Father & children is an example of 

  1. One to One
  2. Many to Many
  3. One to Many
  4. None of Above 

37.           activities is performed in logical design process choose which one is correct:

  1. Represent Entities
  2. Represent relationships 
  3. Normalize the relations
  4. All

38. Merging the relations is also called choose which one is correct:

  1. View data model
  2. View integration
  3. View Relation
  4. None of these 

39. Organizing the database on secondary storage is related to choose which one is correct:

  1. Logical design
  2. Physical design
  3. Implementation
  4. Analysis

40.             is not component of physical database design choose which one is correct: 

  1. Data volume & usage Analysis
  2. File organization
  3. Normalization 
  4. Integrity constraints

41. In         components of physical database design, the size of database is  estimated choose which one is correct:

  1. Data volume & usage Analysis 
  2. Data Distribution Strategy
  3. Indexes
  4. Integrity constraints

42.           components of physical database design is related to the networking  through which the data of database is shared among different users choose which one is correct: 

  1. Data volume & usage Analysis
  2. Data Distribution Strategy 
  3. Indexes
  4. Integrity constraints

43.          is the basic data distribution strategy choose which one is correct:

  1. Centralized
  2. Partitioned
  3. Replicated
  4. Hybrid
  5. All 

44. In ERD there are 

  1. Data Objects
  2. Relationships 
  3. Both a and b
  4. None of Above 

45. The primary objective of ERD is to represent 

  1. Data Objects
  2. Cardinality & Modality
  3. Association
  4. All of Above

46. The implementation model of database design is derived from

  1. Relational Model
  2. Conceptual Model
  3. User Model
  4. All of Above 

47. Database users require _____________ information 

  1. Complete
  2. Up to Date
  3. Fast
  4. All of Above

48. Which one is not a data distribution strategy 

  1. Centralized
  2. Balanced
  3. Replicated
  4. Partitioned 

49. In _______________database is divided into fragments 

  1. Partitioned
  2. Hybrid
  3. Replicated
  4. Centralized 

50.          is not a basic data distribution strategy choose which one is correct:

  1. Centralized
  2. Partitioned
  3. Hybrid
  4. Duplicated

51. In which strategy full copy of database is assigned to more than one sites in the

network

  1. Partitioned
  2. Balanced
  3. Replicated
  4. Centralized 

52. In which strategy there is a problem of update 

  1. Partitioned
  2. Balanced
  3. Replicated
  4. Centralized 

53. In _______________database is divided critical and non critical fragments

  1. Partitioned
  2. Hybrid
  3. Replicated
  4. Balanced 

54. Critical fragments are stored at ____site(s)

  1. 1
  2. 2 
  3. 3
  4. Multiple 

55. In database correctness and consistency refers to the 

  1. Constraints
  2. Database Constraints
  3. Integrity Constraints
  4. None of Above 

56.              components of physical database design refers to the correctness and consistency of data choose which one is correct: 

  1. Indexes
  2. Integrity constraints
  3. File organization
  4. Data distribution strategy

57.          components of physical database design is another form of data  protection choose which one is correct: 

  1. Indexes
  2. Integrity constraints
  3. File organization
  4. Data Distribution strategy

58. In hybrid distribution which kind of fragments is stored at only one site choose which one is correct: 

  1. Critical fragments 
  2. Non-Critical fragments
  3. Critical and non-critical fragment
  4. Only large fragments

<Previous Chapter

Take Quiz No 3

Next Chapter >