DATABASE DESIGN 9 Jul,2023 boomtecho2@gmail.comLeave a comment Please enter your email: 1. What is database Design ? Database design is a collection of process Database design is a storage process Database design is communication medium none of the above 2. Main propose of Database Design in DBMS – Produce Physical Model Produce Logical Model Both A and B None of the Above 3. Database systems are designed to manage Small bodies of information Large bodies of information Plain bodies of knowledge Complex bodies of knowledge 4. The process of identifying the object and relationships between them is called? Data Modleing Data Flow Diagram E-R Model Both A and C 5. Why we use the Database Design in DBMS? Provide a blueprint of how the Data is going Stored in system defined for a database give a clear idea of the behavior of any application and how the requests are processed the processing time of an application is greatly reduced All of the above 6. What is enhance in process of database design? Development Implementation Maintenance All of the Above 7. How many phase are include in database design ? 5 6 7 3 8. Which one is not the part of Database design Life Cycle- Requirement Logical Design Physical Design None 9. Requirements Analysis – involves assessing the informational needs of an organization Gathering the data, fact and information Both A and B None of the Above 10. Another Name of Logical Design- Conceptual Model schema Detecting model none of the above 11. What is Physical Model in Database design ? Practice and implementation of Logical model developing a model based on the proposed requirements Both A and B None of the Above 12. The major objective of the Database designs is? to map conceptual database model to an implementation model to draw use case diagram to design integration model .to design the database model 13. What are the Activities are performed in logical design process? represent object represents class represents relationship None of these 14. This component is not the type of physical database design? generalization specialization normalization integrity constraints 15. In physical database design, the size of the database is estimated in? indexes normalization data volume &usage analysis integrity constraints 16. The——component of the physical database design refers to the correctness and consistency of data? data distribution strategy normalization relationship Integrity Constraints 17. The integrity constraints components of physical database design is another form of? Data distribution data protection Normalization specialization 18. Which one feature of Logical data Model- Normalization Occure Foreign keys which are used to identify a relationship between different entities are specified. The primary key for each entity is specified. All of the Above Loading …
