Question 1

When a subquery is used in a SQL statement _____.

Accepted Answer

A)   the subquery is evaluated first
B)   a temporary table is created and displayed
C)   the outer query is evaluated first
D)   only the subquery can include a WHERE clause

Question 2

Which clause is used to restrict the groups that will be included in a query result?

Accepted Answer

A)   LIKE
B)   HAVING
C)   WHERE
D)   HAVE

Question 3

What does the following SQL query do? SELECT INVOICE_NUM FROM INVOICE_LINE WHERE PROD_CODE IN (SELECT PROD_CODE FROM PRODUCTS WHERE (PROD_TYPE = 'Cupcake') ) ;

Accepted Answer

A)   cause an error because it includes more than one SELECT command
B)   lists all rows from the invoice line table that contain a "Cupcake" type product
C)   lists the invoice numbers for invoices containing line items with a "Cupcake" product type
D)   lists the product codes for all "Cupcake" type products that appear on invoices

Question 4

Imagine that you are working with a MySQL table called ADDRESS_BOOK with the following columns: FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP_CODE, and BIRTHDAY. Write queries to (1) list all rows missing the ZIP code value and (2) list all rows that include a birthday value.

Accepted Answer

SELECT * FROM ADDRESS_BOOK WHE...

Question 5

What SQL command do you use to query a database?

Accepted Answer

A)   WHERE
B)   SELECT
C)   FROM
D)   SET

Question 6

Mallory would like to display the rows from a MySQL table that have "Red," "Pink," or "White" in the COLOR column. A concise way of writing her query would be to use a(n)  _____.

Accepted Answer

A)   LIKE clause
B)   CONTAINS clause
C)   BETWEEN clause
D)   IN clause

Question 7

Which function determines the number of rows in a table?

Accepted Answer

A)   ROW
B)   CALCULATE
C)   COUNT
D)   NUMBER

Question 8

The GROUP BY clause sorts the data in a particular order.

Accepted Answer

A) True 
 B)False

Question 9

Which operator uses one or more wildcard characters to test for a pattern match?

Accepted Answer

A)   PATTERN
B)   LIKE
C)   MATCH
D)   SIMILAR

Question 10

When you need to sort data on two columns, the less important column is called the _____.

Accepted Answer

A)   double sort key
B)   primary sort key
C)   minor sort key
D)   foreign sort key

Question 11

All SELECT statements require a WHERE clause.

Accepted Answer

A) True 
 B)False

Question 12

It is possible to place one query inside another.

Accepted Answer

A) True 
 B)False

Question 13

Which operator finds rows that do not contain a null value in the specified column?

Accepted Answer

A)   IS NULL
B)   NOT NULL
C)   !NULL
D)   IS NOT NULL

Question 14

Which of the following operators can be used for a column computation?

Accepted Answer

A)   +
B)   ^
C)   **
D)   +, ^, and **

Question 15

In MySQL, you can use an asterisk (*)  to represent any column when using the _____.

Accepted Answer

A)   SUM function
B)   COUNT function
C)   MAX function
D)   MIN function

Exam 4: Single Table Queries

Which operator finds rows that do not contain a null value in the specified column?

Correct Answer
verified

In MySQL, you can use an asterisk (*) to represent any column when using the _____.

Correct Answer
verified

When a subquery is used in a SQL statement _____.

Correct Answer
verified

It is possible to place one query inside another.

Correct Answer
verified

What does the following SQL query do? SELECT INVOICE_NUM FROM INVOICE_LINE WHERE PROD_CODE IN (SELECT PROD_CODE FROM PRODUCTS WHERE (PROD_TYPE = 'Cupcake') ) ;

Correct Answer
verified

Mallory would like to display the rows from a MySQL table that have "Red," "Pink," or "White" in the COLOR column. A concise way of writing her query would be to use a(n) _____.

Correct Answer
verified

Imagine that you are working with a MySQL table called ADDRESS_BOOK with the following columns: FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP_CODE, and BIRTHDAY. Write queries to (1) list all rows missing the ZIP code value and (2) list all rows that include a birthday value.

Correct Answer
verified
SELECT * FROM ADDRESS_BOOK WHE...
View Answer

What SQL command do you use to query a database?

Correct Answer
verified

The GROUP BY clause sorts the data in a particular order.

Correct Answer
verified

Which of the following operators can be used for a column computation?

Correct Answer
verified

All SELECT statements require a WHERE clause.

Correct Answer
verified

When you need to sort data on two columns, the less important column is called the _____.

Correct Answer
verified

Which clause is used to restrict the groups that will be included in a query result?

Correct Answer
verified

Which operator uses one or more wildcard characters to test for a pattern match?

Correct Answer
verified

Which function determines the number of rows in a table?

Correct Answer
verified

Exam 4: Single Table Queries

Which operator finds rows that do not contain a null value in the specified column?

Correct AnswerverifiedShow Answer

In MySQL, you can use an asterisk (*) to represent any column when using the _____.

Correct AnswerverifiedShow Answer

When a subquery is used in a SQL statement _____.

Correct AnswerverifiedShow Answer

It is possible to place one query inside another.

Correct AnswerverifiedShow Answer

What does the following SQL query do? SELECT INVOICE_NUM FROM INVOICE_LINE WHERE PROD_CODE IN (SELECT PROD_CODE FROM PRODUCTS WHERE (PROD_TYPE = 'Cupcake') ) ;

Correct AnswerverifiedShow Answer

Mallory would like to display the rows from a MySQL table that have "Red," "Pink," or "White" in the COLOR column. A concise way of writing her query would be to use a(n) _____.

Correct AnswerverifiedShow Answer

Imagine that you are working with a MySQL table called ADDRESS_BOOK with the following columns: FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP_CODE, and BIRTHDAY. Write queries to (1) list all rows missing the ZIP code value and (2) list all rows that include a birthday value.

Correct AnswerverifiedSELECT * FROM ADDRESS_BOOK WHE...View AnswerShow Answer

What SQL command do you use to query a database?

Correct AnswerverifiedShow Answer

The GROUP BY clause sorts the data in a particular order.

Correct AnswerverifiedShow Answer

Which of the following operators can be used for a column computation?

Correct AnswerverifiedShow Answer

All SELECT statements require a WHERE clause.

Correct AnswerverifiedShow Answer

When you need to sort data on two columns, the less important column is called the _____.

Correct AnswerverifiedShow Answer

Which clause is used to restrict the groups that will be included in a query result?

Correct AnswerverifiedShow Answer

Which operator uses one or more wildcard characters to test for a pattern match?

Correct AnswerverifiedShow Answer

Which function determines the number of rows in a table?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
SELECT * FROM ADDRESS_BOOK WHE...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified