Quiz 7: Working With Databases and Mysql

A common use of Web pages is to gather information that is stored in a database on a client PC.

MySQL is a commercial product and is not free.

MySQL is part of PHP.

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

Each row in a database is called a record.

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

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

A related table is the main table in a relationship that is referenced by another table.

A foreign key is a type of index, which identifies records in a database to make retrievals and sorting faster.

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

There are four basic types of relationships within a relational database.

You create one-to-many relationships when you want to break information into multiple, logical sets.

One-to-one relationships allow you to make the information in one of the tables confidential and accessible only by certain individuals.

Primary and foreign keys are the only pieces of information in a relational database table that should be duplicated.

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

Database management systems can run on only a single platform.

SQL stands for sequential query language.

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

Most database management systems can import each other's file formats, and they can also read directly each other's files.

You should always use direct database access functionality if it is available in PHP.

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.

Apache, PHP, and MySQL are all examples of open-source software.

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

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

You can edit commands entered previously in the MySQL Monitor.

When you create a new database, the new database automatically becomes the active database.

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

To keep your database from growing too large, you should choose the smallest data type possible for each field.

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

____ reduces the size of a database and makes the data easier to work with. A) The primary key B) The foreign key C) The child key D) Normalization

To make a specific database active, you must execute the ____ database statement. A) CHANGE B) USE C) SWITCH D) SELECT

To delete a database, you must execute the ____ DATABASE command. A) DELETE B) REMOVE C) DROP D) EXIT

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. A) TEXT B) CHAR C) CONTENT D) VARCHAR

You can use the ____ statement to display how a mysql table is structured. A) DESCRIBE B) DISPLAY C) SHOW D) LIST

To modify the structure of a table, you use the ____ TABLE statement. A) MODIFY B) ALTER C) CHANGE D) UPDATE

The ___ keyword is used with the ALTER TABLE statement to rename a column in a table. A) RENAME B) MODIFY C) CHANGE D) REPLACE

The ___ keyword is used with the ALTER TABLE statement to rename a table. A) RENAME B) MODIFY C) CHANGE D) REPLACE

To remove a column from an existing table, use the ___ keyword with the ALTER TABLE statement. A) REMOVE B) DELETE C) DROP D) CANCEL

What privilege allows the user to select records? A) CREATE B) ALTER C) INDEX D) SELECT

You use a ____ statement to create user accounts and assign privileges. A) GIVE B) GRANT C) ASSIGN D) PROVIDE

The ____ statement is used to take away privileges from an existing user account for a specified table or database. A) REMOVE B) DROP C) DELETE D) REVOKE

You must be logged in with the ____ account or have sufficient privileges to take away privileges from another user account. A) base B) global C) root D) source

When inserting a new record in a table, you must specify the keyword(s) ____ for any fields in which you do not have a value. A) NULL B) BLANK C) VOID D) NO VALUE

Use the ____ statement to add multiple records from an external file to a database table. A) INSERT_RECORDS B) ADD_RECORDS C) INSERT_DATA D) LOAD_DATA

By default, field values in an external text file that are being inserted in a table are separated by the ____ keyboard character. A) comma B) semicolon C) space D) tab

You use the ___ statement to retrieve records from a table. A) RETRIEVE B) GET C) SELECT D) CHOOSE

The ____ portion of the SELECT statement determines which fields to retrieve from a table. A) attribute B) criteria C) command D) select

To summarize data in a set of records, you use a family of functions called ____ functions. A) aggregate B) summary C) statistical D) group

Using the COUNT() aggregate function, you can eliminate duplicate values by using the keyword(s) ____. A) UNIQUE B) EXCLUSIVE C) DISTINCT D) UNIQUE_VALUES

You can arrange query results from a SELECT statement using the keyword(s) ____. A) SORT B) SORT BY C) ORDER D) ORDER BY

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. A) REVERSE B) DESC C) A-Z D) Z-A

You can specify which records to return from a database by using the ____ keyword. A) CRITERIA B) MATCH C) LIKE D) WHERE

The ____ keyword specifies the name of the table that needs to be modified when updating records. A) SELECT B) MODIFY C) UPDATE D) CHANGE

phpMyAdmin provides a convenient method of transferring files from the development server to the production server using the _____ process. A) download/upload B) source/destination C) browse/select D) export/import

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

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

____________________ are the individual categories of information stored in a record.

A. ____________________ database stores information in a single table.

____________________ databases consist of one or more related tables.

A related table is also called a ____________________ table.

Tables in a relationship are connected using primary and foreign ____________________.

A(n) _____________________ relationship exists in a relational database when one record in a primary table has many related records in a related table.

Breaking tables into multiple related tables to reduce redundant and duplicate information is called ____________________.

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

An application or collection of applications used to access and manage a database is called a ______________________________.

A ____________________ is the structure of a database, including its tables, fields, and relationships.

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

SQL statements are composed of ____________________ that perform actions on a database.

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

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

Identifiers in MySQL are quoted using the ____________________ character.

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

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.

You must be logged in as the ____________________ user or have DROP privileges to delete a database.

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.

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

Privileges can be granted at the following levels: column, table, database, and _____________________.

When assigning privileges the _____________________ statement creates the user account if it does not exist and assigns the specified privileges.

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.

In order to use the LOAD_DATA statement, your account needs to be given _____________________ privileges to access any files on the server that are available to the MySQL server account.

The criteria portion of the SELECT statement determines which fields to retrieve from a table and the _____________________ keyword specifies which records to return.

The ____________________ application is an open source tool written in PHP to handle the administration of MySQL databases.