Exam 7: Working With Databases and Mysql

Relational databases are preferred solutions for large and complex collections of information.

Primary and foreign keys link records across multiple tables in a relational database.

Any information that can be organized into ordered collection of data can be considered a database.

When accessing databases with PHP, you must use a data manipulation language.

The ____ portion of the SELECT statement determines which fields to retrieve from a table.

You can arrange query results from a SELECT statement using the keyword(s) ____.

You use the ___ statement to retrieve records from a table.

____ reduces the size of a database and makes the data easier to work with.

For simple collections of information, flat-file databases are usually adequate.

You enter SQL commands in MySQL Monitor program at the ____________________ command prompt.

A ____________________ is a structured set of instructions and criteria for retrieving, adding, modifying, and deleting database information.

MySQL Monitor is a command-line program for manipulating MySQL databases.

The "Test" database is automatically selected when you log into MySQL.

Use the ____ statement to add multiple records from an external file to a database table.

To store text in a field, you specify a data type of ____ because the amount of storage space allocated will depend on the number of characters in the field.

When inserting records in a database table using the INSERT statement, if you omit the _____________________ list, the values you enter in the VALUES list must be in the same order in which you defined the table fields and each field in the table must have a value.

MySQL assigns _____________________ to specify which actions and operations a user can perform with a table or database.

phpMyAdmin provides a convenient method of transferring files from the development server to the production server using the _____ process.

The ____ statement is used to take away privileges from an existing user account for a specified table or database.

A(n) ____________________ is an alternate name that you can use to refer to a table or field in SQL statements.