Database2 DIT

Gina is a database user and her supervisor has asked her to generate a report from the structured database. Gina does not know how to write SQL commands and no forms have been created. Which of the following would be her BEST option to generate the report?

• Query builder

• Programmatic access

• Direct access

• User interface access

A developer is working on an application that needs to be able to read, write, update, and delete database records. Which of the following database access methods should the developer use?

• Query builder

• Direct access

• Programmatic access

• User interface access

What is the computer language that makes relational databases work?

• Python

• C++

• SQL

• Java

Which command is used to add, change, or remove fields on an existing table?

• INSERT INTO

• DROP TABLE

• ALTER TABLE

• CREATE TABLE

Mary needs to view all records from the Clients table. Which command should she use?

• SELECT ^ FROM Clients

• WHERE * FROM Clients

• WHERE ^ FROM Clients

• SELECT * FROM Clients

Mary needs to view the records from the Clients table that pertain to Travis. Which command should she use?

• SELECT ^ FROM Clients WHERE name = Travis

• UPDATE * FROM Clients WHERE name = Travis

• SELECT * FROM Clients WHERE name = Travis

• SELECT Travis FROM Clients

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

• VALUES

• UPDATE

• REVOKE

• GRANT

Which process exports a database into a format that can be read by another program like a spreadsheet?

• Database dump

• Database backup

• CRUD

• CSV

Which of the following are the four general tasks a user needs to perform for a database to function properly?

• Create, Read, Unleash, Deny

• Create, Reuse, Unleash, Delete

• Configure, Read, Update, Deny

• Create, Read, Update, Delete

Which of the following can be used to ask a database questions and receive the data we're looking for?

• Queries

• Tables

• Reports

• Forms