1. The common characteristics of big data include

a. volume

b. variety

c. veracity

d. velocity

2. Four types of action queries are included in many RDBMS these include ________, ________, ________, and make-table.

a. append

b. delete

c. update

d. modeling

3. Which of the following are standard SQL commands?

a. update

b. create

c. drop

d. add

4. A cloud database is a type of database that is ________ and ________ via a cloud platform.

a. built, created

b. accessed

c. queried

d. reported

5. An ERD requires the use of various ________ and ________ that help visualize two types of information: the entities within the system and the interrelationship among the entities.

a. symbols

b. connectors

c. oppositions

d. tables

6. Referential integrity is the ________ and ________ of data within a table relationship in a database.

a. accuracy

b. consistency

c. development

d. relationship

7. Data redundancy is the ________ of data.

a. storage

b. duplication

c. details

d. reduction

8. The Foreign Key is a ________ field between tables that is not the primary key.

a. record

b. null

c. common

d. primary

9. Before the use of computers and database management systems (DBMS), traditional files systems used ________ files, ________, and ________.

a. paper

b. folders

c. filing cabinets

d. disk drives

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

a. reduced risk of data inconsistency

b. reduced data storage costs

c. data improvement recommendations

d. financial benefits for customers

11. RDBMS (Relational Database Management System) elements include features that maintain data ________, accuracy, integrity, and ________.

a. security

b. consistency

c. metadata

d. management