MIS

_____ is a process that refines entities and their relationships to help minimize duplication of information in tables

normalization

A field or group of fields that make a record unique in a table is called...

primary key

The business analysts at Blue, recently were asked to assess revenue generated over the past five years to observe seasonal and historical trends. After extensive analysis, they arrive at the conclusion that the sales were highest during the months of July and August and low during January. Which of the following tools would have BEST helped them arrive at this conclusion?

Forecasting

Martin & Martin LLC is a nonprofit organization offering pro-bono legal services using a network of lawyers. The basement of their office is filled with boxes containing the files of hundreds of cases completed over the past ten years. The legal documents stored in the files boxes are an example of....

Unstructured information

Which of the following uses databases without boundaries?

A social networking site

Which of the following is an accurate definition of CAPTCHA

A test that a visitor must pass before registering into a site

Which of the following real-life functions does an intelligent agent perform?

Classifying and indexing web pages for search engines

Database architecture that has multidimensional data grouped in logical dimensions, such as sales by product, city, region, and country is called....

Data cubes

Devon Degosta is planning the organization's database. The model Decor is developing to identify what kind of information is needed, what entities will be created, and how they are related to one another is called_____

Data model

An integrated collection of information that is logically related and stored to minimize duplication and facilitate rapid retrieval is called a

Database

An attribute of an entity in a table is called a

Field

Iron Bank Coffee has three retail stores, each operating independently with their own database of customers and products. Their owner has decided to consolidate the databases of the three stores into one. Which of the following is NOT a benefit that will be realized by only having one?

Increases the number of customers for the coffee shops

How is metadata related to information?

It helps clarify the nature of the information

Which of the following is a drawback of the growing power of artificial intelligence?

Its techniques are used by scammers to gain access to sites

The term ____ refers to quantifiable metrics used to evaluate an organization or an individual's success in a particular activity

Key performance indicators

An approach that attempts to achieve consistent and uniform definitions for entities and their attributes across all business units is called

Master data management

The process by which users are directed to a copy of the database when the main one fails is called

Mirroring

What does bounce rate in the context of web metrics?

Percentage of visits in which the user leaves the site from the same page he or she entered it

Which type of database architecture does Oracle use?

Relational database

Photo-tagging is an increasingly common practice that has raised concerns about privacy for all of the following reasons EXCEPT

Tags in photos of old friends can help a person remember names better

In web metrics, which of the following best describes depth of visit?

The number of page views per visit

Which of the following is an accurate definition of conversion rate?

The ratio of visitors who complete some activity divided by the total number of visitors

Which of the following statements is true of portals

They are gateways that provide access to a variety of relevant information from many difference sources on one screen

The zip codes that aren't in the standard format at reformatted. This process is called

Transformation

Alyssa Meade is the database administrator for Realtree Outdoors. She is updating the data warehouse by using zip codes to add demographic data from the U.S Census Bureau to the company's customer records before loading them into the date warehouse. What is this process called?

Transformation process