12th Class Computer Science MCQs

12th Class Computer Science Chapter 03 MCQs with Answers

by

Welcome to the 12th Class Computer Science Chapter 03 MCQs Online Test. We are presenting you with top MCQ questions from the 12th Class Computer Science Chapter Database Design Process.

We want to tell you that you can find all the 12th Class Computer Science Chapter 03 MCQs online tests on our website. These online tests are great for learning and as well as for scoring maximum marks in your Intermediate Exams. We are making these Class 12 Computer Science MCQs online tests for those who want full marks in their exams. Attempt all these Grade 12 Computer Science Online Multiple Choice Questions MCQs before going for the exam and it will be beneficial for you! These online tests contain all the important multiple choice questions in the important topics of the FSC Part-II  Computer Science Chapter 03 Database Design Process. 

Contents hide
1 12th Class Computer Science Chapter 03 MCQs with Answers
1.1 MCQs Class 12 Computer Science with Answers
1.2 What is Database Design Process?
1.3 Related posts:

12th Class Computer Science Chapter 03 MCQs with Answers

Youth For Pakistan has provided an excellent opportunity for the students of the 12th class to prepare their Computer Science Chapter 03 Database Design Process online with MCQs test.

This is a free platform for students to prepare for Computer Science Exams for Class 12 to get the best accomplishments in annual exams. 12th class Students can analyze themself by attempting this online test system as many times as they want until they find themself fully prepared.

MCQs Class 12 Computer Science with Answers

The purpose of these online MCQs tests is to help you evaluate your 12th Class Computer Science Chapter 03 MCQs. These Multiple Choice Questions (MCQs) will prepare you for your academic success in the 12th Class Exams. 12th Class Computer Science Chapters include Chapter No 1 Data basics, Chapter No 2 Basic Concepts And Terminology, Chapter No 3 Database Design Process, Chapter No 4 Data Integrity & Normalization, Chapter No 5 Introduction of Microsoft Access, Chapter No 6 Table and Query, Chapter No 7 Microsoft Access forms & Reports, Chapter No 8 Getting Started with C, Chapter No 9 Element Of C, Chapter No 10 Input/Output, Chapter No 11 Decision Constructors, Chapter No 12 Loop Constructors, Chapter No 13 Functions and Chapter No 14 File Handling in C. 

What is Database Design Process?

Database Design is a collection of processes that facilitate the designing, development, implementation, and maintenance of enterprise data management systems. Properly designed database are easy to maintain, improves data consistency, and are cost-effective in terms of disk storage space. The database designer decides how the data elements correlate and what data must be stored.

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
Total
0
Shares
Share 0
Tweet 0
Pin it 0

Related posts:

  1. 12th Class Computer Science Chapter 06 MCQs with Answers
  2. 12th Class Computer Science Chapter 07 MCQs with Answers
  3. 12th Class Computer Science Chapter 05 MCQs with Answers
  4. 12th Class Computer Science MCQs Test Preparation

Leave a Comment