COG220 ACCESS DATA MODEL EXAM NEWEST 2025
ACTUAL EXAM TEST BANK| COMPLETE 350 REAL
EXAM QUESTIONS AND CORRECT VERIFIED ANSWERS/
ALREADY GRADED A+ (BRAND NEW!!)
1. In a relational data model, what is the primary purpose of a
foreign key?
A) To uniquely identify a row in the same table
B) To link to the primary key of another table
C) To store large binary objects
D) To index a text field for fast searching
Correct Answer: B
Rationale: A foreign key is a field (or collection of fields) in one
table that refers to the primary key in another table, creating a
relationship between tables.
2. Which normal form requires that there be no partial
dependencies?
A) 1NF
B) 2NF
1
,C) 3NF
D) BCNF
Correct Answer: B
*Rationale: Second normal form (2NF) eliminates partial
dependencies, meaning all non-key attributes must depend on
the entire primary key, not just part of it.*
3. In Access, which relationship type is implemented by placing a
foreign key in the "many" table?
A) One-to-one
B) One-to-many
C) Many-to-many
D) Self-join
Correct Answer: B
Rationale: In a one-to-many relationship, the foreign key is stored
in the table on the "many" side, referencing the primary key of the
"one" side.
4. What does the "Cascade Delete Related Records" option do
in Access relationships?
2
,A) Deletes all records automatically when you close the
database
B) Prevents deletion of a record if related records exist
C) When you delete a record, deletes all related records in child
tables
D) Archives deleted records to a backup table
Correct Answer: C
Rationale: Cascade Delete automatically removes all related
records in child tables when the parent record is deleted,
maintaining referential integrity.
5. Which query type in Access is used to add new records to a
table based on data from another table?
A) Update query
B) Delete query
C) Make-table query
D) Append query
Correct Answer: D
Rationale: An Append query adds (appends) records from one or
more source tables to the end of a destination table.
3
, 6. A table is in 3NF if it is in 2NF and also has no:
A) Partial dependencies
B) Repeating groups
C) Transitive dependencies
D) Composite primary keys
Correct Answer: C
Rationale: Third normal form eliminates transitive dependencies, in
which non-key attributes depend on other non-key attributes rather
than directly on the primary key.
7. Which Access data type should you use to store up to 255
characters of variable text?
A) Long Text
B) Short Text
C) Memo
D) Char
Correct Answer: B
Rationale: Short Text (formerly Text) stores up to 255 characters.
Long Text (formerly Memo) can store more than 255 characters.
4
ACTUAL EXAM TEST BANK| COMPLETE 350 REAL
EXAM QUESTIONS AND CORRECT VERIFIED ANSWERS/
ALREADY GRADED A+ (BRAND NEW!!)
1. In a relational data model, what is the primary purpose of a
foreign key?
A) To uniquely identify a row in the same table
B) To link to the primary key of another table
C) To store large binary objects
D) To index a text field for fast searching
Correct Answer: B
Rationale: A foreign key is a field (or collection of fields) in one
table that refers to the primary key in another table, creating a
relationship between tables.
2. Which normal form requires that there be no partial
dependencies?
A) 1NF
B) 2NF
1
,C) 3NF
D) BCNF
Correct Answer: B
*Rationale: Second normal form (2NF) eliminates partial
dependencies, meaning all non-key attributes must depend on
the entire primary key, not just part of it.*
3. In Access, which relationship type is implemented by placing a
foreign key in the "many" table?
A) One-to-one
B) One-to-many
C) Many-to-many
D) Self-join
Correct Answer: B
Rationale: In a one-to-many relationship, the foreign key is stored
in the table on the "many" side, referencing the primary key of the
"one" side.
4. What does the "Cascade Delete Related Records" option do
in Access relationships?
2
,A) Deletes all records automatically when you close the
database
B) Prevents deletion of a record if related records exist
C) When you delete a record, deletes all related records in child
tables
D) Archives deleted records to a backup table
Correct Answer: C
Rationale: Cascade Delete automatically removes all related
records in child tables when the parent record is deleted,
maintaining referential integrity.
5. Which query type in Access is used to add new records to a
table based on data from another table?
A) Update query
B) Delete query
C) Make-table query
D) Append query
Correct Answer: D
Rationale: An Append query adds (appends) records from one or
more source tables to the end of a destination table.
3
, 6. A table is in 3NF if it is in 2NF and also has no:
A) Partial dependencies
B) Repeating groups
C) Transitive dependencies
D) Composite primary keys
Correct Answer: C
Rationale: Third normal form eliminates transitive dependencies, in
which non-key attributes depend on other non-key attributes rather
than directly on the primary key.
7. Which Access data type should you use to store up to 255
characters of variable text?
A) Long Text
B) Short Text
C) Memo
D) Char
Correct Answer: B
Rationale: Short Text (formerly Text) stores up to 255 characters.
Long Text (formerly Memo) can store more than 255 characters.
4
