Databases - Practice Quiz
Which of the following are advantages of using NoSQL databases?
Ability to handle large data sets Support for both structured and unstructured data Optimized for querying data from emerging digital platforms.
Which of the following are correct statements about why SQL is useful for data analytics?
Common
The acronym for Data Governance is ___.
DG
Which of the following correctly identifies how SQL is used in different industries?
Marketing to analyze sales and advertising success Finance for handling and analyzing large datasets Healthcare for patient data analysis and reporting
____ is a software with processing capabilities outside of what the operating system of the consumer provides?
Middlewear
Which database design strategy is likely to be used where transaction integrity is critical?
Normalization
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 Processing
What does the acronym RDBMS stand for?
Relational Database Management System
What does the abbreviation SQL stands for?
Structured Query Language
When creating a relationship in a relational database management system (DBMS), which object is used?
Table
Which of the following are standard SQL commands?
Update Create Drop
The Foreign Key is a ___ field between tables that is not the primary key.
common
We use a ___ field between the two database tables to create a relationship link
common
Analytics platforms provide information about a variety of business and operational areas, including ____, ____, ____.
cybersecurity sales and marketing analytics customer analytics
Using a traditional filing system (noncomputer) led to many problems like ____ and ____.
data redundancy inconsistency
Data administration tasks include the development of information policies, data planning, ____, security, and how internal-users and end-users use that data.
database design
Data marts are used to track ___, prchase transactions, and the supply chain.
inventories
The primary key field cannot hold a ___ or ____ value
null duplicate
Traditional file systems use ___, files, and documents.
paper
Before the use of computers and database management system (DBMS), traditional files systems used ___ files, ____ and ____.
paper folders filing cabinets
There are many query tools included in an RDBMS database program; those query tools include ___ queries, action queries, and ___ queries specific to the SQL.
parameter report
Databases are designed to maintain data and information about various types of data objects, including ____.
people places events
The data mining process include knowledge deployment, ___, ___, and ___.
problem definition data gathering and preparation model building and evaluation
Areas covered in digital governance include data architect, data ____, data modeling, data warehousing, and data security
quality
Which of the following are primary functions of SQL in database management?
query data manipulating data defining data
RDBMS (Relational Database Management System) elements include features that maintain data ___, accuracy, integrity, and ____.
security consistency
SoSQL (non-relational databases) are also useful for querying the data generated by ____ sites, ____ apps, and other emerging digital content sources
social 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
Crosstab queries calculate the ____, ____ or other aggregate functions, then group two sets of values into the results.
sum average
Parameter queries prompt the user for ___ to run a query
values
