Exam 10: Databases

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

The goal of ______________ is to minimize data redundancy.

The SQL query language provides a collection of special command words called SQL ______________.​

In a database, a(n) __________ contains the smallest unit of meaningful information.

Four DBMS vendors are the first stop for professional developers: IBM, _________, SAS, and SAP.

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

A __________ is the column of data in a database that is used as the basis for arranging data.

​Which SQL keyword is used to search for records?

A filing cabinet full of folders and papers would be classified as a structured file because every document has a unique structure.

Dynamic scaling for database servers can be a challenge because the additional sharding has to be handled on the fly by the DBMS.​

One of the ways that databases are classified is by their structure.

In a key-value database, each data item has a key that is a unique identifier similar to a relational database key.

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

The underlying structure of a database is referred to as a database _________.

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

There are three core elements in a relational database: fields, ________, and relationships.

Spreadsheet software offers database capabilities for establishing relationships between different record types.

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

Which of the following is not an SQL keyword?

FileMaker Pro and Microsoft Access are DBMSs.