TS databases 2

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

• Data modeling

• Microsoft Access

• Primary keys

• Database management system

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

• Foreign key

• Primary key

• Relationship

• Attribute

Which data model focuses on high-level concepts?

• Logical

• Physical

• Conceptual

• Operational

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

• Operational

• Analytical

• Logical

• Conceptual

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

• Machine

• Sensor

• Market

• Transactional

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

• Tables

• MySQL

• DBMS

• Microsoft Access

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

• Forms

• Queries

• Reports

• Tables

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

• Tables

• Reports

• Queries

• Forms

Which of the following DBMS programs is open source?

• SQL Server

• Microsoft Access

• MySQL

• Oracle Database

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

• Reports

• Tables

• Forms

• Queries