ITF+ Databases 2

Which of the following are basic architectural components of a relational database? (Select three.)

• Records

• Fields

• Tables

• Constraints

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

• Forms

• Reports

• Queries

• Tables

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

• Queries

• Forms

• Tables

• Reports

Peter is a regional sales manager for an online clothing retail company. He would like information on all the customers in his region and the purchases made by each of them during the last quarter. Which of the following database elements can BEST provide the information Peter needs?

• Form

• Query

• Table

• Report

Edward, a database user, would like to gather some specific information from a database and then manipulate the data in a spreadsheet. Edward 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

• Query

• Report

• Form

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

• SQL command

• Record

• Tables

• Queries

An application developer needs to store configuration data that can be retrieved each time the application is launched. The data must be in a format that could be easily viewed outside of the application and edited using any editor. Which of the following would be the BEST choice?

• Database Management System

• Text-based flat file

• Relational database

• Binary flat file

Alberto works in human resources and wants to move all personnel files to a system that would provide a user interface for adding, updating, and removing personnel records. He also wants to ensure the data cannot be viewed without correct permissions. Which of the following would be the BEST option to store and retrieve this data?

• Cloud storage

• Database

• Text-based flat file

• Network share

The administrator is using the customer ID to uniquely identify each customer record. Which of the following BEST describes the customer ID field?

• Public key

• Primary key

• Foreign key

• Private key

Which of the following is a database concept that allows for storage and analysis for a few dozen to billions of data points?

• Processing speed

• Concurrent use

• Scalability

• Storage