Final Review (Unit 10)

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

Which database data type is a collection of binary data stored in a single field of a database?​

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

The entire Internet contains about a zettabyte of data.​

__________ are the most commonly used database clients.​​

__________ refers to a branch of data mining that analyzes current and historical data to predict future trends.​

An efficiently designed database uses computed fields whenever possible because they do not require manual data entry.

It is not possible to extract analytical data from operational databases.​

In a case-sensitive database, uppercase letters are equivalent to their lowercase counterparts.​

A(n) _____________ is a specification that the database designer sets up to filter data entered into a particular field.​

FileMaker Pro and Microsoft Access are DBMSs.​

SQL statements contain command words but do not contain data.​

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

Which of the following is not considered to be type of database client?​ a. ​Local software b. ​Browsers c. ​Apps d. ​all of the above

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

In a relational database, relationships are specified by joining common data stored in records from different tables.

Which of the following is not one of the main activities associated with operational databases?​ a. ​providing an executive dashboard for decision makers b. ​Update and find data c. ​organizing and distributing data d. ​Collect, store, and view data

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

The relationship between record types can be depicted graphically with a(n) _________.​

Which database tool is best for simple flat files that involve calculations?​

A(n) _________ database is used to collect, modify, and maintain data on a daily basis.​

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

The SQL ________ command allows you to temporarily join and simultaneously access the data in more than one table.​

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

The goal of normalization is to minimize data redundancy.

An emerging computing platform that is likely to drive innovation and disruption through the next decade called __________ has massive scale, not only in cloud-based hardware technology, but also in the vast amount of data that will be generated, consumed, and analyzed.​

A(n) __________ is the column of data in a database that is used as the basis for rearranging the data.​

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

A table's physical sort order is the order in which records are arranged on storage devices.​

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

A DBMS feature known as __________ ensures that transactions are updated in an orderly manner by establishing update rules.​

__________ is a data analysis technique used by decision makers to quickly get answers to complex queries that encompass multiple factors, such as locations, revenue, time periods, and employee status.​

SQL keywords must be entered in all uppercase letters because they are case-sensitive.​

A(n) _________ sort uses one field, to arrange records. A(n) _________ sort arranges information by more than one field.​

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

A lookup routine validates an entry by checking data in an in-house or third-party database.​

Dedicated enterprise database applications may allow cosmetic changes, but they do not encourage modifications of core data structures.​

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

Programmers insert documentation called facts into the program code.​