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