Databases Assessment
One of the most popular query languages is
SQL
Popular applications used by today's organizations in web mining include Google Analytics, Data Miner, and ________.
Tableau
We use a ________ field between the two database tables to create a relationship link.
common
A query can filter data based on specific ________ also known as ________. Check all that apply. criteria tables conditions reports
criteria, reports
Data centralization is necessary for maintaining ________.
data integrity
When creating a database field, we set ________ for each field to decrease data input mistakes.
data types
One of the features of using web mining is that it improves website usability. This usability refers to how easily website users can ________ with the site.
interact
A database relationship is a(n) ________ between tables that define how the data are related.
link
Before the use of computers and database management systems (DBMS), traditional files systems used ________ files, ________, and ________. Check All That Apply paper folders filing cabinets disk drives
paper, folders, filing cabinets
Databases are designed to keep data and information about different types of data objects, including objects, events, ________, and places.
people
To set a primary key field in a database table, you must click the ________ key button
primary
One reason to create database policies is to specify the ________ used in database design (how the data is structured)
rules
The purpose of information policies in a database is to indicate the ________ used in the design.
rules
Analytics platforms provide information about a variety of business and operational areas, including ________, ________, ________.
sales and marketing analytics customer analytics query analytics
A database and a DBMS are different. A database is a collection of metadata, relationships, and
tables
What object is used to store information when creating a database?
tables
One of the ways web mining improves web experiences is through site visibility. Site visibility includes how and ________ the website appears when queries are executed in a search engine.
when
What does the acronym RDBMS stand for?
Relational Database Management Systems
Doing a data quality audit helps ensure the highest quality of data being used for business intelligence and other applications. The data analysis method involves quality assessment, design, transformation, and ________.
monitoring
Data scrubbing (data cleaning) involves identifying ________ in data sets then duplicating these errors to ensure the data is accurate for an organization.
errors
