C175 Data Management Foundations Practice Questions - Set 1 - Part 3

Test your knowledge of data-driven decision making concepts with these practice questions. Each question includes detailed explanations to help you understand the correct answers.

Question 41: Which SQL clause groups rows that share the same values in specified columns?

a) WHERE

b) ORDER BY

c) GROUP BY

d) DISTINCT

Question 42: What does the term "atomicity" refer to in database transactions?

a) Ensuring data is consistent after a transaction

b) All parts of a transaction must be completed or the entire transaction is aborted

c) Managing data access

d) Rolling back changes

Question 43: Which SQL command undoes changes made to a database since the last commit?

a) DELETE

b) COMMIT

c) ROLLBACK

d) INSERT

Question 44: What is a key feature of a hierarchical database model?

a) Tables organized in a star schema

b) Data organized in an upside-down tree structure

c) Relationships between objects based on inheritance

d) Data stored in distributed locations

Question 45: Which of the following is an advantage of denormalization?

a) Reduces data redundancy

b) Improves query performance by reducing joins

c) Ensures data integrity

d) Simplifies database design

Question 46: Which SQL clause is used to filter rows after an aggregation is applied using GROUP BY?

a) WHERE

b) HAVING

c) DISTINCT

d) ORDER BY

Question 47: Which entity type cannot exist without another related entity?

a) Strong entity

b) Weak entity

c) Recursive entity

d) Multivalued entity

Question 48: What term describes an attribute that does not physically exist within the entity but can be derived?

a) Multivalued attribute

b) Composite attribute

c) Derived attribute

d) Simple attribute

Question 49: What is the purpose of a composite entity?

a) To manage large datasets in distributed databases

b) To transform an M relationship into two 1 relationships

c) To store temporary data for transactions

d) To increase performance by reducing redundancy

Question 50: What does the term "functional dependence" refer to?

a) One attribute determines another

b) An attribute that determines the primary key

c) A table that stores functional data

d) Data access that is independent of storage

Struggling With Exams?

Less Time Studying, More Time Living – Finish Your Degree Faster! Pay-After-you-Pass

Get Exam Support