ISTM 210 FINAL EXAM LATEST COMPLETE 200 ACTUAL EXAM
QUESTIONS WITH 100% CORRECT VERIFIED ANSWERS AND
RATIONALES | GRADED A+ BRAND NEW 2026 EDITION | ISTM
210 INFORMATION SYSTEMS & TECHNOLOGY MANAGEMENT
LATEST UPDATE
INSTRUCTIONS: This comprehensive final exam covers all major topics for ISTM 210 including: Data &
Information Management, Database Concepts, Cloud Computing, Networking, Hardware & Software,
Security & Privacy, Business Processes, E-Commerce, Enterprise Systems, Decision Support, and Emerging
Technologies. Each question includes the correct answer and a detailed rationale to enhance
understanding and exam preparation.
SECTION 1: DATA & INFORMATION MANAGEMENT (Qs 1–20)
Q1: What are the different types of attributes?
A) Simple vs. Composite, Single vs. Multivalued, Stored vs. Derived, and Null
B) Primary vs. Secondary, Internal vs. External, Static vs. Dynamic
C) Text vs. Numeric, Date vs. Time, Binary vs. Character
D) Mandatory vs. Optional, Unique vs. Non-Unique, Indexed vs. Non-Indexed
Answer: A) Simple vs. Composite, Single vs. Multivalued, Stored vs. Derived,
and Null
Rationale: In database management, attributes are classified into four main
types: Simple (atomic) vs. Composite (composed of smaller parts), Single-valued
(one value) vs. Multivalued (multiple values), Stored (physically stored) vs.
Derived (calculated from other attributes), and Null (no value). These
classifications help in database design and normalization.
Q2: A simple attribute is one that:
A) Can be divided into smaller meaningful parts
1
,B) Cannot be divided into smaller meaningful parts
C) Has multiple values
D) Is calculated from other attributes
Answer: B) Cannot be divided into smaller meaningful parts
Rationale: A simple attribute (also called atomic attribute) cannot be further
subdivided into meaningful components. For example, "Age" is a simple attribute
because it cannot be broken down, whereas "Name" is composite because it can
be broken into first name and last name.
Q3: A composite attribute is one that:
A) Cannot be divided into smaller meaningful parts
B) Can be divided into smaller meaningful parts
C) Has only one value
D) Is derived from other attributes
Answer: B) Can be divided into smaller meaningful parts
Rationale: A composite attribute can be broken down into smaller meaningful
sub-parts. For example, "Address" is composite because it can be broken into
street, city, state, and zip code. "Name" is also composite (first name, last
name).
Q4: Which of the following is an example of a multivalued attribute?
A) Date of birth
B) Phone number (where a person can have multiple phone numbers)
C) Social Security Number
D) First name
Answer: B) Phone number (where a person can have multiple phone numbers)
2
,Rationale: A multivalued attribute can have more than one value for a single
entity instance. For example, a person can have multiple phone numbers (home,
work, mobile). Date of birth, SSN, and first name are single-valued attributes
because each person has only one of each.
Q5: Which of the following is an example of a derived attribute?
A) Date of birth
B) Age (calculated from date of birth)
C) Social Security Number
D) First name
Answer: B) Age (calculated from date of birth)
Rationale: A derived attribute is one whose value is calculated or derived
from other attributes. Age is derived from Date of Birth and the current date.
Derived attributes are not physically stored in the database; they are computed
when needed.
Q6: What does a "null" attribute value indicate?
A) The attribute has a value of zero
B) The attribute has no value or is unknown
C) The attribute is a primary key
D) The attribute is derived from other attributes
Answer: B) The attribute has no value or is unknown
Rationale: A null value indicates that the attribute has no value or that the
value is unknown. It is not the same as zero or an empty string. Null values
are important in database design and require careful handling in queries and
applications.
3
, Q7: What is the primary key of a database table?
A) An attribute that uniquely identifies each record in the table
B) An attribute that can have multiple values
C) An attribute that is derived from other attributes
D) An attribute that can be null
Answer: A) An attribute that uniquely identifies each record in the table
Rationale: A primary key is an attribute (or set of attributes) that uniquely
identifies each record (row) in a database table. It must have unique values
for each record and cannot contain null values. It is used to enforce entity
integrity and to create relationships between tables.
Q8: A foreign key is:
A) An attribute that uniquely identifies each record
B) An attribute in one table that refers to the primary key of another table
C) An attribute that can have multiple values
D) An attribute that is derived from other attributes
Answer: B) An attribute in one table that refers to the primary key of another
table
Rationale: A foreign key is an attribute (or set of attributes) in one table
that refers to the primary key of another table. It establishes a relationship
between the two tables and enforces referential integrity, ensuring that values
in the foreign key match existing values in the referenced primary key.
Q9: What is the purpose of normalization in database design?
A) To increase data redundancy
4
QUESTIONS WITH 100% CORRECT VERIFIED ANSWERS AND
RATIONALES | GRADED A+ BRAND NEW 2026 EDITION | ISTM
210 INFORMATION SYSTEMS & TECHNOLOGY MANAGEMENT
LATEST UPDATE
INSTRUCTIONS: This comprehensive final exam covers all major topics for ISTM 210 including: Data &
Information Management, Database Concepts, Cloud Computing, Networking, Hardware & Software,
Security & Privacy, Business Processes, E-Commerce, Enterprise Systems, Decision Support, and Emerging
Technologies. Each question includes the correct answer and a detailed rationale to enhance
understanding and exam preparation.
SECTION 1: DATA & INFORMATION MANAGEMENT (Qs 1–20)
Q1: What are the different types of attributes?
A) Simple vs. Composite, Single vs. Multivalued, Stored vs. Derived, and Null
B) Primary vs. Secondary, Internal vs. External, Static vs. Dynamic
C) Text vs. Numeric, Date vs. Time, Binary vs. Character
D) Mandatory vs. Optional, Unique vs. Non-Unique, Indexed vs. Non-Indexed
Answer: A) Simple vs. Composite, Single vs. Multivalued, Stored vs. Derived,
and Null
Rationale: In database management, attributes are classified into four main
types: Simple (atomic) vs. Composite (composed of smaller parts), Single-valued
(one value) vs. Multivalued (multiple values), Stored (physically stored) vs.
Derived (calculated from other attributes), and Null (no value). These
classifications help in database design and normalization.
Q2: A simple attribute is one that:
A) Can be divided into smaller meaningful parts
1
,B) Cannot be divided into smaller meaningful parts
C) Has multiple values
D) Is calculated from other attributes
Answer: B) Cannot be divided into smaller meaningful parts
Rationale: A simple attribute (also called atomic attribute) cannot be further
subdivided into meaningful components. For example, "Age" is a simple attribute
because it cannot be broken down, whereas "Name" is composite because it can
be broken into first name and last name.
Q3: A composite attribute is one that:
A) Cannot be divided into smaller meaningful parts
B) Can be divided into smaller meaningful parts
C) Has only one value
D) Is derived from other attributes
Answer: B) Can be divided into smaller meaningful parts
Rationale: A composite attribute can be broken down into smaller meaningful
sub-parts. For example, "Address" is composite because it can be broken into
street, city, state, and zip code. "Name" is also composite (first name, last
name).
Q4: Which of the following is an example of a multivalued attribute?
A) Date of birth
B) Phone number (where a person can have multiple phone numbers)
C) Social Security Number
D) First name
Answer: B) Phone number (where a person can have multiple phone numbers)
2
,Rationale: A multivalued attribute can have more than one value for a single
entity instance. For example, a person can have multiple phone numbers (home,
work, mobile). Date of birth, SSN, and first name are single-valued attributes
because each person has only one of each.
Q5: Which of the following is an example of a derived attribute?
A) Date of birth
B) Age (calculated from date of birth)
C) Social Security Number
D) First name
Answer: B) Age (calculated from date of birth)
Rationale: A derived attribute is one whose value is calculated or derived
from other attributes. Age is derived from Date of Birth and the current date.
Derived attributes are not physically stored in the database; they are computed
when needed.
Q6: What does a "null" attribute value indicate?
A) The attribute has a value of zero
B) The attribute has no value or is unknown
C) The attribute is a primary key
D) The attribute is derived from other attributes
Answer: B) The attribute has no value or is unknown
Rationale: A null value indicates that the attribute has no value or that the
value is unknown. It is not the same as zero or an empty string. Null values
are important in database design and require careful handling in queries and
applications.
3
, Q7: What is the primary key of a database table?
A) An attribute that uniquely identifies each record in the table
B) An attribute that can have multiple values
C) An attribute that is derived from other attributes
D) An attribute that can be null
Answer: A) An attribute that uniquely identifies each record in the table
Rationale: A primary key is an attribute (or set of attributes) that uniquely
identifies each record (row) in a database table. It must have unique values
for each record and cannot contain null values. It is used to enforce entity
integrity and to create relationships between tables.
Q8: A foreign key is:
A) An attribute that uniquely identifies each record
B) An attribute in one table that refers to the primary key of another table
C) An attribute that can have multiple values
D) An attribute that is derived from other attributes
Answer: B) An attribute in one table that refers to the primary key of another
table
Rationale: A foreign key is an attribute (or set of attributes) in one table
that refers to the primary key of another table. It establishes a relationship
between the two tables and enforces referential integrity, ensuring that values
in the foreign key match existing values in the referenced primary key.
Q9: What is the purpose of normalization in database design?
A) To increase data redundancy
4
