IS 183 Database Concepts and Applications I Review Exam Q & A 2026 (Complete And Verified Study material) (21pages) LEARNEXAMS

1. What is the primary benefit of implementing Database as a Service (DBaaS) in a cloud computing environment for cybersecurity purposes? - A) Cost reduction - B) Data redundancy - C) Scalability - D) Enhanced security Answer: D) Enhanced security Rationale: While DBaaS offers multiple benefits, enhanced security is paramount for cybersecurity students as it includes built-in security features like encryption and access controls that are essential for protecting sensitive data. 2. In the context of relational database design, which of the following best describes an entity-relationship (ER) diagram? - A) A physical implementation of the database - B) A blueprint outlining the database structure - C) A query language for database manipulation - D) A tool for database performance tuning Answer: B) A blueprint outlining the database structure Rationale: An ER diagram is a conceptual tool used to model the data and its relationships in a systematic way, serving as a blueprint for designing a relational database. 3. When considering the design of a relational database, why are entity relationships important to understand? - A) They dictate the user interface design. - B) They determine the physical storage of data. - C) They define how data entities relate to one another. - D) They are irrelevant to the database functionality. Answer: C) They define how data entities relate to one another. Rationale: Entity relationships are crucial as they define the logical connections between different data entities, which is fundamental to organizing and retrieving data efficiently in a relational database. 4. Which of the following is NOT a characteristic of Database as a Service (DBaaS)? - A) On-demand database provisioning - B) Manual scaling of resources