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

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 21: What is the key characteristic of "structured data"?

a) It is data in its raw form

b) It has been formatted to facilitate storage and information generation

c) It is unprocessed and unformatted

d) It is metadata about other data

Question 22: Which database system function ensures that only authorized users can access specific data?

a) Performance tuning

b) Security management

c) Query language

d) Data independence

Question 23: What type of relationship exists when a single record in one table can be related to multiple records in another table?

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

b) One-to-many (1)

c) Many-to-many (M)

d) Recursive relationship

Question 24: In the context of data warehousing, what is a "data mart"?

a) A small, single-subject data warehouse subset

b) A transactional database for daily operations

c) A cloud-based data storage solution

d) A tool for data mining and analytics

Question 25: What is an entity in the context of databases?

a) A type of data

b) A relationship between tables

c) A person, place, thing, concept, or event for which data can be stored

d) A data anomaly

Question 26: What is the process of transforming raw data into useful information called?

a) Data integrity

b) Data processing

c) Data independence

d) Data redundancy

Question 27: Which SQL command is used to add a new row of data to a table?

a) DELETE

b) UPDATE

c) INSERT

d) SELECT

Question 28: Which attribute type can only have a single value for each entity occurrence?

a) Multivalued attribute

b) Composite attribute

c) Single-valued attribute

d) Derived attribute

Question 29: Which type of query involves a question issued by the end user of a database using SQL?

a) Inner query

b) Subquery

c) Outer query

d) Ad hoc query

Question 30: Which SQL command permanently removes data from a table?

a) DELETE

b) DROP TABLE

c) ALTER TABLE

d) COMMIT

Question 31: What kind of relationship describes a connection between three entities?

a) Binary relationship

b) Unary relationship

c) Ternary relationship

d) Recursive relationship

Question 32: Which type of key is used strictly for data retrieval purposes?

a) Primary key

b) Secondary key

c) Composite key

d) Foreign key

Question 33: What term describes the collection of programs that manages a relational database?

a) SQL engine

b) RDBMS

c) File system

d) Metadata

Question 34: Which of the following best describes the term "data anomaly"?

a) An inconsistency in data caused by redundancy

b) A structured query language

c) A high-performance database engine

d) A method for optimizing database queries

Question 35: Which database management system allows users to manage data using objects, inheritance, and classes?

a) Relational DBMS

b) Object-oriented DBMS

c) Hierarchical DBMS

d) Network DBMS

Question 36: Which of the following is a representation of a relational database's entities, attributes, and relationships?

a) ER model

b) RDBMS

c) OLAP

d) Data dictionary

Question 37: Which SQL command is used to modify the structure of an existing table?

a) ALTER TABLE

b) DROP TABLE

c) UPDATE

d) INSERT

Question 38: What type of attribute can be subdivided into additional attributes?

a) Multivalued attribute

b) Simple attribute

c) Composite attribute

d) Single-valued attribute

Question 39: In a star schema, what type of tables are used to classify or filter facts?

a) Fact tables

b) Dimension tables

c) Lookup tables

d) Index tables

Question 40: What is a NoSQL database primarily designed to handle?

a) Only structured data

b) Only unstructured data

c) Structured and unstructured data

d) Normalized data only

Don't Want to Study?

Save Time on Studies, Spend More with Family & Friends! Pay-After-you-Pass

Get Exam Support