Chapter 7 ITF

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

• Structured
• Semi-structured
• Non-relational
• Non-structured

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

• Fields
• Instances
• Categories
• Records

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

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

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

• query builder
• constraint
• scalability
• schema

The vast amount of data collected from Internet searches, social media posts, customer transactions, military surveillance, medical tests, weather sensors, and other data sources are collectively referred to as ________________.

• Big Data
• Metadata
• Omni Data
• Business Data

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

• Tables
• Microsoft Access
• MySQL
• DBMS

Will, a database user, would like to gather some specific information from a database and then manipulate the data in a spreadsheet. Will then wants to save that information in a file format that will be used by another application. Which of the following database features would work BEST to accomplish this?

• Table
• Report
• Form
• Query

A business wants to set up a database to store customer and order information. They have decided to use a relational database. Which of the following is the main benefit of using a relational database?

• The data can be stored as unstructured data.
• The data can be organized into separate tables that are related to each other.
• The data is stored as a single file for quick retrieval.
• The data can be saved as a flat file.

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

• Forms
• Reports
• Tables
• Queries

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

• CRUD
• Database backup
• CSV
• Database dump