Homework answers / question archive / Alamo Colleges IS 3003 Chapter 5 1)Which of the following is not a true statement about MDM? A) Its goal is to ensure a company is not using multiple versions of the same data

Alamo Colleges IS 3003 Chapter 5 1)Which of the following is not a true statement about MDM? A) Its goal is to ensure a company is not using multiple versions of the same data

Business

Share With

---

Alamo Colleges

IS 3003

Chapter 5

1)Which of the following is not a true statement about MDM?

A) Its goal is to ensure a company is not using multiple versions of the same data.

B) It is a multi-step process that includes business process analysis.

C) It is a quality-of-data concept that is used to identify a company's most important data.

D) Its goal is to create a single, authenticated master file for the company's data.

 

2)            What is the first step you should take in managing data for a firm? A) Identify the data needed to run the business

 

B)            Cleanse the data before importing it to any database

C)            Normalize the data before importing to a database

D)           Audit your data quality

 

3)            An example of a pre-digital database is a:

A) library’s card-catalog.

B) cash register receipt.

C) doctor’s office invoice.

D) list of sales totals on a spreadsheet.

 

4)            Which of the following best illustrates the relationship between entities and attributes? A) The entity CUSTOMER with the attribute PRODUCT

B)            The entity CUSTOMER with the attribute ADDRESS

C)            The entity PRODUCT with the attribute PURCHASE

D)           The entity PRODUCT with the attribute CUSTOMER

 

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

A) OODBMS.      B) pre-digital DBMS. C) relational DBMS.               D) hierarchical DBMS.

 

6)            What are the relationships that the relational database is named for?

A) Relationships between rows and columns B) Relationships between entities

C)            Relationships between fields and records

D)           Relationships between databases

 

7)            A characteristic or quality describing an entity is called a(n):

A) field.                B) tuple.

C) key field.        D) attribute.

 

8)            The most basic business database is comprised of:

A) three tables: for customers, suppliers and parts, and sales.

B) four tables: for customers, suppliers, parts, and sales.

C) four tables: for customers, employees, suppliers and parts, and table sales. D) five tables: for customers, employees, suppliers, products, and sales.

 

9)            In a table for customers, the information about a single customer would reside in a single:

A) field.                B) row.

C) column.          D) table.

 

10)          In a relational database, a record is also called a(n):

A) tuple.              B) row.

C) entity.             D) field.

 

11)          A field identified in a table as holding the unique identifier of the table’s records is called the: A) primary key.                B) key field.

C) primary field.                D) foreign key.

 

12)          A field identified in a record as holding the unique identifier for that record is called the:

A) primary key. B) key field.

C) primary field.                D) foreign key.

 

13)          A schematic of the entire database that describes the relationships in a database is called a(n):

A) data dictionary.

B) intersection relationship diagram. C) entity-relationship diagram.

 

D) data definition diagram.

 

14)          A one-to-one relationship between two entities is symbolized in a diagram by a line that ends: A) in two short marks.

B) in one short mark. 0C) with a crow’s foot.

D) with a crow’s foot topped by a short mark.

 

15)          A one-to-many relationship between two entities is symbolized in a diagram by a line that ends:

A) in two short marks.

B) in one short mark.

C) with a crow’s foot.

D) with a crow’s foot preceded by a short mark.

 

16)          A table that links two tables that have a many-to-many relationship is often called a(n):

A) derived table.              B) intersection relation.

C) foreign table.               D) entity-relationship table.

 

17)          The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called: A) normalization.               B) data scrubbing.

C) data cleansing.             D) data administration.

 

18)          A DBMS makes the:

A) physical database available for different logical views.

B) logical database available for different analytical views.

C) physical database available for different relational views.

D) relational database available for different physical views.

 

19)          The logical view of a database:

A) shows how data are organized and structured on the storage media.

B) presents an entry screen to the user.

C) allows the creation of supplementary reports.

D) presents data as they would be perceived by end users.

 

20)          Which of the following is not a typical feature of DBMS?

A) Data manipulation language

B) Report generation tools

C) Data dictionary

D) Query wizard tool

 

21)          Oracle Database Lite is a:

A) DBMS for small handheld computing devices.

B) popular open-source DBMS.

C) Mainframe relational DBMS.

D) DBMS for midrange computers.

 

22)          Access is a:

A) DBMS for small handheld computing devices.

B) popular open-source DBMS.

C) DBMS for midrange computers. D) DBMS for desktop systems.

 

23)          MySQL is a:

A) DBMS for small handheld computing devices. B) popular open-source DBMS.

C)            mainframe relational DBMS.

 

D)           DBMS for desktop systems.

 

24)          Microsoft SQL Server is a(n):

A) DBMS for small handheld computing devices.

B) Internet DBMS.

C) Desktop relational DBMS.

D) DBMS for midrange computers.

 

25)          In a relational database, the three basic operations used to develop useful sets of data are:

A) select, project, and where.

B) select, join, and where. C) select, project, and join.

D) select, from, and join.

 

26)          The select operation:

A) combines relational tables to provide the user with more information than is otherwise available.

B) creates a subset consisting of columns in a table.

C) identifies the table from which the columns will be selected.

D) creates a subset consisting of all records in the file that meets stated criteria.

 

27)          The join operation:

A) combines relational tables to provide the user with more information than is otherwise available.

B) identifies the table from which the columns will be selected.

C) creates a subset consisting of columns in a table.

D) organizes elements into segments.

 

28)          The project operation:

A) combines relational tables to provide the user with more information than is otherwise available. B) creates a subset consisting of columns in a table.

C)            organizes elements into segments.

D)           identifies the table from which the columns will be selected.

 

29)          The data dictionary serves as an important data management tool by:

A) assigning attributes to the data.

B) creating an inventory of data definitions contained in the database.

C) specifying the structure of the content of the database.

D) maintaining data in updated form.

 

30)          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:

A) data dictionary.

B) data definition diagram.

C) entity-relationship diagram.

D) relationship dictionary.

 

31)          The specialized language programmers use to add and change data in the database is called:

A) data dictionary language. B) data manipulation language.

C)            Structured Query Language.

D)           data definition language.

 

32)          The most prominent data manipulation language today is:

A) Access.           B) DB2.

C) SQL.  D) Crystal Reports.

 

33)          DBMS typically include report-generating tools in order to:

 

A) retrieve and display data.

B) display data in an easier-to-read format.

C) display data in graphs.

D) perform predictive analysis.

 

34)          The type of database management approach that can handle multimedia is the:

A) hierarchical DBMS.     B) relational DBMS.

C) network DBMS.           D) object-oriented DBMS.

 

35)          Which of the following database types is useful for storing Java applets as well as handling large numbers of transactions?

A) Relational DBMS

B) Hierarchical DBMS

C) Object-relational DBMS

D) OODBMS

 

36)          A data warehouse is composed of:

A) historical data.

B) current data.

C) internal and external data sources. D) both historical and current data.

 

37)          Which of the following statements about data warehouses is not true?

A) They store supply data to be used across the enterprise for management analysis and decision making.

B) Data warehouse systems provide a range of ad hoc and standardized query tools, analytical tools, and graphical reporting facilities.

C) They may include data from Web site transactions.

D) Data warehouse systems provide easy-to-use tools for managers to easily update data.

 

38)          A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because:

A) it typically focuses on a single subject area or line of business.

B) all the information is historical.

C) it uses a Web interface.

D) all of the information belongs to a single company.

 

39)          Tools for consolidating, analyzing, and providing access to vast amounts of data to help users make better business decisions are known as:

A) DSS. B) business intelligence.

C) OLAP.              D) data mining.

 

40)          The tool that enables users to view the same data in different ways using multiple dimensions is:

A) predictive analysis.    B) SQL.

C) OLAP.              D) data mining.

 

41)          OLAP is a tool for enabling:

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

B) users to view both logical and physical views of data.

C) programmers to quickly diagram data relationships.

D) programmers to normalize data.

 

42)          Data mining is a tool for allowing users to:

A) quickly compare transaction data gathered over many years. B) find hidden relationships in data.

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

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

 

43)          In terms of the data relationships found by data mining, associations refers to:

A) events linked over time.

B) patterns that describe a group to which an item belongs. C) occurrences linked to a single event.

D) undiscovered groupings.

 

44)          In terms of the data relationships found by data mining, sequences refers to:

A) events linked over time

B) patterns that describe a group to which an item belongs.

C) occurrences linked to a single event.

D) undiscovered groupings.

 

45)          An alternative to using application server software for interfacing between a Web server and back-end databases is:

A) CGI.  B) HTML.

C) Java. D) SQL.

 

46)          Businesses use tools to search and analyze unstructured data sets, such as e-mails and memos.

A) OODBMS       B) Web mining

C) text mining    D) OLAP

 

47)          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.

A) batch processing        B) data redundancy

C) data independence   D) online processing

 

48)          Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called:

A) data auditing.               B) defragmentation C) data scrubbing    D) data optimization