Quiz #4: Databases

Data redundancy can lead to which three of the following?

increased storage fees, inefficient access times, inconsistent data

Data marts are used to track ________, purchase transactions, and the supply chain.

inventories

A Database Management System (DBMS) has the ability for ________ and database ________ to manipulate, query, and store information in a database.

managers, administrators

The primary key field cannot hold a ________ or ________ value.

null, duplicate

OLAP is used to support businesses in a wide range of areas including ________.

performance management, financial reporting, simulation model

Parameter queries ________ the user for values to execute/run a query.

prompt

Some of the duties a database administrator performs include ________.

security, tuning, backup

data quality audit uses ________ analysis to test data, variabilities, and outcomes against test data.

statistical

Commonly used techniques to gain information in web mining include, ________, ________, and ________.

1. Web Content Mining (WCM) 2. Web Structure Mining (WSM) 3. Web Usage Mining (WUM)

A cloud database is a type of database that is ________ and ________ via a cloud platform.

1. built, created 2. accessed

The data mining process includes knowledge deployment, ________, ________, and ________

1. problem definition 2. data gathering and preparation 3. model building and evaluation

The main objectives of data governance include high-quality data and which other goals?

1. risk mitigation risk mitigation 2.data use rules data use rules 3. requirement compliance requirement compliance 4. cost-saving

Knowledge Discovery in Data (KDD) is also known as ________.

data mining

The acronym for Data Governance is ________.

DG

________ is software with processing capabilities outside of what the operating system of the consumer provides.

Middlewear

Structured Query Language (SQL)-specific queries use specific SQL ________ to execute the query.

Statements

What does the abbreviation SQL stand for?

Structured Query Language

We use a ________ field between the two database tables to create a relationship link.

common

Basic DBMS functions allow users to ________, read, ________, and ________ data.

create, update, delete

Usability in web mining refers to how a website ________ and ________ can interact with a website.

users, visitors, pages