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