DSS Test 2 QUESTIONS AND ANSWERS
Each intersection of a row and column in a table may contain more than one value. - CORRECT
ANSWER✅✅✅Which of the following is not a characteristic of a healthy relation?
A record is all of the attribute values for one item in an entity. - CORRECT ANSWER✅✅✅Which of
the following sentences explains how entities, attributes, and records work together?
primary key field - CORRECT ANSWER✅✅✅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.
It is the field in the table on the "many" (child) side of a one-to-many relationship. - CORRECT
ANSWER✅✅✅What is the purpose of the foreign key field?
the same row, different rows - CORRECT ANSWER✅✅✅In the query design grid in Access Query
Design View, you place AND criteria on _____, and you place OR criteria on _____.
OR criteria, AND criteria - CORRECT ANSWER✅✅✅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.
MonthlyRate: [AnnualRate] / 12 - CORRECT ANSWER✅✅✅Which of the following is an example of a
computed field?
An aggregate function sums, averages, or counts, for example, the records in a group. - CORRECT
ANSWER✅✅✅Which of the following describes an Access aggregate function?
Use the Sort row and specify the sort fields in a left-to-right order. - CORRECT ANSWER✅✅✅How do
you sort data in Access Query Design View?
, You may not create orphan records by entering a phony foreign key field value in the "many" table. -
CORRECT ANSWER✅✅✅What does it mean to enforce referential integrity on a one-to-many
relationship?
SELECT - CORRECT ANSWER✅✅✅Which of the following types of queries does not change data in
Access?
Relational Algebra - CORRECT ANSWER✅✅✅_____ 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.
DECIMAL - CORRECT ANSWER✅✅✅Which of the following is not an Access SQL data type
| | - CORRECT ANSWER✅✅✅Whichof the following is not a valid comparison operator?
Criteria joined by OR may select more records than if joined by AND - CORRECT
ANSWER✅✅✅Which of the following is true?
A calculated field starts by determining how to group the records - CORRECT ANSWER✅✅✅Which
of the following is not true about computed or calculated field?
BETWEEN - CORRECT ANSWER✅✅✅Which SQL operator can be rewritten with >= AND <=
operators?
IN - CORRECT ANSWER✅✅✅Which SQL operator provides a concise way of creating a condition to
match a specific list of criteria?
SUBTOTAL - CORRECT ANSWER✅✅✅Which of the following is not an aggregate function used to
calculate information on groups of records?
ORDER BY LastName, FirstName - CORRECT ANSWER✅✅✅Which SQL clause sorts the selected
records in ascending order by FirstName within LastName?
Each intersection of a row and column in a table may contain more than one value. - CORRECT
ANSWER✅✅✅Which of the following is not a characteristic of a healthy relation?
A record is all of the attribute values for one item in an entity. - CORRECT ANSWER✅✅✅Which of
the following sentences explains how entities, attributes, and records work together?
primary key field - CORRECT ANSWER✅✅✅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.
It is the field in the table on the "many" (child) side of a one-to-many relationship. - CORRECT
ANSWER✅✅✅What is the purpose of the foreign key field?
the same row, different rows - CORRECT ANSWER✅✅✅In the query design grid in Access Query
Design View, you place AND criteria on _____, and you place OR criteria on _____.
OR criteria, AND criteria - CORRECT ANSWER✅✅✅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.
MonthlyRate: [AnnualRate] / 12 - CORRECT ANSWER✅✅✅Which of the following is an example of a
computed field?
An aggregate function sums, averages, or counts, for example, the records in a group. - CORRECT
ANSWER✅✅✅Which of the following describes an Access aggregate function?
Use the Sort row and specify the sort fields in a left-to-right order. - CORRECT ANSWER✅✅✅How do
you sort data in Access Query Design View?
, You may not create orphan records by entering a phony foreign key field value in the "many" table. -
CORRECT ANSWER✅✅✅What does it mean to enforce referential integrity on a one-to-many
relationship?
SELECT - CORRECT ANSWER✅✅✅Which of the following types of queries does not change data in
Access?
Relational Algebra - CORRECT ANSWER✅✅✅_____ 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.
DECIMAL - CORRECT ANSWER✅✅✅Which of the following is not an Access SQL data type
| | - CORRECT ANSWER✅✅✅Whichof the following is not a valid comparison operator?
Criteria joined by OR may select more records than if joined by AND - CORRECT
ANSWER✅✅✅Which of the following is true?
A calculated field starts by determining how to group the records - CORRECT ANSWER✅✅✅Which
of the following is not true about computed or calculated field?
BETWEEN - CORRECT ANSWER✅✅✅Which SQL operator can be rewritten with >= AND <=
operators?
IN - CORRECT ANSWER✅✅✅Which SQL operator provides a concise way of creating a condition to
match a specific list of criteria?
SUBTOTAL - CORRECT ANSWER✅✅✅Which of the following is not an aggregate function used to
calculate information on groups of records?
ORDER BY LastName, FirstName - CORRECT ANSWER✅✅✅Which SQL clause sorts the selected
records in ascending order by FirstName within LastName?
