OMIS 350 Exam 3 SELU

Which of the following technologies would you use to analyze the social media data collected by a major online retailer

Hadoop

Which of the following is the most prominent data manipulation language today

SQL

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

a crow's foot topped by a short mark

Which of the following is software that handles all application operations between browser-based computers and a company's back-end business applications or databases

application server software

A characteristic or quality that describes a particular database entity is called a

attribute

All of the following are technologies used to analyze and manage big data except

cloud computing

Which of the following occurs when the same attribute in related data files has different values

data inconsistency

__________ creates confusion that hampers the creation of information systems that integrate data from different sources

data redundancy

In a large organization, which of the following functions would be responsible for physical database design and maintenance

database administration

A schematic of the entire database that describes the relationships in a database is called a

entity-relationship diagram

All of the following are issues with the traditional file environment except:

inability to develop specialized applications for functional areas

Which of the following is not one of the benefits of a blockchain database

it enables firms to create and verify translations on a network very rapidly

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

key field

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

primary key

A database ___________ describes a database entity

record

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

select, project, and join

A household appliances manufacturer has hired you to help analyze its social media datasets to determine which of its refrigerators are seen as the most reliable. Which of the following tools would you use to analyze this data?

sentiment analysis software

Which of the following is not one of the techniques used in web mining

server mining

___________ tools are used to analyze large unstructured data sets, such as emails, memos, and survey responses to discover patterns and relationships

text mining

A data lake is composed of

unstructured and structured data that has not been analyzed

Which of the following would you use to find patterns in user interaction data recorded by a web server

web usage mining