Quiz #4: Databases

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

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


Set pelajaran terkait

Chapter 13 Review - American History

View Set

CHAPTER 11 Fluid and Electrolytes Imbalances

View Set

Chapter 23 Alternating Current Circuits

View Set

Chpt 8 A and P Appendicular skeleton

View Set

Tinker Cell Division Test Study Guide

View Set

Chapter 7: Marketing Segmentation

View Set

macro econ review questions chapter 13

View Set