Exam 7: Working With Databases and Mysql

If you install a local version of MySQL, by default the mysql database and the ____________________ database, which is used to ensure that the database is working correctly, are installed.

To summarize data in a set of records, you use a family of functions called ____ functions.

To remove a column from an existing table, use the ___ keyword with the ALTER TABLE statement.

You use a ____ statement to create user accounts and assign privileges.

When viewing the structure of a database table, the ____________________ column shows the value that will be inserted automatically in the field if no value is specified.

By default, field values in an external text file that are being inserted in a table are separated by the ____ keyboard character.

A ____________________ in a database is a single complete set of related information.

The ___ keyword is used with the ALTER TABLE statement to rename a table.

Using the COUNT() aggregate function, you can eliminate duplicate values by using the keyword(s) ____.

Most relational database systems cannot work directly with many-to-many relationships.

To perform a reverse sort on query results from a SELECT statement, add the ___ keyword after the name of the field by which you want to perform the sort.

You know you have successfully logged into MySQL when you see the mysql> prompt.

The MySQL built-in function, ____________________ returns the name of the currently active database.

A ____________________ table creates a one-to-many relationship for each of the tables in many-to-many relationships.

You can specify which records to return from a database by using the ____ keyword.

You must be logged in with the ____ account or have sufficient privileges to take away privileges from another user account.

A ____________________ is an ordered collection of information that a computer program can quickly access.

The WHERE keyword specifies the conditions that must be met for records to be returned from a query.

The INSERT keyword determines the table into which records should be inserted.

You can use the ____ statement to display how a mysql table is structured.