CompTIA Standard 7 & 8 Exam Review

Front

Which of the following is a way for programmers and others to make sense of complex business flows?
Options: Data Modeling, Primary Keys, Microsoft Access, Database Management System

Back

Data Modeling

Front

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

Back

Primary Key

Front

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

Back

Conceptual

Front

Which of the following should not be used as a primary key in a table?
First name,
Employee ID,
Username,
Social Security Number

Back

First name

Front

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

Back

Fields

Front

Which of the following database features would provide a formatted, easy-to-read listing of the results of a query? Options: SQL Command, Form, Record, Report

Back

Report

Front

What is the computer language that makes relational databases work?

Back

SQL

Front

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

Back

GRANT

Front

Which process exports a database into a format that can be read by another program like a spreadsheet? Options: Database backup, CRUD, CSV, Database dump

Back

Database dump

Front

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

Back

Semi-structured