Exam (elaborations)
DSS TEST 2 (2024/25) QUESTIONS WITH COMPLETE SOLUTIONS!!
- Course
- Institution
DSS TEST 2 (2024/25) QUESTIONS WITH COMPLETE SOLUTIONS!!
[Show more]
Content preview
DSS TEST 2 (2024/25) QUESTIONS WITHCOMPLETE 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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller EvaTee. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75759 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now