WGU c170 Bundled Docs with complete solution
This unit covers core concepts including databases, DBMS, relational models, domains, tuples,
and basic data structures.
Question 1:
What is a database?
A) A collection of interrelated data stored together without organization
B) A software application for querying data
C) An organized collection of structured information or data typically stored electronically in a
computer system
D) A hardware device for storing physical files
Correct Answer: C
Explanation: A database is defined as an organized collection of structured data, distinguishing
it from unorganized file systems. This aligns with relational model principles where data is
systematically arranged for efficient access and management.
Question 2:
In database terminology, what is a domain?
A) A set of possible values for an attribute
B) A complete database schema
C) A type of SQL query
D) A foreign key relationship
Correct Answer: A
Explanation: A domain specifies the set of allowable values for an attribute, ensuring data
consistency (e.g., integers from 1-100 for ages). This is foundational for data integrity in
relational databases.
Question 3:
What is a tuple in a relational database?
A) A column in a table
B) A row in a table, representing a single record
C) A unique identifier for a table
D) An aggregate function
Correct Answer: B
,Explanation: A tuple is a finite sequence of values representing one record (row) in a relation,
drawn from predefined domains, as per the relational model.
Question 4:
Which component of a DBMS is responsible for handling concurrent access to the database?
A) Query Processor
B) Storage Manager
C) Transaction Manager
D) Data Dictionary
Correct Answer: C
Explanation: The Transaction Manager ensures concurrency control, preventing issues like lost
updates through locking and isolation levels.
Question 5:
What does DBMS stand for?
A) Data Base Management System
B) Database Management Software
C) Database Management System
D) Digital Base Management System
Correct Answer: C
Explanation: DBMS refers to the software that interacts with users, applications, and the
database to capture and analyze data, providing tools for creation, maintenance, and querying.
Question 6:
In the relational model, what is a relation?
A) A physical storage device
B) A table with rows and columns, adhering to mathematical set theory
C) A type of index
D) A backup mechanism
Correct Answer: B
Explanation: A relation is the formal term for a table in the relational model, where each row is
a tuple and columns are attributes, ensuring no duplicate rows.
Question 7:
What is the purpose of a data dictionary in a DBMS?
A) To store actual user data
B) To store metadata about the database structure
, C) To execute SQL queries
D) To optimize query performance
Correct Answer: B
Explanation: The data dictionary (or system catalog) holds metadata like table definitions,
constraints, and indexes, aiding in database administration.
Question 8:
Which of the following is NOT a component of the relational model?
A) Data Structure
B) Integrity Rules
C) Manipulative Operations (e.g., SQL)
D) Graphical User Interface
Correct Answer: D
Explanation: The relational model consists of data structure (relations), integrity rules (entity
and referential), and operations; GUI is a user interface feature, not core to the model.
Question 9:
What is a schema in database terms?
A) A specific query language
B) The logical structure or blueprint of the database
C) A type of data encryption
D) A backup file format
Correct Answer: B
Explanation: A schema defines the database's organization, including tables, attributes,
relationships, and constraints, separate from the physical storage.
Question 10:
Which term describes a named set of possible database values, such as integers or strings?
A) Tuple
B) Relation
C) Domain
D) Key
Correct Answer: C
Explanation: Domains enforce data types and ranges, ensuring attributes hold valid values, as
outlined in the relational model's data structure component.
This unit covers core concepts including databases, DBMS, relational models, domains, tuples,
and basic data structures.
Question 1:
What is a database?
A) A collection of interrelated data stored together without organization
B) A software application for querying data
C) An organized collection of structured information or data typically stored electronically in a
computer system
D) A hardware device for storing physical files
Correct Answer: C
Explanation: A database is defined as an organized collection of structured data, distinguishing
it from unorganized file systems. This aligns with relational model principles where data is
systematically arranged for efficient access and management.
Question 2:
In database terminology, what is a domain?
A) A set of possible values for an attribute
B) A complete database schema
C) A type of SQL query
D) A foreign key relationship
Correct Answer: A
Explanation: A domain specifies the set of allowable values for an attribute, ensuring data
consistency (e.g., integers from 1-100 for ages). This is foundational for data integrity in
relational databases.
Question 3:
What is a tuple in a relational database?
A) A column in a table
B) A row in a table, representing a single record
C) A unique identifier for a table
D) An aggregate function
Correct Answer: B
,Explanation: A tuple is a finite sequence of values representing one record (row) in a relation,
drawn from predefined domains, as per the relational model.
Question 4:
Which component of a DBMS is responsible for handling concurrent access to the database?
A) Query Processor
B) Storage Manager
C) Transaction Manager
D) Data Dictionary
Correct Answer: C
Explanation: The Transaction Manager ensures concurrency control, preventing issues like lost
updates through locking and isolation levels.
Question 5:
What does DBMS stand for?
A) Data Base Management System
B) Database Management Software
C) Database Management System
D) Digital Base Management System
Correct Answer: C
Explanation: DBMS refers to the software that interacts with users, applications, and the
database to capture and analyze data, providing tools for creation, maintenance, and querying.
Question 6:
In the relational model, what is a relation?
A) A physical storage device
B) A table with rows and columns, adhering to mathematical set theory
C) A type of index
D) A backup mechanism
Correct Answer: B
Explanation: A relation is the formal term for a table in the relational model, where each row is
a tuple and columns are attributes, ensuring no duplicate rows.
Question 7:
What is the purpose of a data dictionary in a DBMS?
A) To store actual user data
B) To store metadata about the database structure
, C) To execute SQL queries
D) To optimize query performance
Correct Answer: B
Explanation: The data dictionary (or system catalog) holds metadata like table definitions,
constraints, and indexes, aiding in database administration.
Question 8:
Which of the following is NOT a component of the relational model?
A) Data Structure
B) Integrity Rules
C) Manipulative Operations (e.g., SQL)
D) Graphical User Interface
Correct Answer: D
Explanation: The relational model consists of data structure (relations), integrity rules (entity
and referential), and operations; GUI is a user interface feature, not core to the model.
Question 9:
What is a schema in database terms?
A) A specific query language
B) The logical structure or blueprint of the database
C) A type of data encryption
D) A backup file format
Correct Answer: B
Explanation: A schema defines the database's organization, including tables, attributes,
relationships, and constraints, separate from the physical storage.
Question 10:
Which term describes a named set of possible database values, such as integers or strings?
A) Tuple
B) Relation
C) Domain
D) Key
Correct Answer: C
Explanation: Domains enforce data types and ranges, ensuring attributes hold valid values, as
outlined in the relational model's data structure component.
