CSIS 110 Chapter 7.4.16 Liberty University - CSIS 110

CSIS 110 Chapter
7.4.16
1. Gina is a database user and her supervisor
Query Builder
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?

2. A developer is working on an application that Programmatic access
needs to be able to read, write, update, and
delete database records. Which of the following
database access meth- ods should the
developer use?
SQL
3. What is the computer language that makes
relational databases work?
ALTER TABLE
4. Which command is used to add, change, or
remove fields on an existing table?
SELECT * FROM Clients
5. Mary needs to view all records from the Clients
table. Which command should she use?
SELECT * FROM Clients
6. Mary needs to view the records from the WHERE name = Travis
Clients table that pertain to Travis. Which
command should she use?

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

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

9. Which of the following are the four general tasks a user Create,
Read, Update,
1/
3