CMIS 351
Management Information Systems Final Exam
Questions & Answers| Guaranteed Pass
1. What is a database management system (DBMS)?
A) A hardware device for storing files
B) Software that allows users to create, manage, and manipulate data in a database
C) A programming language only
D) A type of network protocol
Answer: B
Rationale: A DBMS is software (e.g., Oracle, SQL Server, MySQL) that provides the tools
to define, store, retrieve, update, and administer data in a structured database.
2. What is the primary purpose of a primary key in a relational database table?
A) To encrypt data
B) To uniquely identify each record in a table
C) To sort data alphabetically
D) To reduce file size
Answer: B
Rationale: A primary key is a column (or set of columns) whose value uniquely identifies
each row, preventing duplicate records and enabling reliable references from other
tables.
3. What is a foreign key used for?
A) To link records between two tables by referencing the primary key of another
table
B) To hide sensitive data
C) To create a backup of the table
D) To increase query speed only
Answer: A
Rationale: A foreign key is a field in one table that references the primary key of another
table, establishing and enforcing a relationship between the two.
4. What does "normalization" in database design primarily achieve?
A) Encrypting the database
, B) Reducing data redundancy and improving data integrity by organizing data into
related tables
C) Increasing the physical size of tables
D) Making queries slower
Answer: B
Rationale: Normalization applies a series of rules to decompose tables and eliminate
redundant data, which reduces storage waste and helps prevent update, insert, and
delete anomalies.
5. Which normal form requires that a table have no repeating groups and each column
contain atomic (indivisible) values?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Boyce-Codd Normal Form
Answer: A
Rationale: First Normal Form requires eliminating repeating groups and ensuring each
field holds a single, atomic value, which is the foundational step in the normalization
process.
6. What is a common cause of data redundancy in poorly designed databases?
A) Excessive normalization
B) Storing the same data in multiple places without proper linking
C) Using too many primary keys
D) Using SQL
Answer: B
Rationale: When the same fact is stored in several unlinked locations instead of being
referenced through relationships, redundant copies can become inconsistent and waste
storage.
7. What language is most commonly used to query and manipulate relational
databases?
A) HTML
B) SQL (Structured Query Language)
C) Java
D) Python only
Answer: B
, Rationale: SQL is the standard language for defining, querying, updating, and managing
data in relational database systems.
8. What SQL command is used to retrieve data from a database table?
A) INSERT
B) SELECT
C) DELETE
D) UPDATE
Answer: B
Rationale: The SELECT statement is used to query and retrieve rows and columns of data
from one or more tables.
9. What is an entity-relationship diagram (ERD) used for?
A) To visually represent database tables (entities) and the relationships between
them
B) To design a network topology
C) To document source code
D) To schedule project tasks
Answer: A
Rationale: An ERD models the entities (tables), their attributes, and the relationships
between them, serving as a blueprint for database design.
10. In an ERD, what does a "one-to-many" relationship indicate?
A) One record in a table can be related to many records in another table
B) Two tables cannot be related
C) Every record must have exactly one related record
D) There is no relationship
Answer: A
Rationale: A one-to-many relationship means a single record in one table (e.g., a
customer) can be associated with multiple records in another table (e.g., that customer's
orders).
11. What is a data warehouse primarily used for?
A) Real-time transaction processing only
B) Storing large volumes of historical data from multiple sources for analysis and
reporting
C) Running a company's website
Management Information Systems Final Exam
Questions & Answers| Guaranteed Pass
1. What is a database management system (DBMS)?
A) A hardware device for storing files
B) Software that allows users to create, manage, and manipulate data in a database
C) A programming language only
D) A type of network protocol
Answer: B
Rationale: A DBMS is software (e.g., Oracle, SQL Server, MySQL) that provides the tools
to define, store, retrieve, update, and administer data in a structured database.
2. What is the primary purpose of a primary key in a relational database table?
A) To encrypt data
B) To uniquely identify each record in a table
C) To sort data alphabetically
D) To reduce file size
Answer: B
Rationale: A primary key is a column (or set of columns) whose value uniquely identifies
each row, preventing duplicate records and enabling reliable references from other
tables.
3. What is a foreign key used for?
A) To link records between two tables by referencing the primary key of another
table
B) To hide sensitive data
C) To create a backup of the table
D) To increase query speed only
Answer: A
Rationale: A foreign key is a field in one table that references the primary key of another
table, establishing and enforcing a relationship between the two.
4. What does "normalization" in database design primarily achieve?
A) Encrypting the database
, B) Reducing data redundancy and improving data integrity by organizing data into
related tables
C) Increasing the physical size of tables
D) Making queries slower
Answer: B
Rationale: Normalization applies a series of rules to decompose tables and eliminate
redundant data, which reduces storage waste and helps prevent update, insert, and
delete anomalies.
5. Which normal form requires that a table have no repeating groups and each column
contain atomic (indivisible) values?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Boyce-Codd Normal Form
Answer: A
Rationale: First Normal Form requires eliminating repeating groups and ensuring each
field holds a single, atomic value, which is the foundational step in the normalization
process.
6. What is a common cause of data redundancy in poorly designed databases?
A) Excessive normalization
B) Storing the same data in multiple places without proper linking
C) Using too many primary keys
D) Using SQL
Answer: B
Rationale: When the same fact is stored in several unlinked locations instead of being
referenced through relationships, redundant copies can become inconsistent and waste
storage.
7. What language is most commonly used to query and manipulate relational
databases?
A) HTML
B) SQL (Structured Query Language)
C) Java
D) Python only
Answer: B
, Rationale: SQL is the standard language for defining, querying, updating, and managing
data in relational database systems.
8. What SQL command is used to retrieve data from a database table?
A) INSERT
B) SELECT
C) DELETE
D) UPDATE
Answer: B
Rationale: The SELECT statement is used to query and retrieve rows and columns of data
from one or more tables.
9. What is an entity-relationship diagram (ERD) used for?
A) To visually represent database tables (entities) and the relationships between
them
B) To design a network topology
C) To document source code
D) To schedule project tasks
Answer: A
Rationale: An ERD models the entities (tables), their attributes, and the relationships
between them, serving as a blueprint for database design.
10. In an ERD, what does a "one-to-many" relationship indicate?
A) One record in a table can be related to many records in another table
B) Two tables cannot be related
C) Every record must have exactly one related record
D) There is no relationship
Answer: A
Rationale: A one-to-many relationship means a single record in one table (e.g., a
customer) can be associated with multiple records in another table (e.g., that customer's
orders).
11. What is a data warehouse primarily used for?
A) Real-time transaction processing only
B) Storing large volumes of historical data from multiple sources for analysis and
reporting
C) Running a company's website
