New Perspectives on Computer Concepts 2018 Comprehensive 20e June Jamrich Parsons

New Perspectives on Computer Concepts 2018 Comprehensive 20e June Jamrich Parsons

Module 10: Databases

1. A(n) _________ database is used to collect, modify, and maintain data on a daily basis.

a.

non-relational

b.

operational

c.

relational

d.

analytical

ANSWER:

b

POINTS:

1

REFERENCES:

OPERATIONAL AND ANALYTICAL DATABASES

QUESTION TYPE:

Multiple Choice

HAS VARIABLES:

False

DATE CREATED:

8/4/2017 11:16 AM

DATE MODIFIED:

8/4/2017 11:18 AM

2. A(n) _________ database is used to collect data that will be used for spotting trends that offer insights for tactical and strategic business decisions.

a.

relational

b.

operational

c.

analytical

d.

non-relational

ANSWER:

c

POINTS:

1

REFERENCES:

OPERATIONAL AND ANALYTICAL DATABASES

QUESTION TYPE:

Multiple Choice

HAS VARIABLES:

False

DATE CREATED:

8/4/2017 11:18 AM

DATE MODIFIED:

8/4/2017 11:20 AM

3. One of the ways that databases are classified is by their structure.

a.

True

b.

False

ANSWER:

True

POINTS:

1

REFERENCES:

OPERATIONAL AND ANALYTICAL DATABASES

QUESTION TYPE:

True / False

HAS VARIABLES:

False

DATE CREATED:

8/4/2017 11:22 AM

DATE MODIFIED:

8/4/2017 11:23 AM

4. In its broadest definition, a(n) ____________ is a collection of information.

ANSWER:

database

POINTS:

1

REFERENCES:

OPERATIONAL AND ANALYTICAL DATABASES

QUESTION TYPE:

Completion

HAS VARIABLES:

False

DATE CREATED:

8/4/2017 11:25 AM

DATE MODIFIED:

8/4/2017 11:26 AM

5. Access to databases is usually open to anyone within an organization or business.

a.

True

b.

False

ANSWER:

False

POINTS:

1

REFERENCES:

OPERATIONAL AND ANALYTICAL DATABASES

QUESTION TYPE:

True / False

HAS VARIABLES:

False

DATE CREATED:

8/4/2017 11:27 AM

DATE MODIFIED:

8/4/2017 11:31 AM

6. Which of the following is not one of the main activities associated with operational databases?

a.

Collecting, storing, and viewing data

b.

Updating and finding data

c.

Organizing and distributing data

d.

Providing an executive dashboard for decision makers

ANSWER:

d

POINTS:

1

REFERENCES:

OPERATIONAL AND ANALYTICAL DATABASES

QUESTION TYPE:

Multiple Choice

HAS VARIABLES:

False

DATE CREATED:

8/4/2017 11:50 AM

DATE MODIFIED:

8/4/2017 11:51 AM

7. Rather than deleting old data, it can be moved to a data __________.

ANSWER:

archive

POINTS:

1

REFERENCES:

OPERATIONAL AND ANALYTICAL DATABASES

QUESTION TYPE:

Completion

HAS VARIABLES:

False

DATE CREATED:

8/4/2017 11:52 AM

DATE MODIFIED:

8/4/2017 12:06 PM

8. It is not possible to extract analytical data from operational databases.

a.

True

b.

False

ANSWER:

False

POINTS:

1

REFERENCES:

OPERATIONAL AND ANALYTICAL DATABASES

QUESTION TYPE:

True / False

HAS VARIABLES:

False

DATE CREATED:

8/4/2017 12:06 PM

DATE MODIFIED:

8/4/2017 12:09 PM

9. Decision makers can access analytical databases using an executive __________.

ANSWER:

dashboard

POINTS:

1

REFERENCES:

OPERATIONAL AND ANALYTICAL DATABASES

QUESTION TYPE:

Completion

HAS VARIABLES:

False

DATE CREATED:

8/4/2017 12:09 PM

DATE MODIFIED:

8/4/2017 12:13 PM

10. Data _________ refers to computer algorithms that analyze information to discover previously unknown and useful information, including relationships and patterns.

a.

support

b.

OLAP

c.

mining

d.

modeling

ANSWER:

c

POINTS:

1

REFERENCES:

OPERATIONAL AND ANALYTICAL DATABASES

QUESTION TYPE:

Multiple Choice

HAS VARIABLES:

False

DATE CREATED:

8/4/2017 12:15 PM

DATE MODIFIED:

8/4/2017 12:17 PM

11. __________ is a data analysis technique used by decision makers to quickly get answers to complex queries that encompass multiple factors, such as locations, revenue, time periods, and employee status.

a.

SQL

b.

OLAP

c.

NoSQL

d.

TPS

ANSWER:

b

POINTS:

1

REFERENCES:

OPERATIONAL AND ANALYTICAL DATABASES

QUESTION TYPE:

Multiple Choice

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:05 PM

DATE MODIFIED:

8/6/2017 10:06 PM

12. __________ refers to a branch of data mining that analyzes current and historical data to predict future trends.

a.

Predictive analytics

b.

OLAP

c.

Data warehouse

d.

TPS

ANSWER:

a

POINTS:

1

REFERENCES:

OPERATIONAL AND ANALYTICAL DATABASES

QUESTION TYPE:

Multiple Choice

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:07 PM

DATE MODIFIED:

8/6/2017 10:08 PM

13. A filing cabinet full of folders and papers would be classified as a structured file because every document has a unique structure.

a.

True

b.

False

ANSWER:

False

POINTS:

1

REFERENCES:

DATABASE MODELS

QUESTION TYPE:

True / False

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:09 PM

DATE MODIFIED:

8/6/2017 10:10 PM

14. A(n) ___________ file uses a uniform format to store data for each person or thing in the file.

ANSWER:

structured

POINTS:

1

REFERENCES:

DATABASE MODELS

QUESTION TYPE:

Completion

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:10 PM

DATE MODIFIED:

8/6/2017 10:11 PM

15. The underlying structure of a database is referred to as a database _________.

ANSWER:

model

POINTS:

1

REFERENCES:

DATABASE MODELS

QUESTION TYPE:

Completion

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:12 PM

DATE MODIFIED:

8/6/2017 10:12 PM

16. A(n) __________ file consists of a single, two-dimensional table of data elements.

ANSWER:

flat

POINTS:

1

REFERENCES:

DATABASE MODELS

QUESTION TYPE:

Completion

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:13 PM

DATE MODIFIED:

8/6/2017 10:13 PM

17. In a database, a(n) __________ contains the smallest unit of meaningful information.

a.

record

b.

field

c.

table

d.

model

ANSWER:

b

POINTS:

1

REFERENCES:

DATABASE MODELS

QUESTION TYPE:

Multiple Choice

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:15 PM

DATE MODIFIED:

8/6/2017 10:16 PM

18. In a database, a(n) ____________ refers to a collection of data fields.

ANSWER:

record

POINTS:

1

REFERENCES:

DATABASE MODELS

QUESTION TYPE:

Completion

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:16 PM

DATE MODIFIED:

8/6/2017 10:17 PM

19. In a database, the template for a record is referred to as a record ______.

ANSWER:

type

POINTS:

1

REFERENCES:

DATABASE MODELS

QUESTION TYPE:

Completion

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:17 PM

DATE MODIFIED:

8/6/2017 10:18 PM

20. A record that contains data is referred to as a record ________.

a.

occurrence

b.

type

c.

template

d.

file

ANSWER:

a

POINTS:

1

REFERENCES:

DATABASE MODELS

QUESTION TYPE:

Multiple Choice

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:18 PM

DATE MODIFIED:

8/6/2017 10:19 PM

21. The relationship between record types can be depicted graphically with a(n) _________.

a.

data archive

b.

executive dashboard

c.

OLAP

d.

ERD

ANSWER:

d

POINTS:

1

REFERENCES:

DATABASE MODELS

QUESTION TYPE:

Multiple Choice

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:20 PM

DATE MODIFIED:

8/6/2017 10:21 PM

22. _________ refers to the number of associations that can exist between two record types.

ANSWER:

Cardinality

POINTS:

1

REFERENCES:

DATABASE MODELS

QUESTION TYPE:

Completion

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:21 PM

DATE MODIFIED:

8/6/2017 10:22 PM

23. A hierarchical database allows one-to-many relationships but not one-to-one relationships.

a.

True

b.

False

ANSWER:

False

POINTS:

1

REFERENCES:

DATABASE MODELS

QUESTION TYPE:

True / False

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:28 PM

DATE MODIFIED:

8/6/2017 10:29 PM

24. In a(n) _________ database, a table is a sequence of records, similar to a flat file.

ANSWER:

relational

POINTS:

1

REFERENCES:

DATABASE MODELS

QUESTION TYPE:

Completion

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:29 PM

DATE MODIFIED:

8/6/2017 10:31 PM

25. In a relational database, relationships are specified by joining common data stored in records from different tables.

a.

True

b.

False

ANSWER:

True

POINTS:

1

REFERENCES:

DATABASE MODELS

QUESTION TYPE:

True / False

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:31 PM

DATE MODIFIED:

8/6/2017 10:32 PM

26. A key element of __________ databases is their ability to support OLAP queries that make it possible to combine data, drill down to specifics, or slice and dice the data to view it from different perspectives.

ANSWER:

multidimensional

POINTS:

1

REFERENCES:

DATABASE MODELS

QUESTION TYPE:

Completion

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:32 PM

DATE MODIFIED:

8/6/2017 10:33 PM

27. Modern database tools support ________________, which entails separating data from the programs that manipulate data.

a.

predictive analytics

b.

cardinality

c.

data independence

d.

data dependence

ANSWER:

c

POINTS:

1

REFERENCES:

DATABASE TOOL BASICS

QUESTION TYPE:

Multiple Choice

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:34 PM

DATE MODIFIED:

8/6/2017 10:36 PM

28. Data independence is a term that refers to data and program modules being so tightly interrelated that they become difficult to modify.

a.

True

b.

False

ANSWER:

False

POINTS:

1

REFERENCES:

DATABASE TOOL BASICS

QUESTION TYPE:

True / False

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:36 PM

DATE MODIFIED:

8/6/2017 10:37 PM

29. Which database tool is best for simple flat files that involve calculations?

a.

Database software

b.

Spreadsheet software

c.

Word processing software

d.

DBMS

ANSWER:

b

POINTS:

1

REFERENCES:

DATABASE TOOL BASICS

QUESTION TYPE:

Multiple Choice

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:37 PM

DATE MODIFIED:

8/6/2017 10:39 PM

30. Enterprise database applications tend to have some flexibility for customization.

a.

True

b.

False

ANSWER:

True

POINTS:

1

REFERENCES:

DEDICATED APPLICATIONS

QUESTION TYPE:

True / False

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:39 PM

DATE MODIFIED:

8/6/2017 10:40 PM

31. Dedicated enterprise database applications may allow cosmetic changes, but they do not encourage modifications of core data structures.

a.

True

b.

False

ANSWER:

True

POINTS:

1

REFERENCES:

DEDICATED APPLICATIONS

QUESTION TYPE:

True / False

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:41 PM

DATE MODIFIED:

8/6/2017 10:42 PM

32. A(n) _________ sort uses one field to arrange records. A(n) _________ sort arranges information by more than one field.

a.

single-level, multi-level

b.

multi-level, single-level

c.

structured, unstructured

d.

SQL, NoSQL

ANSWER:

a

POINTS:

1

REFERENCES:

WORD PROCESSOR DATA TOOLS

QUESTION TYPE:

Multiple Choice

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:43 PM

DATE MODIFIED:

8/6/2017 10:45 PM

33. Most spreadsheet software also includes basic data management features.

a.

True

b.

False

ANSWER:

True

POINTS:

1

REFERENCES:

SPREADSHEET DATA TOOLS

QUESTION TYPE:

True / False

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:45 PM

DATE MODIFIED:

8/6/2017 10:47 PM

34. Spreadsheet software offers database capabilities for establishing relationships between different record types.

a.

True

b.

False

ANSWER:

False

POINTS:

1

REFERENCES:

SPREADSHEET DATA TOOLS

QUESTION TYPE:

True / False

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:47 PM

DATE MODIFIED:

8/6/2017 10:49 PM

35. The acronym ____________ refers to software that manages data stored in a database.

a.

ERP

b.

SQL

c.

OLAP

d.

DBMS

ANSWER:

d

POINTS:

1

REFERENCES:

DATABASE MANAGEMENT SYSTEMS

QUESTION TYPE:

Multiple Choice

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:51 PM

DATE MODIFIED:

8/6/2017 10:53 PM

36. FileMaker Pro and Microsoft Access are DBMSs.

a.

True

b.

False

ANSWER:

True

POINTS:

1

REFERENCES:

DATABASE MANAGEMENT SYSTEMS

QUESTION TYPE:

True / False

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:53 PM

DATE MODIFIED:

8/6/2017 10:55 PM

37. Four DBMS vendors are the first stop for professional developers: IBM, _________, SAS, and SAP.

ANSWER:

Oracle

POINTS:

1

REFERENCES:

DATABASE MANAGEMENT SYSTEMS

QUESTION TYPE:

Completion

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 10:55 PM

DATE MODIFIED:

8/6/2017 11:02 PM

38. A DBMS feature known as __________ ensures that transactions are updated in an orderly manner by establishing update rules.

a.

serializability

b.

optimization

c.

prioritization

d.

normalization

ANSWER:

a

POINTS:

1

REFERENCES:

DATABASE MANAGEMENT SYSTEMS

QUESTION TYPE:

Multiple Choice

HAS VARIABLES:

False

DATE CREATED:

8/6/2017 11:02 PM

DATE MODIFIED:

8/6/2017 11:05 PM