DSS TEST 2 (2024/25) QUESTIONS WITH
COMPLETE SOLUTIONS!!
Which of the following is not a characteristic of a healthy relation? Answer -
Each intersection of a row and column in a table may contain more than one
value.
Which of the following sentences explains how entities, attributes, and records
work together? Answer - A record is all of the attribute values for one item in
an entity.
The _____ contains values that uniquely identify each record in a table and
serves as the linking field in the table on the "one" (parent) side of a one-to-
many relationship. Answer - primary key field
What is the purpose of the foreign key field? Answer - It is the field in the table
on the "many" (child) side of a one-to-many relationship.
In the query design grid in Access Query Design View, you place AND criteria on
_____, and you place OR criteria on _____. Answer - the same row, different
rows
With _____, only one criterion must evaluate true in order for a record to be
selected and with _____, all criteria must be evaluate true in order for a record
to be selected. Answer - OR criteria, AND criteria
Which of the following is an example of a computed field? Answer -
MonthlyRate: [AnnualRate] / 12
, Which of the following describes an Access aggregate function? Answer - An
aggregate function sums, averages, or counts, for example, the records in a
group.
How do you sort data in Access Query Design View? Answer - Use the Sort row
and specify the sort fields in a left-to-right order.
What does it mean to enforce referential integrity on a one-to-many
relationship? Answer - You may not create orphan records by entering a phony
foreign key field value in the "many" table.
Which of the following types of queries does not change data in Access?
Answer - SELECT
_____ forms the foundational knowledge for SQL, Structured Query Language,
which is the most popular way developers select, edit, and add data to a
relational database. Answer - Relational Algebra
Which of the following is not an Access SQL data type Answer - DECIMAL
Whichof the following is not a valid comparison operator? Answer - | |
Which of the following is true? Answer - Criteria joined by OR may select more
records than if joined by AND
Which of the following is not true about computed or calculated field? Answer
- A calculated field starts by determining how to group the records
COMPLETE SOLUTIONS!!
Which of the following is not a characteristic of a healthy relation? Answer -
Each intersection of a row and column in a table may contain more than one
value.
Which of the following sentences explains how entities, attributes, and records
work together? Answer - A record is all of the attribute values for one item in
an entity.
The _____ contains values that uniquely identify each record in a table and
serves as the linking field in the table on the "one" (parent) side of a one-to-
many relationship. Answer - primary key field
What is the purpose of the foreign key field? Answer - It is the field in the table
on the "many" (child) side of a one-to-many relationship.
In the query design grid in Access Query Design View, you place AND criteria on
_____, and you place OR criteria on _____. Answer - the same row, different
rows
With _____, only one criterion must evaluate true in order for a record to be
selected and with _____, all criteria must be evaluate true in order for a record
to be selected. Answer - OR criteria, AND criteria
Which of the following is an example of a computed field? Answer -
MonthlyRate: [AnnualRate] / 12
, Which of the following describes an Access aggregate function? Answer - An
aggregate function sums, averages, or counts, for example, the records in a
group.
How do you sort data in Access Query Design View? Answer - Use the Sort row
and specify the sort fields in a left-to-right order.
What does it mean to enforce referential integrity on a one-to-many
relationship? Answer - You may not create orphan records by entering a phony
foreign key field value in the "many" table.
Which of the following types of queries does not change data in Access?
Answer - SELECT
_____ forms the foundational knowledge for SQL, Structured Query Language,
which is the most popular way developers select, edit, and add data to a
relational database. Answer - Relational Algebra
Which of the following is not an Access SQL data type Answer - DECIMAL
Whichof the following is not a valid comparison operator? Answer - | |
Which of the following is true? Answer - Criteria joined by OR may select more
records than if joined by AND
Which of the following is not true about computed or calculated field? Answer
- A calculated field starts by determining how to group the records
