TestOut CompTIA ITF Databases 20 Questions

Which of the following is a Structured Query Language (SQL) command that lets you view information stored in a database?

• GRANT

• RETRIEVE

• SELECT

• CREATE VIEW

A business wants to set up a database to store customer and order information. They have decided to use a relational database. Which of the following is the main benefit of using a relational database?

• The data can be stored as unstructured data.

• The data is stored as a single file for quick retrieval.

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

• The data can be saved as a flat file.

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

• Data encryption

• Anti-malware protection

• Device passwords

• User privilege levels

There are several processes related to database usage. Which of the following involves the information stored in a database, where the database is hosted, and how clients can access the data?

• Reports

• Queries

• Creation

• Storage

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 of the following commands would be used?

• INSERT

• ALTER TABLE

• UPDATE

• SELECT

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

• SELECT

• ALTER TABLE

• UPDATE

• BACKUP

A database administrator wants to create a copy of an entire database. Which of the following SQL (Structured Query Language) commands can the administrator use to create the copy?

• CREATE BACKUP DATABASE database_name

• BACKUP database_name

• BACKUP DATABASE database_name

• CREATE BACKUP database_name

Marty, a database administrator, has added a foreign key to a table in a database. Which of the following describes the purpose of a foreign key?

• For one database to reference another database.

• To provide a way to distinguish records within a table.

• For one table to reference records in another table.

• To allow the storage of unstructured data.

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).

Which of the following would provide the type of access the sales representatives need?

• DBMS (database management system)

• Query builder

• User interface access

• Collaboration software

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?

• The object's creator can deny permissions to the object for other user accounts.

• The object's creator is limited to permissions given by the GRANT command.

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

• The object's creator has all permissions for the object, except those limited by the DENY command.