Chapter#6 – MIS – Flashcards
Unlock all answers in this set
Unlock answersquestion
What is the function of a JOIN operation in a relational database? a. It combines relational tables to provide the user with more information than is otherwise available b. It creates a subset consisting of all records in the file that meet stated criteria c. It creates a subset consisting of columns in a table d. It shows how data is organized in the database e. It identifies the table from which the columns will be selected
answer
a. It combines relational tables to provide the user with more information than is otherwise available
question
Duplicate data in multiple data files is: a. data replication b. data backups c. data redundancy d. data multiplication e. data independence
answer
c. data redundancy
question
Why is it that a data mart usually can be constructed more rapidly and at lower cost than a data warehouse? a. A data mart holds current data only b. All the information in a data mart belongs to a single company c. All the information in a data mart is historical d. A data mart uses a Web interface e. A data mart typically focuses on a single subject area or line of business
answer
e. A data mart typically focuses on a single subject area or line of business
question
The special organizational function whose responsibilities include the technical and operational aspects of managing data, including physical database design and maintenance, is called _________________. a. data mining b. information policy administration c. data administration d. data auditing e. database administration
answer
e. database administration
question
Which is an example of a pre-digital database? a. A cash register receipt b. A list of sales totals on a spreadsheet c. A doctor's office invoice d. Information in notebooks e. A library's card catalog
answer
e. A library's card catalog
question
Which tool enables users to view the same data in different ways using multiple dimensions? (p201) a. Clustering b. SQL c. Hadoop d. OLTP e. OLAP
answer
e. OLAP
question
Operational data can have many problems that make it unsuitable for data mining. Of the following, which is NOT data problem in operational data that creates issues for data mining? a. Wrong granularity b. High integrated data c. Missing elements d. Inconsistent values e. Too much data
answer
b. High integrated data
question
Which is the name of the specialized language programmers use to add and change data in the database? (p194) a. Data access language b. Structured query language c. Access control lists d. Data manipulation language e. Data definition language
answer
b. Structured query language
question
Which of the following statements is NOT a characteristic of Hadoop? (p199) a. Hadoop extracts data from multiple tables that have a relationship b. Hadoop breaks a big data problem down into subproblems c. Hadoop enables distributed parallel processing of huge amounts of data across inexpensive computers d. Hadoop combines results into a smaller data set that is easier to analyze e. Hadoop is an open source software framework
answer
a. Hadoop extracts data from multiple tables that have a relationship
question
A characteristic or quality describing an entity is called a(n) _________________. a. record b. field c. key field d. attribute e. tuple
answer
d. attribute
question
A data warehouse is comprised of _________________. (p199) a. internal and external data sources b. historical data from legacy systems c. historic and current operational data d. operational data e. current data
answer
c. historic and current operational data
question
Which of the following statements is FALSE about business intelligence (BI) systems? a. BI systems are used by business professionals and knowledge workers b. BI systems process operational and social data c. BI systems identify patterns, relationships, and trends d. BI systems have five components: hardware, software, data, procedures, and people e. BI systems only support decision-making activities
answer
e. BI systems only support decision-making activities
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 _________________. (p194) a. entity-relationship diagram b. data dictionary c. data warehouse d. relationship dictionary e. data definition diagram
answer
b. data dictionary
question
Among the following statements, which one is NOT applicable to big data? (p198) a. Big data can be processed with traditional techniques b. Big data can consists of multimedia files like graphics, audio, and video c. Big data has a variety of data with structured data and free-form text and logs d. Big data is generated rapidly e. Big data sets are at least a petabyte in size
answer
a. Big data can be processed with traditional techniques
question
What is the function of a SELECT operation in a relational database? (p194) a. It combines relational tables to provide the user with more information than is otherwise available b. It creates a subset consisting of columns in a table c. It identifies the table from which the columns will be selected d. It creates a subset consisting of all records in the file that meet stated criteria e. It organizes elements into segments
answer
d. It creates a subset consisting of all records in the file that meet stated criteria
question
What is the first step you should take in managing data for a firm? (p188) a. Normalize the data before importing to a database b. Audit your data quality c. Back up the data d. Cleanse the data before importing it to any database e. Identify the data needed to run the business
answer
e. Identify the data needed to run the business
question
When one table has a foreign key that points to the other table, the term _________________ refers to not being able to add a record to the table with the foreign key unless there is a corresponding record in the linked table. (p191) a. replication b. referential integrity c. normalization d. duplication e. data access security
answer
b. referential integrity
question
Which of the following is NOT a primary activity in the business intelligence (BI) process? a. Delivering reports and results to knowledge workers b. Obtaining, cleaning, and organizing data c. Relating and cataloging the data sources d. Tracking the access and use of the data missing results e. Creating business intelligence reports and data mining results
answer
d. Tracking the access and use of the data missing results
question
19. Which of the following is FALSE about nonrelational database management systems? (p196) a. They use a more flexible data model than rational databases b. They work on data distributed across many distributed machines c. They are useful for accelerating simple queries against large columns of structured and unstructured data d. They are stored without any data redundancy e. They are designed for managing large data sets
answer
d. They are stored without any data redundancy
question
Which of the following involves searching for patterns and relationships among data? a. Data marting b. Data warehousing c. Knowledge management d. Data processing e. Data mining
answer
e. Data mining
question
Which of the following is NOT a rule in an organization's information policy? a. What the relationships inside the data are b. Procedures and accountabilities around managing data resources c. Which users and organizational units can share information d. Where information can be distributed e. Who is responsible for updating and maintaining the information
answer
a. What the relationships inside the data are
question
Among the following, what is the best way to distinguish between reporting tools and data-mining tools? a. The objective of using these tools b. The ways of deploying the results c. The complexity of techniques used d. The difference in the input data e. The type of data used
answer
c. The complexity of techniques used
question
Which are tools for consolidating, analyzing, and providing access to vast amounts of data are? a. OLAP b. OLTP c. DSS d. Data mining e. Business intelligence
answer
e. Business intelligence
question
Which of the following is NOT a function of data warehouse? a. Cleanse data b. Filter data c. Obtain data d. Catalog data e. Organize and relate data
answer
b. Filter data
question
The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called _________________. a. data definition b. validation c. normalization d. data cleansing e. data scrubbing
answer
c. normalization
