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

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 1: A company requires that their database system be hosted on a service like Microsoft Azure or Amazon AWS. What type of database is most suitable for this?

a) Centralized database

b) Distributed database

c) Cloud database

d) Desktop database

Question 2: What term refers to a situation where the same data is stored unnecessarily in different locations?

a) Data independence

b) Data integrity

c) Data redundancy

d) Data anomaly

Question 3: Which of the following best describes an "ad hoc query"?

a) A scheduled query

b) A complex query

c) A "spur-of-the-moment" question

d) A predefined report

Question 4: Which type of database is typically focused on historical data and business metrics for decision-making?

a) Operational database

b) Analytical database

c) Cloud database

d) Distributed database

Question 5: Which of the following ensures that data remains accurate and consistent in a relational database?

a) Data anomaly

b) Data independence

c) Data redundancy

d) Data integrity

Question 6: What does the term "data independence" refer to?

a) Data is unaffected by changes in storage characteristics

b) Data stored at a single location

c) The ability to change data structures

d) A backup system for databases

Question 7: What term is used to describe a collection of related data stored in a shared, integrated computer structure?

a) Database

b) File

c) Field

d) Record

Question 8: Which database component is responsible for storing metadata and data definitions?

a) Data anomaly

b) Data dictionary

c) Query result set

d) OLAP

Question 9: In which type of relationship does one record in a table correspond to only one record in another table?

a) One-to-one (1:1)

b) One-to-many (1)

c) Many-to-many (M)

d) Recursive

Question 10: What is the primary role of a DBMS (Database Management System)?

a) Managing file systems

b) Controlling data redundancy

c) Managing the database structure and controlling access to the data

d) Providing network security

Question 11: Which of the following describes an OLAP system?

a) A system that handles online transactional processing

b) A decision support system using multidimensional data analysis

c) A system for creating operational databases

d) A database management tool for storing unstructured data

Question 12: What is a key characteristic of a distributed database?

a) Data stored on a single server

b) Data distributed across multiple sites

c) Only supports a single user

d) Is always stored in the cloud

Question 13: Which of the following is a condition in which the database schema affects data access?

a) Data integrity

b) Data dependence

c) Data inconsistency

d) Structural dependence

Question 14: What is the purpose of a primary key in a relational table?

a) It ensures data redundancy

b) It determines data anomalies

c) It uniquely identifies each row in the table

d) It defines the relationship between tables

Question 15: Which of the following is an example of a NoSQL database?

a) A hierarchical database

b) A relational database

c) A database that stores structured and unstructured data

d) A desktop database

Question 16: Which of the following is the result of processing raw data?

a) Information

b) Knowledge

c) Field

d) Metadata

Question 17: Which type of key contains a unique value for every row in a relational table?

a) Foreign key

b) Primary key

c) Composite key

d) Candidate key

Question 18: What term refers to a specific collection of logically related fields?

a) Record

b) Table

c) File

d) Database

Question 19: Which SQL clause is used to limit the rows returned by a query?

a) SELECT

b) GROUP BY

c) WHERE

d) ORDER BY

Question 20: What does a relational database primarily use to relate data in different tables?

a) Foreign keys

b) Primary keys

c) Data redundancy

d) Data anomalies

Need Guaranteed Results?

Don't want to study? Our exam support service guarantees you'll pass your OA on the first attempt. Pay only after you pass!

Get Exam Support