ISDS 3003 Final Exam Review 2023 complete solution
1 view 0 purchase
Course
NU1426
Institution
NU1426
ISDS 3003 Final Exam Review 2023 complete solution
A relational database is ________
A. a self-describing collection of related tables
B. a library of queries and data files for querying
C. a set of applications and the data sets for those applications
D. a set of metadata
E. a collection o...
ISDS 3003 Final Exam Review 2023 complete
solution
1). A relational database is ________
a. a self-describing collection of related tables
b. a library of queries and data files for querying
c. a set of applications and the data sets for those applications
d. a set of metadata
e. a collection of forms and reports that support a given purpose
Ans: a self-describing collection of related tables
2). Data mining applications are used to accomplish all of the following tasks except ________
a. incorporate results into some other report/system
b. facilitate decision making
c. classify entities
d. make predictions
e. perform what-if analysis
Ans: classify entities
3). Business intelligence (bi) reporting systems can do which of the following operations?
a. filter data
b. group data
c. modify data
d. both filter data and group data
e. secure data
Ans: Both Filter data and Group data
4). A relational database stores data in the form of ________
a. forms
b. tables
c. lists
PaperStoc.com Page 1 of 7
, d. columns
e. spreadsheets
Ans: tables
5). Sql stands for ________
a. standard question language
b. structural question language
c. structured query language
d. structured question language
e. standard query language
Ans: Structured Query Language
6). Which of the following is not true about null values?
a. a null value can mean that no value for the field is appropriate.
b. a null value is ambiguous.
c. a null value can mean that the value is unknown.
d. null values cannot be avoided.
e. a null value can mean that the value is known to be blank
Ans: Null values cannot be avoided
7). Which of the following terms is synonymous with "relation"?
a. row
b. record
c. table
d. tuple
e. attribute
Ans: Table
8). The first step of the normalization process is to ________
a. identify all the determinants of a relation
b. split the relation into two or more new relations
c. identify all the functional dependencies of a relation
d. identify all the foreign keys of a relation
e. identify all the candidate keys of a relation
PaperStoc.com Page 2 of 7
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 Academik001. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.
