Database Design Process - MCQs Online Quiz

Database Design Process - MCQs Online Quiz. Find the most important and more conceptual multiple-choice questions (MCQs) with answers of Computer Chapter No.3: Database Design Process, ICS Part 2 on the database management system (DBMS) for the interview and final examinations for all boards of Pakistan and entry test for admission in universities.

This post contains the multiple-choice questions (MCQs) - online quiz online on the database design process that covers the topics i.e., feasibility study, requirements analysis, project planning, data analysis, data modeling, and its ingredients (entities, attributes, relationships, cardinality, and modality), ERD (entity relationship diagram), conceptual (logical) database design, physical database design, and implementation.

➤ Database Design Process - Short Questions
➤ Data Integrity and Normalization
➤ Basic Concepts & Terminology of Databases
➤ Data Basics
➤ Getting Started with C - MCQs
➤ Elements of C - MCQs
➤ Input/Output - MCQs
➤ Decision Constructs - MCQs
➤ Loop Constructs - MCQs
➤ Functions in C - MCQs
➤ File Handling - MCQ

Chapter No.3: 
Database Design Process | MCQs

 

1. A table that is used to determine the location of rows in a table or tables, satisfying some conditions?
   1.   view
   2.   index
   3.   relation
   4.   condition table
2. Example of M:M relationship is?
   1.   country – capital
   2.   book – author
   3.   student – club
   4.   HOD – department
3. Example of 1:M relationship is?
   1.   country – capital
   2.   father – son
   3.   room – student
   4.   father – son + room – student
4. Example of 1:1 relationship is?
   1.   country – capital
   2.   mother – daughter
   3.   student – teacher
   4.   none of these
5. How entities are related to each other is indicated by?
   1.   statistics
   2.   primary key
   3.   relationship
   4.   none of these
6. In ERD model, the oval shape represents?
   1.   entities
   2.   relationship
   3.   attributes
   4.   none of these
7. In 1:M relationship, the term Many relationship is represented by?
   1.   single vertical bar
   2.   crow’s foot
   3.   oval
   4.   none of these
8. The activity which involves area of identification and selection?
   1.   project planning
   2.   requirement analysis
   3.   feasibility study
   4.   none of these
9. The critical fragments in hybrid data distribution are stored on?
   1.   at one site
   2.   more than one sites
   3.   at central point only
   4.   none of these
10. The identification of data objects and their relationship is performed in?
    1.   normalization
    2.   DBMS
    3.   data modeling
    4.   none of these
11. The logical database design process consists of?
    1.   representation of entities
    2.   merge the relations
    3.   representation of relationships
    4.   all of these
12. The merging of relationships helps us in removing?
    1.   data integrity
    2.   data independence
    3.   errors in database
    4.   data redundancy
13. The relationships are always?
    1.   unidirectional
    2.   bidirectional
    3.   multidirectional
    4.   none of these
14. The term preliminary investigation can be used for?
    1.   project planning
    2.   requirement analysis
    3.   feasibility study
    4.   none of these
15. What will be the modality if cardinality of a relationashi8p is at least one?
    1.   optional
    2.   mandatory
    3.   optional + mandatory
    4.   none of these
16. Which of the following activity is not part of the data analysis?
    1.   data flow diagram
    2.   decision table
    3.   decision tree
    4.   cardinality
17. Which of the fallowing data distribution strategy contains updating problem?
    1.   centralized
    2.   portioned
    3.   replicated
    4.   none of these
18. Which of the following defines nature of relationship?
    1.   relationship
    2.   cardinality
    3.   data modeling
    4.   modality
19. Which of the following information is provided by cardinality?
    1.   nature of relationship
    2.   power of relationship
    3.   degree of relationship
    4.   none of these
20. Which of the following is another form of database protraction?
    1.   data integration
    2.   data independence
    3.   data integrity
    4.   none of these
21. Which of the following is an ingredient of data modeling?
    1.   entity
    2.   relationship
    3.   attribute
    4.   all of these
22. Which of the following is an input to physical database design process?
    1.   logical database structure
    2.   characteristics of DBMS
    3.   user processing requirements
    4.   all of these
23. Which of the following is not a disadvantage of centralized distribution?
    1.   no access of data at remote sites
    2.   database fails when centralized system fails
    3.   low communication cost
    4.   none of these
24. Which of the following is the criterial for selecting file organization?
    1.   protection from failure of data loss
    2.   protection from data loss
    3.   security from unauthorized access
    4.   all of these