Comptia IT F CH7

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

• database management system
• Primary keys
• Microsoft Access
• Data modeling

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

• Primary key
• attribute
• relationship
• foreign key

What data model focuses on high-level Concepts?

• Operational
• conceptual
• physical
• logical

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

• Analytical
• operational
• conceptual
• logical

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

• Transactional
• sensor
• machine
• Market

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

• Table
• DPMS
• Microsoft Access
• mySQL

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

• Reports
• tables
• forms
• Queries

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

• Forms
• Tables
• Reports
• Queries

Which of the following DBMS programs is open source?

• Oracle database
• SQL Server
• Microsoft Access
• MySQL

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

• Queries
• reports
• forms
• tables