Test Bank for Murach’s MySQL, 4th Edition by Joel Murach

Chapter 1: An introduction to relational databases
Murach's MySQL 4th Edition

MULTIPLE CHOICE

1. Which of the following is not usually a hardware component of a client/server system?
a. network c. printer
b. client d. server
ANS: C

2. The processing that’s done by the DBMS is typically referred to as...
a. front-end processing c. the file server
b. back-end processing d. the user interface
ANS: B

3. The interface between an application program and the DBMS is usually provided by the...
a. back end c. data access API
b. front end d. programmer
ANS: C

4. A single table in a relational database consists of...
a. rows only c. rows and columns
b. columns only d. multiple matrixes
ANS: C

5. The intersection of a row and column is commonly called a...
a. record c. box
b. field d. cell
ANS: D

6. To uniquely identify each row in a table, you can define a...
a. primary key c. foreign key
b. default value d. one-to-one relationship
ANS: A

7. Which of the following types of relationships can a relational database not define?
a. one-to-many c. one-to-one
b. zero-to-many d. many-to-many
ANS: B

8. How would you identify the many side of a relationship between two tables in a database?
a. By defining a foreign key in one table that’s related to a foreign key in the other table
b. By defining a foreign key in one table that’s related to the primary key in the other table

, c. By defining a primary key in one table that’s related to the primary key in the other table
d. By defining a primary key in one table that’s related to a unique key in the other table
ANS: B

9. What determines the kind of data that can be stored in a column of a table?
a. The default value that’s assigned to the column
b. The data type that’s assigned to the column
c. The relationship between the column and the primary key of the table
d. Whether the column can contain a null value
ANS: B

10. If you define a column with a default value, that value is used whenever a row...
a. is added to the table
b. in the table is updated
c. that doesn’t include a value for that column is added to the table
d. with a null value for that column is added to the table
ANS: C

11. What is the name of a diagram that can be used to show how the tables in a MySQL database are
defined and related?
a. table relationship c. object relationship
b. enhanced entity relationship d. one to many relationship
ANS: B

12. The SQL statements that work with the data in a database are called...
a. data manipulation language statements c. data modification language statements
b. data definition statements d. data object statements
ANS: A

13. Which of the following types of SQL statements is not a DML statement?
a. INSERT c. SELECT
b. UPDATE d. CREATE TABLE
ANS: D

14. Which of the following types of statements does not modify the data in a table?
a. SELECT c. UPDATE
b. INSERT d. DELETE
ANS: A

15. The result of a SELECT statement is called...
a. a result set c. a stored procedure
b. a calculated value d. a query
ANS: A

16. The type of operation that retrieves data from two or more tables is called a...

,a. consolidation c. join
b. combination d. match
ANS: C

, Chapter 2: How to use MySQL Workbench and other development tools
Murach's MySQL 4th Edition

MULTIPLE CHOICE

1. Before you can use MySQL Workbench to work with a MySQL database, you must...
a. create a user other than the root user
b. open a connection to the server the database is on
c. configure the connection to the server via the MySQL Command Line Clinet
d. create a default schema
ANS: B

2. The MySQL database server can also be referred to as the...
a. database controller c. database driver
b. database engine d. database manager
ANS: B

3. Which of the following is not a database object in MySQL?
a. table c. EER diagram
b. view d. function
ANS: C

4. Which of the following can you do when working with a table in MySQL Workbench?
a. view the column definitions for the table
b. view the data for the table
c. edit the column definitions for the table
d. all of these
ANS: D

5. Which of the following is not a common error when entering and executing SQL statements?
a. misspelling a keyword
b. misspelling the name of a table
c. selecting the wrong database
d. accidentally typing two spaces in a row
ANS: D

6. When you run a script that contains a coding error, the error message that MySQL Workbench
displays does not include...
a. an error code
b. brief description of the error
c. the likely cause of the error
d. which statement caused the error
ANS: C

7. A file that contains one or more SQL statements is called a...