CompTIA ITF+ Database Fundamentals Questions and Answers

Question 1

A small business owner wants to store customer information, including names, addresses, and purchase histories.
They need a system that can manage relationships between customers and their orders efficiently and reduce data redundancy.
Which of the following would be the MOST suitable solution?

Accepted Answer

A relational database.

Answer

A flat-file database, like a single spreadsheet.

Answer

A word processing document for each customer.

Answer

A presentation software with a slide for each customer.

Question 2

In a relational database table for employees, each employee is assigned a unique 'EmployeeID' number that is never duplicated. What is the database term for this type of field?

Accepted Answer

Primary Key

Answer

Foreign Key

Answer

Record

Answer

Schema

Question 3

Which of the following is a standard language specifically designed for managing and querying data in a relational database?

Accepted Answer

SQL

Answer

HTML

Answer

Python

Answer

Java

Question 4

A database table contains information about students. One column in the table stores each student's first name. What is this single column, which represents one piece of information about each student, called?

Accepted Answer

A field

Answer

A record

Answer

A database

Answer

A query

Question 5

A database has a 'Customers' table with a `CustomerID` as the primary key. It also has an 'Orders' table that needs to associate each order with a specific customer. To do this, a `CustomerID` column is added to the 'Orders' table. What is the `CustomerID` column in the 'Orders' table considered?

Accepted Answer

A Foreign Key

Answer

A Primary Key

Answer

An Alternate Key

Answer

A Super Key

Question 6

A database administrator is designing a table to store product inventory. One of the columns will hold the quantity of each product in stock. Which of the following data types would be MOST appropriate for this 'Quantity' column?

Accepted Answer

Integer

Answer

String

Answer

Boolean

Answer

Date/Time

A small business owner wants to store customer information, including names, addresses, and purchase histories.They need a system that can manage relationships between customers and their orders efficiently and reduce data redundancy.Which of the following would be the MOST suitable solution?

A small business owner wants to store customer information, including names, addresses, and purchase histories.
They need a system that can manage relationships between customers and their orders efficiently and reduce data redundancy.
Which of the following would be the MOST suitable solution?