test 1 review part 7

Question 1

is an international standard for creating, processing, and querying databases and their tables

Answer 1

SQL

Question 2

a __________ of a database system will:

use a database application to track things

use forms to enter read delete and query data

produce reports

Answer 2

user

Question 3

________serves as an intermediary between database applications and the database

Answer 3

DBMS (Database Management System)

Question 4

A____________is a set of one or more computer programs that serves as an intermediary between the user and the DBMS.

Answer 4

database application

Question 5

the key role of this is to organize the data through the metadata structure. You can’t load any data until a metadata structure is there in the first place

Answer 5

DBMS

Question 6

______________(s) ensure that the values of a column in one table are valid based on the values on the values in another table

Answer 6

Referential Integrity (Constraints)

Question 7

These systems consists of tools used to analyze and report on company data.

Answer 7

Business Intelligence Systems (BI)

Question 8

_________is the current term for the enormous datasets generated by Web and mobile applications.

Answer 8

Big Data