vvvv impit answers week 3

Question Type: # Of Questions: # Correct:

Multiple Choice 20 20

Grade Details - All Questions

1. Question : A characteristic or quality describing an entity is called a(n)

Student Answer: field.

tuple.

key field.

attribute.

Instructor Explanation: p. 210

Points Received: 1 of 1

Comments:

2. Question : The confusion created by _____ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources.

Student Answer: batch processing

data redundancy

data independence

online processing



Comments:

3. Question : Duplicate data in multiple data files is called

Student Answer: data redundancy.

data multiplication.

data independence.

data backups.



Comments:

4. Question : A DBMS

Student Answer: makes the physical database available for different logical views.

makes the logical database available for different analytical views.

makes the physical database available for different analytical views.

makes the relational database available for different analytical views.



Comments:

5. Question : The logical view

Student Answer: shows how data are organized and structured on the storage

media.

presents an entry screen to the user.

allows the creation of supplementary reports.

presents data as they would be perceived by end users.



Comments:

6. Question : The type of logical database model that treats data as if they were stored in two-dimensional tables is the

Student Answer: OODBMS.

pre-digital DBMS.

relational DBMS.

hierarchical DBMS.



Comments:

7. Question : A field identified in a table as holding the unique identifier of the table's records is called the

Student Answer: primary key.

key field.

primary field.

unique ID.



Comments:

8. Question : The data dictionary serves as an important data management tool by

Student Answer: assigning attributes to the data.

creating an inventory of data contained in the database.

presenting data as end users or business specialists would perceive them.

maintaining data in updated form.



Comments:

9. Question : An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the

Student Answer: data dictionary.

data definition diagram.

entity-relationship diagram.

relationship dictionary.



Comments:

10. Question : Which is the type of database management approach that can handle a large number of pages or documents?

Student Answer: Hierarchical DBMS

Relational DBMS

Network DBMS

NoSQL

Instructor Explanation: Week 3 Lecture


Comments:

11. Question : Which is the most prominent data manipulation language today?

Student Answer: Access

DB2

SQL

Crystal Reports

Instructor Explanation: pp. 217–218


Comments:

12. Question : DBMSs typically include report-generating tools in order to

Student Answer: retrieve and display data.

display data in an easier-to-read format.

display data in graphs.

perform predictive analysis.



Comments:

13. Question : A schematic of the entire database that describes the relationships in a database is called

Student Answer: the data dictionary.

the intersection relationship diagram.

the entity-relationship diagram.

the data definition diagram.



Comments:

14. Question : What is the process of streamlining data to minimize redundancy and awkward many-to-many relationships?

Student Answer: Normalization

Data scrubbing

Data cleansing

Data defining



Comments:

15. Question : Cloud computing offers

Student Answer: no database functions.

some database functions.

products only from Amazon and Microsoft.

None of the above



Comments:

16. Question : A data warehouse is composed of

Student Answer: historical data from legacy systems.

current data.

internal and external data sources.

historic and current internal data.



Comments:

17. Question : A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because

Student Answer: a data mart typically focuses on a single subject area or line of

business.

all the information is historical.

a data mart requires a Web interface.

all of the information belongs to a single company.



Comments:

18. Question : Data mining is a tool that allows users to

Student Answer: quickly compare transaction data gathered over many years.

find hidden relationships in data.

obtain online answers to ad hoc questions in a rapid amount of time.

summarize massive amounts of data into much smaller, traditional reports.



Comments:

19. Question : What is the tool that enables users to view the same data in different ways using multiple dimensions?

Student Answer: Predictive analysis

SQL

OLAP

Data mining



Comments:

20. Question : OLAP is a tool that enables

Student Answer: users to obtain online answers to ad hoc questions in a short

amount of time.

users to view both logical and physical views of data.

programmers to quickly diagram data relationships.

programmers to normalize data.



Comments:

vvvv impit answers week 3

Documents