Database Design Process Solved MCQs Questions AnswersBy: Prof. Dr. Fazal Rehman | Last updated: April 16, 2025 39 Score: 0 Attempted: 0/39 Subscribe 1. A preliminary investigation of the required database is called? (A) Feasibility studies (B) Data flow diagram (C) All of these (D) Feasibility study 2. The possible inputs for the database are collected by? (A) Data analysis (B) Decision tree (C) Decision table (D) Feasibility study 3. What are the cost factors that are taken into consideration? (A) Project planning (B) Dataflow Diagram (C) Requirement analysis (D) Feasibility study 4. Which tools are involved in the data analysis? (A) Decision tree (B) Requirement analysis (C) Data Flow Diagram (D) A and C both 5. The process of identifying the object and relationships between them is called? (A) E-R diagram (B) Data modeling (C) Data flow diagram (D) Both A & B 6. Graphical representations of the relationship between the entities are? (A) Use case (B) Flow chart (C) E-R diagram (D) None of these 7. The ingredient of data modeling is? (A) Relationship (B) Attributes (C) Classes (D) A & B both 8. The entity is represented in the E-R diagram? (A) Rectangular box (B) Circle (C) Diamond (D) Filled diamond 9. The attribute is represented in the E-R diagram by? (A) Circle (B) Diamond (C) Oval (D) None of these 10. The diamond shape is represented in an E-R diagram? (A) Entity (B) Classes (C) Relationship (D) Attributes 11. In the ERD model, the entity related to itself is referring to? (A) One-to-one relationship (B) Many-to-many relationship (C) Recursive relationship (D) Man-to-one relationship 12. The entity and their relationship in an E-R diagram is represented by? (A) Oval symbol (B) Filled diamond (C) Diamond symbol (D) Triangle symbol 13. Which one represents an entity? (A) Teacher (B) Table (C) Chair (D) All of these 14. That one is not related to an entity? (A) Action (B) Teacher (C) Person (D) Object 15. Person, Parts, chair, table, teacher are example of? (A) An entity (B) Attributes (C) Class (D) None of these 16. Objects and their attributes are defined by? (A) Attribute (B) Classes (C) Entity (D) Relationship 17. Students name, their roll number, address, father name are an example of? (A) Entities (B) Attributes (C) Occurrences (D) None of these 18. The associate/link entities with one another are represented in? (A) Relationship (B) Identifier (C) Attributes (D) Classes 19. Which one is not the type of relationship? (A) One-to-one (B) One-to-many (C) Many-to-many (D) None of these 20. The example of a one-to-one relationship is? (A) Teacher and student (B) Country-capital (C) Moon and sun (D) Dog and bitch 21. Which one of the following is an example of one to many relationships? (A) Dog and bitch (B) Country-capital (C) Father and son (D) None of these 22. The definition of the nature of Relationship is? (A) Class (B) Cardinality (C) Modality (D) Both B and C 23. In which option is related to Modality? (A) Hybrid (B) Optional (C) Mandatory (D) A & B both 24. The mapping of a conceptual database involves in the database development process by: (A) Spiral Model (B) Agile model (C) Network Model (D) Implementation model 25. The major objective of the Database designs is? (A) To map conceptual database model to an implementation model (B) To draw use case diagram (C) To design integration model (D) To design the database model 26. What are the activities performed in logical design process? (A) Represent object (B) Represents class (C) Represents relationship (D) None of these 27. The relationship of merging is also called? (A) View E-R model (B) View data model (C) View integration (D) View ERD 28. The database organizing on secondary storage is related to? (A) Logical design (B) Normalization (C) Physical design (D) Specialization 29. This component is not the type of physical database design? (A) Generalization (B) Specialization (C) Normalization (D) Integrity constraints 30. In physical database design, the size of the database is estimated in? (A) Indexes (B) Normalization (C) Data volume & usage analysis (D) Integrity constraints 31. The component of physical database design is related to the network through which the database is shared among different users are? (A) Data distribution strategy (B) Normalization (C) Data volume and usage analysis (D) Indexes 32. Which one is not related to the data basic distribution strategy? (A) Replicated (B) Centralized (C) Partitioned (D) Duplicated 33. Which one is related to the data basic distribution strategy? (A) Centralized (B) Partitioned (C) Replicated (D) All of these 34. What strategies the data is located at a single point? (A) Duplicated (B) Centralized (C) Partitioned (D) Replicated 35. On which technique for physically arranging the record of a file on secondary storage is? (A) File organization (B) Centralization (C) Normalization (D) Data distribution 36. The creation of indexes may be? (A) Primary key (B) Candidate key (C) Alternate key (D) All of these 37. The _______ component of the physical database design refers to the correctness and consistency of data? (A) Data distribution strategy (B) Normalization (C) Relationship (D) Integrity constraints 38. The integrity constraints components of physical database design is another form of? (A) Data distribution (B) Data protection (C) Normalization (D) Specialization 39. Which kind of fragment is stored at only one site in hybrid distribution? (A) Noncritical fragment (B) Large fragment (C) Critical fragment (D) None of these Related Posts:Process Synchronization Solved MCQs Questions AnswersElectronic circuit design MCQs Quizlet (Bank of Solved Questions Answers)ASIC Design and FPGAs MCQs Quizlet (Bank of Solved Questions Answers)Machine Design MCQs Quizlet (Bank of Solved Questions Answers)Database Models Solved MCQs Questions AnswersDatabase security MCQs - Solved Questions Answers