What are relational Databases?
linking fields from different tables to create complex and easily searchable databases
What is a broad and open-ended analysis of extracted data?
Data Mining
Which command is used to add, change, or remove fields on an existing table?
ALTER TABLE
Which of the following careers is responsible for backing up and securing an organization's databases?
Database administrator
What is Ms. Akers first name
Julie
What do a Foreign Keys do?
References records from different tables
What is asking specific questions to interpret Big Data called?
Data analytics
Which SQL command is used to give a user permission to a specific database object?
GRANT
Which of the following careers typically requires programming expertise in languages such as Java and Python, in addition to skills in optimizing database systems?
Database developer
Did Ms. Akers work at a police station (T or F)
True
In a relational database table, columns are better known as ________________.
Field
What are non-relational databases that deal with Big Data often referred to as?
NoSQL
Which of the following languages provides a command for inserting records into a database?
DML (Data Manipulation Language)
Which of the following careers often requires expertise in mathematics and statistics to find relevant trends and patterns in data?
Data analyst
What do bees do when they move into a new house?
They have a house swarming party
Which database feature would provide a summary of data?
Report
Which of the following needs to be done before Big Data can be analyzed and interpreted?
Data extraction
Mary needs to view all records from the Clients table. Which command should she use?
SELECT * FROM Clients
Which of the following careers requires advanced programming and analytical skills related to data mining and big data analytics?
Data scientist
What did Ms. Akers boyfriend do when they returned to the restaurant after it got robbed?
continued eating his food
What is a way for programmers and others to make sense of complex business flows?
Data Modeling
What is the technology that aggregates structured data from one or more sources called?
Data warehousing
If you wanted to generate a report from a structured database, and know no SQL commands, What would be the best option to generate the report?
Query builder
Which of the following careers often requires that one works with sales and marketing teams to analyze and interpret performance data, create reports, and recommend ways to improve company processes?
Data analyst
What is Ms. Akers Maiden name?
Behm