Database Quiz

The essential RDBMS functions; create, read, update, and delete data is collectively referred to as which acronym?

CRUD

Analytics platforms are designed to assist small data-driven companies in the analysis and interpretation of organizational data. True/False

False

Common data administration duties include the development of information policies, data planning, data mining, security, and how internal-users and end-users use that data. True/False

False

In a database relationship, you can delete a primary key field if there is an associated foreign key record. True/False

False

When data is centralized, it means data is harder to maintain. True/False

False

What does the acronym RDBMS stand for? Redundant Database Management Systems Referential Database Management Systems Relational Database Management Systems Records of Database Management Systems

Relational Database Management Systems

Popular applications used by today's organizations in web mining include Google Analytics, Data Miner, and ________. Tab Miner Tableau Tanalytics Tablet

Tableau

A cloud database platform includes the hardware and operating environment of servers in an internet-based datacenter. True/False

True

Middleware is software that provides processing capabilities outside what is offered by the user's operating system. True/False

True

Using a Database Management System (DBMS) increases data security by using ________ so that only authorized users can access data. access rules storage times data storage fees

access rules

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

accessible

When data is stored in one place, it means it is ________. critical locked increasing centralized

centralized

A record is a ________ of related fields in a data file. characteristic button collection highlighted area

collection

Online Analytical Processing (OLAP) is included in many Business Intelligence (BI) software applications. We use this OLAP for a range of ________ discovery activities, including report creation and analysis, analytical calculations, forecasting, budgeting, planning, and what-if predicative analysis. analyzed query report data

data

We use database forms to control how ________ enters a database. data tables data integrity formulas

data

When creating a database field, we set ________ for each field to decrease data input mistakes. data relationships data descriptions data forms data types

data types

Reports offer a way to view, format, and summarize the information in a ________. platform report field database

database

Data administration tasks include the development of information policies, data planning, ________, security, and how internal-users and end-users use that data. database users database design database abrogation administration

database design

A dependent data mart is constructed from ________ warehouses and utilize a top-down approach where organizational data is stored in a centralized location. Specific data is extracted when an analysis is needed. assimilated separate existing integrated

existing

Database Management Systems (DBMS) assign users different access rules to protect the data and users from ________, data leaks, and the misuse of data. bad information inefficient access times identity theft sharing images

identity theft

A hybrid data mart ________ data from a data warehouse as well as other data collection systems. It incorporates a top-down approach, end-user inputs, and enterprise-level integration. isolates extracts integrates detracts

integrates

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

link

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 managing marketing intelligence

monitoring

What does the acronym NoSQL stand for? non-relational databases now-relational databases no-relational databases new-relational databases

non-relational databases

RAM storage and ________ processing are two main in-memory computing components. intricate parallel outside unparallel

parallel

A ________ key must contain a unique value. relationship primary foreign secondary

primary

Areas covered in digital governance include data architecture, data ________, data modeling, data warehousing, and data security. accessibility policies scrubbing quality

quality

Database policies should be created and implemented by all organizations, regardless of the ________ of the organization. strength security database size

size

A database and a DBMS are different. A database is a collection of metadata, relationships, and ________. forms queries reports tables

tables

Relational databases organize data into ________ based on structured data groupings. reports queries forms tables

tables

What object is used to store information when creating a database? reports tables queries forms

tables

OLAP software allows users to perform multidimensional analysis of a wide range of business data, complex calculations, and trend analysis, as well as data modeling. What does OLAP stand for? Online Analytical Performance Online Analytical Processing Online Analytical Projection Online Analytical Predictions

Online Analytical Processing

In a data warehouse, data is analyzed using business intelligence (BI) tools, ________ clients, and a variety of analytics applications designed to interpret the data. MS Access SQL Window analytical applications

SQL

One of the most popular query languages is ________.

SQL

A data mart is a division of a data warehouse explicitly built and constructed for individual departments or business functions. True/False

True

A data warehouse is a storehouse of data and information that organizations analyze to make informed business and operational decisions. True/False

True

Action queries (except for make-table queries that create new tables) make changes or move data in tables (records) on which they are based. True/False

True