CompTIA Standard 4 Exam Review

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?

• Relationship

• Foreign Key

• Primary Key

• Attribute

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

• Conceptual

• Logical

• Operational

• Conceptual

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

• First name

• Employee ID

• Username

• Social Security Number

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

• Records

• Fields

• Categories

• Records

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

• SQL Command

• Form

• Record

• Report

What is the computer language that makes relational databases work?

• Java

• Python

• C++

• SQL

Which SQL command is used to give a user permission to a specific database object?

• REVOKE

• GRANT

• UPDATE

• VALUES

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

• Database backup

• CRUD

• CSV

• Database dump

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

• Structured

• Non-structured

• Non-relational

• Semi-structured