ITE 152 EXAM 3 PRACTICE TEST 2026: COMPREHENSIVE
DATABASE MANAGEMENT CONCEPTS WITH MICROSOFT
ACCESS AND SQL - 195 QUESTIONS WITH CORRECT
ANSWERS AND DETAILED RATIONALES
Question 1
Which of the following is NOT a valid reason for using a relational
database management system?
A) Data redundancy is minimized
B) Data integrity is enforced
C) Data is stored in a single large file for easy access
D) Data can be easily queried and reported
E) Data security can be managed effectively
Correct Answer: C) Data is stored in a single large file for easy access
Rationale: Relational databases store data across multiple related tables
to minimize redundancy, not in a single large file. This structure allows
for efficient data management, integrity, and complex querying, which
are key advantages over flat-file systems.
Question 2
A table named "Orders" has a field called "OrderDate." Which data type
is most appropriate for this field?
A) Text
B) Number
,C) Date/Time
D) Currency
E) Yes/No
Correct Answer: C) Date/Time
Rationale: The Date/Time data type is specifically designed to store
dates and times, allowing for accurate sorting, calculations (like age or
days between orders), and proper formatting. Using Text would prevent
date-based functions from working correctly.
Question 3
In Access, which view allows you to define or modify the structure of a
table, such as adding or deleting fields?
A) Datasheet View
B) PivotTable View
C) Design View
D) Layout View
E) Print Preview
Correct Answer: C) Design View
Rationale: Design View is the interface used to create and modify the
structure of a database object, such as a table, query, form, or report. It
is where you set field names, data types, and properties, unlike
Datasheet View which is for viewing and entering data.
Question 4
Which field would be the most suitable primary key for a "Students"
table in a school database?
,A) FirstName
B) LastName
C) PhoneNumber
D) StudentID
E) DateOfBirth
Correct Answer: D) StudentID
Rationale: A primary key must uniquely identify each record. StudentID
is a unique identifier assigned to each student, ensuring no duplicates.
FirstName, LastName, or DateOfBirth can be shared by multiple
students and are therefore not reliable as unique identifiers.
Question 5
A database administrator wants to ensure that no two employees have
the same email address. What database feature should they use?
A) Primary Key
B) Index (No Duplicates)
C) Filter
D) Relationship
E) Report
Correct Answer: B) Index (No Duplicates)
Rationale: While a primary key also enforces uniqueness, an index with
the "No Duplicates" property can be applied to any field, like
EmailAddress, to prevent duplicate entries. This ensures data integrity
without requiring the field to be the table's primary key.
, Question 6
Which of the following is an example of a one-to-many relationship?
A) A customer has many orders
B) A student has one transcript
C) A person has one Social Security Number
D) A product has one supplier
E) An employee has one manager
Correct Answer: A) A customer has many orders
Rationale: A one-to-many relationship is the most common type in
relational databases. One record in a table (e.g., a single customer) can
be related to many records in another table (e.g., many orders placed
by that customer).
Question 7
Which SQL command is used to retrieve data from a database?
A) INSERT
B) UPDATE
C) DELETE
D) SELECT
E) CREATE
Correct Answer: D) SELECT
Rationale: The SELECT statement is the fundamental SQL command for
querying the database. It specifies which fields and records to retrieve,
and it can include conditions to filter the results. INSERT, UPDATE, and
DELETE are used to modify data.
DATABASE MANAGEMENT CONCEPTS WITH MICROSOFT
ACCESS AND SQL - 195 QUESTIONS WITH CORRECT
ANSWERS AND DETAILED RATIONALES
Question 1
Which of the following is NOT a valid reason for using a relational
database management system?
A) Data redundancy is minimized
B) Data integrity is enforced
C) Data is stored in a single large file for easy access
D) Data can be easily queried and reported
E) Data security can be managed effectively
Correct Answer: C) Data is stored in a single large file for easy access
Rationale: Relational databases store data across multiple related tables
to minimize redundancy, not in a single large file. This structure allows
for efficient data management, integrity, and complex querying, which
are key advantages over flat-file systems.
Question 2
A table named "Orders" has a field called "OrderDate." Which data type
is most appropriate for this field?
A) Text
B) Number
,C) Date/Time
D) Currency
E) Yes/No
Correct Answer: C) Date/Time
Rationale: The Date/Time data type is specifically designed to store
dates and times, allowing for accurate sorting, calculations (like age or
days between orders), and proper formatting. Using Text would prevent
date-based functions from working correctly.
Question 3
In Access, which view allows you to define or modify the structure of a
table, such as adding or deleting fields?
A) Datasheet View
B) PivotTable View
C) Design View
D) Layout View
E) Print Preview
Correct Answer: C) Design View
Rationale: Design View is the interface used to create and modify the
structure of a database object, such as a table, query, form, or report. It
is where you set field names, data types, and properties, unlike
Datasheet View which is for viewing and entering data.
Question 4
Which field would be the most suitable primary key for a "Students"
table in a school database?
,A) FirstName
B) LastName
C) PhoneNumber
D) StudentID
E) DateOfBirth
Correct Answer: D) StudentID
Rationale: A primary key must uniquely identify each record. StudentID
is a unique identifier assigned to each student, ensuring no duplicates.
FirstName, LastName, or DateOfBirth can be shared by multiple
students and are therefore not reliable as unique identifiers.
Question 5
A database administrator wants to ensure that no two employees have
the same email address. What database feature should they use?
A) Primary Key
B) Index (No Duplicates)
C) Filter
D) Relationship
E) Report
Correct Answer: B) Index (No Duplicates)
Rationale: While a primary key also enforces uniqueness, an index with
the "No Duplicates" property can be applied to any field, like
EmailAddress, to prevent duplicate entries. This ensures data integrity
without requiring the field to be the table's primary key.
, Question 6
Which of the following is an example of a one-to-many relationship?
A) A customer has many orders
B) A student has one transcript
C) A person has one Social Security Number
D) A product has one supplier
E) An employee has one manager
Correct Answer: A) A customer has many orders
Rationale: A one-to-many relationship is the most common type in
relational databases. One record in a table (e.g., a single customer) can
be related to many records in another table (e.g., many orders placed
by that customer).
Question 7
Which SQL command is used to retrieve data from a database?
A) INSERT
B) UPDATE
C) DELETE
D) SELECT
E) CREATE
Correct Answer: D) SELECT
Rationale: The SELECT statement is the fundamental SQL command for
querying the database. It specifies which fields and records to retrieve,
and it can include conditions to filter the results. INSERT, UPDATE, and
DELETE are used to modify data.
