Exam (elaborations)
ISQS Exam 1 Questions and Answers Verified by Expert 100% Correct
- Course
- Institution
ISQS Exam 1 Questions and Answers Verified by Expert 100% Correct
[Show more]
Content preview
ISQS Exam 1 Questions and Answers Verified byExpert 100% Correct
A ______ key is a value (or set of values) that ensures each record is unique. Said
another way, it is the field (or combination of fields) that makes every record in a
table unique. - ANSWER primary
Which sequence represents the hierarchy of terms, from smallest to largest?
(Record, Table, Database, Field) - ANSWER Field, record, table, database
A relational database is defined as... - ANSWER An organized structured data
about separate but related entities, composed of related tables
A primary key is defined as... - ANSWER One or more fields whose value
uniquely identifies each record in the table, different value for each record, no null
values (no blank spots)
A concatenated primary key is defined as... - ANSWER A combination of two or
more fields used to uniquely identify each record
A foreign key is defined as... - ANSWER Using the primary key from one table
as a field in a related table, provides common field to create relationships
T/F A database is any organized collection of data. - ANSWER True
A _____ is a question you ask that can help you find and retrieve table data
meeting conditions you specify. - ANSWER query
, A Compact and Repair utility in Access creates a duplicate copy of the database. -
ANSWER False
T/F The field section of the Field List is used to add fields to your PivotTable. -
ANSWER True
T/F Slicers help you filter data in a PivotTable. - ANSWER True
T/F Rows area fields are shown as Row Labels on the left side of the PivotTable. -
ANSWER True
A PivotTable in Excel is a powerful tool that lets you see which of the following in
your data? (Fundamentals, Comparisons, Patterns, Trends, Stories) - ANSWER
patterns, comparisons, and trends
T/F To focus on a smaller portion of a large amount of your PivotTable data in-
depth analysis, you can filter the data. - ANSWER True
Which of the following are hardware developments that the readings suggest will
disrupt existing organizations? (The Internet, Self-driving cars, Open source
software, The Internet of Things) - ANSWER The Internet of Things & Self-
driving cars
Which of the following are examples of storage hardware used to save data and
programs? (Optical disks, Magnetic disk, Random Access Memory, Solid-state
storage) - ANSWER optical disks, magnetic disks, & solid-state storage
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 StudySet. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
81113 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now