TestOut CompTIA ITF Databases 20 Questions

Front

Which SQL command lets you view information stored in a database?

Back

SELECT

Front

What is the main benefit of using a relational database for storing customer and order information?

Back

The data can be organized into separate tables that are related to each other.

Front

Which feature provides for the security and integrity of the data in a database?

Back

User privilege levels

Front

Which process involves the information stored in a database, where the database is hosted, and how clients can access the data?

Back

Creation

Front

Marty, a database administrator, needs to build a database query that will return the results from the start of January through the end March. Which command would be used?

Back

SELECT

Front

A database administrator wants to export a table as a backup before changes are made to the table structure. Which command should be executed?

Back

BACKUP

Front

A database administrator wants to create a copy of an entire database. Which SQL command can be used to create the copy?

Back

BACKUP DATABASE database_name

Front

What is the purpose of a foreign key in a database?

Back

For one table to reference records in another table.

Front

An IT administrator wants to provide a graphical interface tool for company sales representatives to quickly find product information and pricing in a relational database (without using SQL commands).

Back

Query builder

Front

Which of the following BEST describes the permissions a user has for a database object after creating the object while logged into their user account?

Back

The object's creator has complete control over that object.