BUS 5114 Management Information Systems Unit 3 Graded Quiz
— 25 Q&A Verified Answers 2025
Course:
BUS 5114 Management Information Systems — University of the People (UoPeople)
Level:
MBA
Year:
2025/2026
Format:
Graded Quiz Solutions — 25 Q&A with Verified Answers
BUS 5114 Unit 3 Graded Quiz — Database Management Systems
25 Questions with Verified Answers | Score: 96/100
Question 1:
Which of the following best defines a Database Management System (DBMS)?
A) A programming language used exclusively to build websites
B) Software that enables users to define, create, maintain, and control access to a database
C) A hardware device used to store large volumes of structured data
D) A spreadsheet application designed for financial modeling
Answer: B
Explanation:
A DBMS is software that serves as an intermediary between users, applications, and the physical
database, providing tools to define structures, store data, retrieve it efficiently, and enforce
security. Options A and C confuse the software nature of a DBMS with web development or
hardware. Option D describes a spreadsheet tool, which lacks the multi-user concurrency,
transaction management, and query optimization capabilities of a true DBMS.
Question 2:
, In a relational database, what is the primary purpose of a primary key?
A) To encrypt sensitive data stored in a table
B) To link two tables through a shared attribute
C) To uniquely identify each record within a table
D) To define the data type of each column in a table
Answer: C
Explanation:
A primary key is a column (or combination of columns) whose values are unique and non-null for
every row, ensuring each record can be unambiguously identified. Option B describes a foreign
key relationship, not a primary key. Option A describes encryption, which is a separate security
mechanism. Option D describes schema definition, a different database function.
Question 3:
A foreign key in a relational database serves which of the following functions?
A) It speeds up query performance by indexing frequently searched columns
B) It establishes a referential link between two tables, enforcing data integrity
C) It automatically generates sequential values for new records
D) It restricts the number of rows that can be inserted into a table
Answer: B
Explanation:
A foreign key is an attribute in one table that references the primary key of another table, thereby
enforcing referential integrity and formally defining relationships between entities. Option A
describes database indexing. Option C describes an auto-increment or sequence feature. Option
D has no standard database equivalent — row limits are a storage or architectural concern, not a
foreign key function.
Question 4:
Which SQL command is used to retrieve data from one or more tables?
A) INSERT
B) UPDATE
C) SELECT
— 25 Q&A Verified Answers 2025
Course:
BUS 5114 Management Information Systems — University of the People (UoPeople)
Level:
MBA
Year:
2025/2026
Format:
Graded Quiz Solutions — 25 Q&A with Verified Answers
BUS 5114 Unit 3 Graded Quiz — Database Management Systems
25 Questions with Verified Answers | Score: 96/100
Question 1:
Which of the following best defines a Database Management System (DBMS)?
A) A programming language used exclusively to build websites
B) Software that enables users to define, create, maintain, and control access to a database
C) A hardware device used to store large volumes of structured data
D) A spreadsheet application designed for financial modeling
Answer: B
Explanation:
A DBMS is software that serves as an intermediary between users, applications, and the physical
database, providing tools to define structures, store data, retrieve it efficiently, and enforce
security. Options A and C confuse the software nature of a DBMS with web development or
hardware. Option D describes a spreadsheet tool, which lacks the multi-user concurrency,
transaction management, and query optimization capabilities of a true DBMS.
Question 2:
, In a relational database, what is the primary purpose of a primary key?
A) To encrypt sensitive data stored in a table
B) To link two tables through a shared attribute
C) To uniquely identify each record within a table
D) To define the data type of each column in a table
Answer: C
Explanation:
A primary key is a column (or combination of columns) whose values are unique and non-null for
every row, ensuring each record can be unambiguously identified. Option B describes a foreign
key relationship, not a primary key. Option A describes encryption, which is a separate security
mechanism. Option D describes schema definition, a different database function.
Question 3:
A foreign key in a relational database serves which of the following functions?
A) It speeds up query performance by indexing frequently searched columns
B) It establishes a referential link between two tables, enforcing data integrity
C) It automatically generates sequential values for new records
D) It restricts the number of rows that can be inserted into a table
Answer: B
Explanation:
A foreign key is an attribute in one table that references the primary key of another table, thereby
enforcing referential integrity and formally defining relationships between entities. Option A
describes database indexing. Option C describes an auto-increment or sequence feature. Option
D has no standard database equivalent — row limits are a storage or architectural concern, not a
foreign key function.
Question 4:
Which SQL command is used to retrieve data from one or more tables?
A) INSERT
B) UPDATE
C) SELECT
