TestOut 7.4 and 7.5

Which is asking specific questions to interpret Big Data called?

Data analytics

Which of the following acronyms describes the traditional way to make sure data stays consistent across the entire database?

ACID

Which command is used to add, change, or remove fields on an existing table?

ALTER TABLE

The vast amount of data collected from Internet searches, social media posts, customer transactions, military surveillance, medical tests, weather sensors, and other data sources are collectively referred to as ___.

Big Data

Vast amounts of data collected and stored online based on internet searches, social media posts, customer transactions, military surveillance, medical tests, and weather sensors. What is this known as?

Big Data

Which of the following are the four general tasks a user needs to perform for a database to function properly?

Create, Read, Update, Delete

The concern that Big Data is often obtained without the knowledge or consent of users falls under which Big Data concept?

Data ethics

Which of the following needs to be done before Big Data can be analyzed and interpreted?

Data extraction

Which is the technology that aggregates structured data form one or more sources called?

Data warehousing

Which process exports a database into a format that can be read by another program like a spreadsheet?

Database dump

Which SQL command is used to give a user permission to a specific database object?

GRANT

What are non-relational databases that deal with Big Data often referred to as?

NoSQL

A developer is working on an application that needs to be able to read, write, update, and delete database records. Which of the following database access methods should the developer use?

Programmatic access

Which of the following can be used to ask a database questions and receive the data we're looking for?

Queries

Gina is a database user and her supervisor has asked her to generate a report from the structured database. Gina does not know how to write SQL commands and no forms have been created. Which of the following would be here BEST option to generate the report?

Query builder

Mary needs to view all records from the Clients table. Which command should she use?

SELECT* FROM Clients

Mary needs to view the records from the Clients table that pertain to Travis. Which command should she use?

SELECT* FROM Clients WHERE name=

What is the computer language that makes relational database work?

SQL

Which type of data have elements in common but do not fit into rigid rows and columns in a table?

Semi-structured

An application developer needs to store configuration data that can be retrieved each time the application is launched. The data must be in a format that could be easily viewed outside of the application and edited using any editor. Which of the following would be the BEST choice?

Text-bases flat file