Databases Assesment

What does the acronym RDBMS stand for?

Relational Database Management Systems

What does the abbreviation SQL stand for?

Structured Query Language

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

WCM, WSM & WUM

Data governance policies help to ensure an organization's data is valid, understandable, complete, and ________.

accesible

Data integrity means the database is reliable, ________, and aligned to the goals of the organization.

accurate

To create a relationship between two tables, you must use a ________ field that is present in both tables.

common

A query can filter data based on specific ________ also known as ________.

criteria conditions

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

data mining

Databases are designed to maintain data and information about various types of data objects, including ________.

eventsevents peoplepeople places

Data centralization is critical for increasing data ________.

integrity

Database forms structure data input to ensure data ________.

integrity

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

inventories

A database relationship is a(n) ________ between tables that define how the data are related.

link

Traditional file systems use ________, files, and documents.

paper

RAM storage and ________ processing are two main in-memory computing components.

parallel

To set a primary key field in a database table, you must click the ________ key button.

primary

What type of field is used in both tables to create a relationship?

primary

The major advantages of executing a data quality audit include ________.

reduced risk of data inconsistencyreduced risk of data inconsistency reduced data storage costsreduced data storage costs data improvement recommendations

A database record is also referred to as a ________ in the table.

row

Information in a database table is made up of ________ called records or objects, and ________ called fields.

rows columns

Analytics platforms provide information about a variety of business and operational areas, including ________, ________, ________.

sales and marketing analyticsanalytics customer analytics query analytics

Relational databases organize data into ________ based on structured data groupings.

tables

Parameter queries prompt the user for ________ to run a query.

values

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

Key features of cloud databases include...

Enterprise users are able to host databases without the need to buy and maintain specialized hardwareEnterprise users are able to host databases without the need to buy and maintain specialized hardware Can be self-managed or maintained and managed by a providerCan be self-managed or maintained and managed by a provider Accessed through the web or an API supported by the vendor (Application Programming Interface)Accessed through the web or an API supported by the vendor (Application Programming Interface) Support SQL and NoSQL databases

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

statistical

Data marts assist with the ________ of what data a user needs rather than focusing on existing data.

analysis

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

duplicate null

Data scrubbing (data cleaning) involves identifying ________ in data sets then duplicating these errors to ensure the data is accurate for an organization.

errors

When multiple lists and data integrity. sources are maintained, information can become ________, leading to decreased data

lost

Some of the duties a database administrator performs include ________.

securitysecurity tuningtuning backup

SoSQL (non-relational databases) are also useful for querying the data generated by ________ sites, ________ apps, and other emerging digital content sources.

social mediasocial media mobile

SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the ________ language for relational database management systems.

standard