ITF+ TS Database

A business user wants to retrieve data from a relational database. Which of the following would they use to get the data they need?

• Markup language

• Query language

• Interpreted language

• Compiled language

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

• RETRIEVE

• SELECT

• GRANT

• CREATE VIEW

A database administrator is using the direct database access method to run several Structured Query Language (SQL) commands on a relational database.

Which of the following SQL commands helps the administrator manage permissions in the database? (Select two.)

• REVOKE

• GRANT

• UPDATE

• DELETE

Jeremy is building an application that needs access to read, write, update, and delete information in a database.

Which of the following databases does Jeremy need?

• User interface access

• Query builder

• Programmatic access

• Direct access

A value that's used to identify a record from a linked table is called a ________________.

• Primary Key

• Borrowed Key

• Linked Key

• Foreign Key

Peter is a regional sales manager for an online clothing retail company. He would like information on all the customers in his region and the purchases made by each of them during the last quarter.

Which of the following database elements can BEST provide the information Peter needs?

• Query

• Report

• Form

• Table

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

• Form

• Report

• SQL command

• Record

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?

• BACKUP

• UPDATE

• SELECT

• ALTER TABLE

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

• Username

• Employee ID

• Social Security number

• First name