1. What SQL would an organization interested in the most popular open source DBMS on the market adopt?

MySQL; MySQL supports a relational database and is popular because it runs easily on Macintosh systems.

2. What is a formal name for questioning or making a data request from the database?

Query; a query is a request for data from a database. In most DBMS, you would type a series of statements to access data.

3. Describe Microsoft Access:

Microsoft Access is a DBMS that has rudimentary data dictionary capabilities. It has capabilities for developing desktop system applications. It works with Crystal Reports, because it has report generation capabilities.

4. What do most larger corporations utilize to consolidate data from a business along with external data?

A data warehouse. The data is stable and typically not changed once it is put into the data warehouse.

5. What is this scenario about: "David creates a central database by extracting, transforming, and loading metadata from various internal and external sources of info. He plans to use this database for executing various functions."

Data warehouse

6. What is the term for data sets with volumes so huge that they are beyond the ability of typical DBMS to capture, store, and analyze?

Big data; big data consists of unstructured or semistructured data not suitable for relational database products that organize data in the form of columns and rows.

7. What term describes data sets like Google's database that are too big for traditional DBMS to handle?

Big data; big data is used to describe data sets with volumes so huge that they are beyond the ability of typical DBMS to capture, store, and analyze.

8. What is a database whose content focuses on historical organizational data?

Data warehouse; a data warehouse is a database that stores current and historical data of potential interest to decision makers throughout the company. The data originate in many core operational transaction systems, such as systems for sales, customer accounts, and manufacturing, and can include data from website transactions.

9. What is the most popular open-source program that allows for storage of big data?

Hadoop; hadoop is an open-source software framework, managed by the Apache Software Foundation that enabled distributed parallel processing of huge amounts of data across inexpensive computers.

10. What is hadoop used for?

Hadoop is used to process large quantities of structured and transactional data (Ex. Facebook)