quiz3

Wiley Pathways Introduction to Database Management

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 1. Question: A ____ key is defined as a key that is used strictly for data retrieval purposes. ALookup BForeign CCandidate DSecondary D 2. Question: The relational data model was developed in the ____. A1960s B1970s C1980s D1990s B 3. Question: Any attribute that is part of a key is known as a ____. AKey attribute BLogical attribute CKey determiner DSelector A 4. Question: A(n) ____ join links tables by selecting only the rows with common values in their common attribute(s). AEqual BUnique CForeign DNatural D 5. Question: ____, also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition. AINTERSECT BUNION CDIFFERENCE DSELECT D 6. Question: ____ is the body of information and facts about a specific subject. AData BInformation CKnowledge DA database
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Sheet1 Page 2 C 7. Question: A(n) ____ database supports a small number of users or a specific department within an organization. ADesktop BWorkgroup CEnterprise DTransactional B 8. Question: In a natural join, the column on which the join was made occurs twice in the new table. ATrue BFalse B? 9. Question: Numeric data are data on which you can perform meaningful arithmetic procedures. ATrue BFalse A 10. Question: ____ data are the result of formatting to facilitate storage, use, and generation of information. AStructured BSemistructured CUnstructured DHistorical A? 11. Question: A(n) ____ database is designed to support a company& s day-to-day operations. ADesktop BWorkgroup CEnterprise DTransactional D 12. Question: A data warehouse can store data derived from many sources. ATrue BFalse A 13. Question: A(n) ____ database is used by an organization and supports many users across many departments.
Background image of page 2
Sheet1 Page 3 ADesktop BWorkgroup CEnterprise DTransactional C 14. Question: ____ yields only the rows that appear in both tables. 1 AINTERSECT BUNION CDIFFERENCE DSELECT A 15. Question: ____ combines all rows from two tables, excluding duplicate rows. AINTERSECT
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 03/28/2010.

Page1 / 10

Quiz3 - 1 Question A key is defined as a key that is used strictly for data retrieval purposes A Lookup B Foreign C Candidate D Secondary D 2

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online