Quiz 7: Working With Databases and Mysql
Computing
Q 1Q 1
A common use of Web pages is to gather information that is stored in a database on a client PC.
Free
True False
False
Free
True False
False
Free
True False
False
Q 4Q 4
Any information that can be organized into ordered collection of data can be considered a database.
Free
True False
Free
True False
Free
True False
Q 7Q 7
Relational databases are preferred solutions for large and complex collections of information.
Free
True False
Free
True False
Q 9Q 9
A foreign key is a type of index, which identifies records in a database to make retrievals and sorting faster.
Free
True False
Free
True False
Free
True False
Q 12Q 12
You create one-to-many relationships when you want to break information into multiple, logical sets.
Free
True False
Q 13Q 13
One-to-one relationships allow you to make the information in one of the tables confidential and accessible only by certain individuals.
Free
True False
Q 14Q 14
Primary and foreign keys are the only pieces of information in a relational database table that should be duplicated.
Free
True False
Free
True False
Free
True False
Free
True False
Free
True False
Q 19Q 19
Most database management systems can import each other's file formats, and they can also read directly each other's files.
Free
True False
Free
True False
Q 21Q 21
The WHERE keyword specifies the conditions that must be met for records to be returned from a query.
Free
True False
Free
True False
Free
True False
Free
True False
Free
True False
Free
True False
Free
True False
Free
True False
Q 29Q 29
To keep your database from growing too large, you should choose the smallest data type possible for each field.
Free
True False
Q 30Q 30
MySQL assigns permissions to specify which actions and operations a user can perform with a table or database.
Free
True False
Q 31Q 31
____ 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
Free
Multiple Choice
Q 32Q 32
To make a specific database active, you must execute the ____ database statement.
A) CHANGE
B) USE
C) SWITCH
D) SELECT
Free
Multiple Choice
Q 33Q 33
To delete a database, you must execute the ____ DATABASE command.
A) DELETE
B) REMOVE
C) DROP
D) EXIT
Free
Multiple Choice
Q 34Q 34
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
Free
Multiple Choice
Q 35Q 35
You can use the ____ statement to display how a mysql table is structured.
A) DESCRIBE
B) DISPLAY
C) SHOW
D) LIST
Free
Multiple Choice
Q 36Q 36
To modify the structure of a table, you use the ____ TABLE statement.
A) MODIFY
B) ALTER
C) CHANGE
D) UPDATE
Free
Multiple Choice
Q 37Q 37
The ___ keyword is used with the ALTER TABLE statement to rename a column in a table.
A) RENAME
B) MODIFY
C) CHANGE
D) REPLACE
Free
Multiple Choice
Q 38Q 38
The ___ keyword is used with the ALTER TABLE statement to rename a table.
A) RENAME
B) MODIFY
C) CHANGE
D) REPLACE
Free
Multiple Choice
Q 39Q 39
To remove a column from an existing table, use the ___ keyword with the ALTER TABLE statement.
A) REMOVE
B) DELETE
C) DROP
D) CANCEL
Free
Multiple Choice
Free
Multiple Choice
Q 41Q 41
You use a ____ statement to create user accounts and assign privileges.
A) GIVE
B) GRANT
C) ASSIGN
D) PROVIDE
Free
Multiple Choice
Q 42Q 42
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
Free
Multiple Choice
Q 43Q 43
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
Free
Multiple Choice
Q 44Q 44
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
Free
Multiple Choice
Q 45Q 45
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
Free
Multiple Choice
Q 46Q 46
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
Free
Multiple Choice
Q 47Q 47
You use the ___ statement to retrieve records from a table.
A) RETRIEVE
B) GET
C) SELECT
D) CHOOSE
Free
Multiple Choice
Q 48Q 48
The ____ portion of the SELECT statement determines which fields to retrieve from a table.
A) attribute
B) criteria
C) command
D) select
Free
Multiple Choice
Q 49Q 49
To summarize data in a set of records, you use a family of functions called ____ functions.
A) aggregate
B) summary
C) statistical
D) group
Free
Multiple Choice
Q 50Q 50
Using the COUNT() aggregate function, you can eliminate duplicate values by using the keyword(s) ____.
A) UNIQUE
B) EXCLUSIVE
C) DISTINCT
D) UNIQUE_VALUES
Free
Multiple Choice
Q 51Q 51
You can arrange query results from a SELECT statement using the keyword(s) ____.
A) SORT
B) SORT BY
C) ORDER
D) ORDER BY
Free
Multiple Choice
Q 52Q 52
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
Free
Multiple Choice
Q 53Q 53
You can specify which records to return from a database by using the ____ keyword.
A) CRITERIA
B) MATCH
C) LIKE
D) WHERE
Free
Multiple Choice
Q 54Q 54
The ____ keyword specifies the name of the table that needs to be modified when updating records.
A) SELECT
B) MODIFY
C) UPDATE
D) CHANGE
Free
Multiple Choice
Q 55Q 55
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
Free
Multiple Choice
Q 56Q 56
A ____________________ is an ordered collection of information that a computer program can quickly access.
Free
Short Answer
Free
Short Answer
Free
Short Answer
Free
Short Answer
Free
Short Answer
Free
Short Answer
Free
Short Answer
Q 63Q 63
A(n) _____________________ relationship exists in a relational database when one record in a primary table has many related records in a related table.
Free
Short Answer
Q 64Q 64
Breaking tables into multiple related tables to reduce redundant and duplicate information is called ____________________.
Free
Short Answer
Q 65Q 65
A ____________________ table creates a one-to-many relationship for each of the tables in many-to-many relationships.
Free
Short Answer
Q 66Q 66
An application or collection of applications used to access and manage a database is called a ______________________________.
Free
Short Answer
Q 67Q 67
A ____________________ is the structure of a database, including its tables, fields, and relationships.
Free
Short Answer
Q 68Q 68
A ____________________ is a structured set of instructions and criteria for retrieving, adding, modifying, and deleting database information.
Free
Short Answer
Free
Short Answer
Free
Short Answer
Q 71Q 71
A(n) ____________________ is an alternate name that you can use to refer to a table or field in SQL statements.
Free
Short Answer
Free
Short Answer
Q 73Q 73
The MySQL built-in function, ____________________ returns the name of the currently active database.
Free
Short Answer
Q 74Q 74
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.
Free
Short Answer
Q 75Q 75
You must be logged in as the ____________________ user or have DROP privileges to delete a database.
Free
Short Answer
Q 76Q 76
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.
Free
Short Answer
Q 77Q 77
MySQL assigns _____________________ to specify which actions and operations a user can perform with a table or database.
Free
Short Answer
Q 78Q 78
Privileges can be granted at the following levels: column, table, database, and _____________________.
Free
Short Answer
Q 79Q 79
When assigning privileges the _____________________ statement creates the user account if it does not exist and assigns the specified privileges.
Free
Short Answer
Q 80Q 80
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.
Free
Short Answer
Q 81Q 81
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.
Free
Short Answer
Q 82Q 82
The criteria portion of the SELECT statement determines which fields to retrieve from a table and the _____________________ keyword specifies which records to return.
Free
Short Answer
Q 83Q 83
The ____________________ application is an open source tool written in PHP to handle the administration of MySQL databases.
Free
Short Answer