Databases Test

SQL keywords must be entered in all uppercase letters because they are case-sensitive. (T/F)

False

Spreadsheet software offers database capabilities for establishing relationships between different record types. (T/F)

False

_________ is a file system developed in 2005 that handles millions of files distributed across multiple server nodes.

Hadoop

Ten terabytes offer enough storage capacity to hold the printed collection of the Library of Congress. (T/F)

True

The term _________ refers to huge collections of data that are difficult to process, analyze, and manage using conventional database tools.

big data

Modern database tools support ________________, which entails separating data from the programs that manipulate data.

data independence

When joining two tables using SQL, the convention is to use ______ notation for field names.

dot

Which of the following is not considered to be type of database client?

local software, browsers, apps

The goal of ____________ is to reduce data redundancy.

normalization

Which of the following is not one of the main activities associated with operational databases?

providing an executive dashboard for decision makers

Computer programming languages designed for databases are called __________ languages because one of their main capabilities is to request data from a database

query

In a database, a(n) ________ refers to a collection of data fields.

record

A(n) ___________ is a software tool for specifying the content and format for a database report.

report generator

A ________ solution for data storage adds resources to a single device, while a __________ solution adds more devices to a system.

scale up, scale out

The term database __________ refers to the arrangement of fields, tables, and relationships in a database.

structure

A(n) _____________ file uses a uniform format to store data for each person or thing in the file.

structured

The acronym _______ refers to software that manages data stored in a database.

DBMS

One of the most common database operations is to query for a particular record or group of records by using the _______ command.

SELECT

Which of the following would not be considered a database data type?

SELECT

A(n) ________ database is used to collect data that will be used for spotting trends that offer insights for tactical and strategic business decisions.

analytical