Deck 7: Working With Databases and Mysql

Question 1

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

Answer 1

False

Question 2

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

Answer 2

False

Question 3

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

Answer 3

False

Question 4

Each row in a database is called a record.

Question 5

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

Question 6

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

Question 7

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

Question 8

Database management systems can run on only a single platform.

Question 9

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

Question 10

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

Question 11

MySQL is part of PHP.

Question 12

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

Question 13

MySQL is a commercial product and is not free.

Question 14

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

Question 15

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

Question 16

SQL stands for sequential query language.

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

You can edit commands entered previously in the MySQL Monitor.

Question 22

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

Question 23

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

Question 24

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

A) RENAME
B) MODIFY
C) CHANGE
D) REPLACE

Question 25

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

Question 26

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

Question 27

What privilege allows the user to select records?

A) CREATE
B) ALTER
C) INDEX
D) SELECT

Question 28

____ 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

Question 29

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

Question 30

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

Question 31

To delete a database, you must execute the ____ DATABASE command.

A) DELETE
B) REMOVE
C) DROP
D) EXIT

Question 32

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

A) REMOVE
B) DELETE
C) DROP
D) CANCEL

Question 33

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

Question 34

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

A) RENAME
B) MODIFY
C) CHANGE
D) REPLACE

Question 35

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

Question 36

To make a specific database active, you must execute the ____ database statement.

A) CHANGE
B) USE
C) SWITCH
D) SELECT

Question 37

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

Question 38

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

A) DESCRIBE
B) DISPLAY
C) SHOW
D) LIST

Question 39

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

Question 40

To modify the structure of a table, you use the ____ TABLE statement.

A) MODIFY
B) ALTER
C) CHANGE
D) UPDATE

Question 41

The ____ keyword specifies the name of the table that needs to be modified when updating records.

A) SELECT
B) MODIFY
C) UPDATE
D) CHANGE

Question 42

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

Question 43

A. ____________________ database stores information in a single table.

Question 44

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

Question 45

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

Question 46

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

Question 47

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

A) RETRIEVE
B) GET
C) SELECT
D) CHOOSE

Question 48

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

Question 49

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

Question 50

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

A) attribute
B) criteria
C) command
D) select

Question 51

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

A) GIVE
B) GRANT
C) ASSIGN
D) PROVIDE

Question 52

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

Question 53

____________________ databases consist of one or more related tables.

Question 54

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

A) aggregate
B) summary
C) statistical
D) group

Question 55

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

Question 56

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

A) UNIQUE
B) EXCLUSIVE
C) DISTINCT
D) UNIQUE_VALUES

Question 57

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

Question 58

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

A) SORT
B) SORT BY
C) ORDER
D) ORDER BY

Question 59

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

A) CRITERIA
B) MATCH
C) LIKE
D) WHERE

Question 60

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

Question 61

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

Question 62

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

Question 63

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

Question 64

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.

Question 65

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

Question 66

A related table is also called a ____________________ table.

Question 67

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

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

Identifiers in MySQL are quoted using the ____________________ character.

Question 74

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

Question 75

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

Question 76

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

Question 77

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.

Question 78

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

Question 79

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.

Question 80

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