BIS 245 FINAL EXAM (LATEST) DEVRY UNIVERSITY, NEW YORK 1: GRADED A | 100% CORRECT
1 view 0 purchase
Course
BIS 155 (BIS245)
Institution
DEVRY UNIVERSITY
BIS 245 FINAL EXAM (LATEST) DEVRY UNIVERSITY, NEW YORK 1: GRADED A | 100% CORRECTBIS 245 FINAL EXAM (LATEST) DEVRY UNIVERSITY, NEW YORK 1: GRADED A | 100% CORRECTBIS 245 FINAL EXAM (LATEST) DEVRY UNIVERSITY, NEW YORK 1: GRADED A | 100% CORRECTBIS 245 FINAL EXAM (LATEST) DEVRY UNIVERSITY, NEW YORK 1...
BIS 245 FINAL EXAM (LATEST): DEVRY
UNIVERSITY, NEW YORK
Question 1
(CO 1) A foreign key is
a value that can connect two tables simultaneously.
a unique value that identifies each row within a table.
another name for a candidate key.
a field in one table that is also the primary key of another table.
Question 2
(CO 1) In what situation would Excel be a better choice than Access?
You have a limited amount of data or must do a complicated calculation.
You have an extensive amount of data.
You need to maintain constant connectivity to an external database.
You require a relational view of your data.
Question 3
(CO 1) The navigation pane allows you to
open tables.
open views.
filter by datatype.
filter by group and navigate to category.
Question 4
(CO 1) Filters are used to do all of the following except
a filter can be removed by selecting remove filter from the sort & filter group.
all records in a table will be displayed if all of the filters are removed.
filter effects are cumulative.
it does not matter whether you apply a filter or a sort first.
, Question 5
(CO 1) Which one of the following report sections appear once on every report page?
Question 6
(CO 2) A table is also recognized as a(n)
cardinality.
domain.
entity.
key.
Question 7
(CO 2) A symbol used in ER diagrams for an entity is a
box.
diamond.
line.
triangle.
Question 8
(CO 3) All of the following are reasons to save first name and last name as separate
fields except
fewer fields are used.
first name could be used in a salutation.
last name could be used in a salutation.
you can sort on last name then first name.
Question 9
(CO 3) A functional dependency is
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 NURSINGUNIVERSITYWALDEN. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $22.99. You're not tied to anything after your purchase.
