11/14/24, 6:12 PM DSS Test 2 |2024-2025 UPDATE|COMPREHENSIVE QUESTIONS AND VERIFIED ANSWERS (frequent most tested questio…
DSS Test 2 |2024-2025
UPDATE|COMPREHENSIVE QUESTIONS AND
VERIFIED ANSWERS (frequent most tested
questions)GET IT 100% ACCURATE!!
Practice questions for this set
Learn 1 /7 Study with Learn
Which of the following is not a characteristic of a healthy relation?
Give this one a try later!
It is the field in the table on the SELECT LastName, StreetAddress
1 "many" (child) side of a one-to- 2 FROM Customers WHERE
many relationship. StreetAddress LIKE "Negley";
Each intersection of a row and
column in a table may contain 4 MonthlyRate: [AnnualRate] / 12
more than one value.
Don't know?
Terms in this set (82)
https://quizlet.com/971469094/dss-test-2-2024-2025-updatecomprehensive-questions-and-verified-answers-frequent-most-tested-questionsget-it… 1/12
, 11/14/24, 6:12 PM DSS Test 2 |2024-2025 UPDATE|COMPREHENSIVE QUESTIONS AND VERIFIED ANSWERS (frequent most tested questio…
Each intersection of a Which of the following is not a characteristic of a
row and column in a healthy relation?
table may contain more
than one value.
A record is all of the Which of the following sentences explains how
attribute values for one entities, attributes, and records work together?
item in an entity.
The _____ contains values that uniquely identify each
record in a table and serves as the linking field in the
primary key field
table on the "one" (parent) side of a one-to-many
relationship.
It is the field in the table What is the purpose of the foreign key field?
on the "many" (child) side
of a one-to-many
relationship.
In the query design grid in Access Query Design
the same row, different
View, you place AND criteria on _____, and you place
rows
OR criteria on _____.
With _____, only one criterion must evaluate true in
order for a record to be selected and with _____, all
OR criteria, AND criteria
criteria must be evaluate true in order for a record
to be selected.
MonthlyRate: Which of the following is an example of a computed
[AnnualRate] / 12 field?
An aggregate function Which of the following describes an Access
sums, averages, or aggregate function?
counts, for example, the
records in a group.
Use the Sort row and How do you sort data in Access Query Design
specify the sort fields in a View?
left-to-right order.
https://quizlet.com/971469094/dss-test-2-2024-2025-updatecomprehensive-questions-and-verified-answers-frequent-most-tested-questionsget-it… 2/12
DSS Test 2 |2024-2025
UPDATE|COMPREHENSIVE QUESTIONS AND
VERIFIED ANSWERS (frequent most tested
questions)GET IT 100% ACCURATE!!
Practice questions for this set
Learn 1 /7 Study with Learn
Which of the following is not a characteristic of a healthy relation?
Give this one a try later!
It is the field in the table on the SELECT LastName, StreetAddress
1 "many" (child) side of a one-to- 2 FROM Customers WHERE
many relationship. StreetAddress LIKE "Negley";
Each intersection of a row and
column in a table may contain 4 MonthlyRate: [AnnualRate] / 12
more than one value.
Don't know?
Terms in this set (82)
https://quizlet.com/971469094/dss-test-2-2024-2025-updatecomprehensive-questions-and-verified-answers-frequent-most-tested-questionsget-it… 1/12
, 11/14/24, 6:12 PM DSS Test 2 |2024-2025 UPDATE|COMPREHENSIVE QUESTIONS AND VERIFIED ANSWERS (frequent most tested questio…
Each intersection of a Which of the following is not a characteristic of a
row and column in a healthy relation?
table may contain more
than one value.
A record is all of the Which of the following sentences explains how
attribute values for one entities, attributes, and records work together?
item in an entity.
The _____ contains values that uniquely identify each
record in a table and serves as the linking field in the
primary key field
table on the "one" (parent) side of a one-to-many
relationship.
It is the field in the table What is the purpose of the foreign key field?
on the "many" (child) side
of a one-to-many
relationship.
In the query design grid in Access Query Design
the same row, different
View, you place AND criteria on _____, and you place
rows
OR criteria on _____.
With _____, only one criterion must evaluate true in
order for a record to be selected and with _____, all
OR criteria, AND criteria
criteria must be evaluate true in order for a record
to be selected.
MonthlyRate: Which of the following is an example of a computed
[AnnualRate] / 12 field?
An aggregate function Which of the following describes an Access
sums, averages, or aggregate function?
counts, for example, the
records in a group.
Use the Sort row and How do you sort data in Access Query Design
specify the sort fields in a View?
left-to-right order.
https://quizlet.com/971469094/dss-test-2-2024-2025-updatecomprehensive-questions-and-verified-answers-frequent-most-tested-questionsget-it… 2/12
