Chapter 7 (I.T.)

What can Patricia do to make sure that each record (row) in the database is unique?

Which data type uses historical data to make decisions in the present?

Which type of analytical data can help you make investment decisions?

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

What is the computer language that make relational databases work?

Which data model focuses on high-level concepts?

Which of the following is the main benefit of using a relational database?

Which of the following DBMS programs is open source?

Which of the following makes it easier for users to enter data into their tables?

Which of the following should not be used as a primary key in a table?

Data collected on military surveillance and weather sensor is known as what?

Which of the following BEST describes the customer ID field?

Careers requires advanced programming and analytical skills related to data mining and big data analytics?

Which of the following is found in one or more columns of data and contains a unique identifier for the row?

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

Which of the following describes the purpose of a foreign key?

Which of the following careers is responsible for backing up and securing an organization's databases?

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

Which of the following would be the BEST choice?

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

User-friendly interface for adding to or retrieving information from a database

Which of the following database objects provides a summary of data?

Which of the following database access methods should the developer use?

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

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

In a relational database table, columns are better known as ________________

Which of the following is a way for programmers and others to make sense of complex business flows?

Careers often requires one works with sales and marketing teams to interpret performance data

What is the general term for software that creates and manages databases?

Stores raw data in a relational database

Which of the following database features would work BEST to accomplish this?

A value that's used to identify a record from a linked table is called a ________________

Retrieves specific information from a database. Can also be used to update, edit, and delete information

Acronyms that describes the traditional way to make sure data stays consistent across the entire database

Formatted summary of information from a database

Which database object is essentially questions that we can ask the database?

A NOT NULL __________ is a rule that prevents certain fields in a database from being left blank

Careers often requires expertise in mathematics and statistics to find relevant trends and patterns in data

What is the technology that aggregates structured data from one or more sources called?

Which of the following languages provides a command for inserting records into a database?

Careers typically requires programming expertise in languages such as Java and Python

Which of the following database features would provide a formatted, easy-to-read listing of the results of a query?

Which of the following would be her BEST option to generate the report?

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

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

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

What is asking specific questions to interpret Big Data called?

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

Amount of data collected from Internet search or social media posts collectively referred to as ________________.