IT Fundamentals Chapter 7

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

• Data modeling

• Primary Keys

• Microsoft Access

• Database Management System

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

• Primary Key

• Foreign Key

• Relationship

• Attribute

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

• Conceptual

• Operational

• Logical

• Analytical

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

• Sensor

• Transactional

• Market

• Machine

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

• DBMS

• MySQL

• Tables

• Microsoft Access

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

• Forms

• Reports

• Tables

• Queries

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

• Queries

• Forms

• Reports

• Tables

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

• Queries

• Reports

• Tables

• Forms

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

• First Name

• Employee ID

• Social Security number

• Username

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

• Instances

• Fields

• Categories

• Records