Question 1

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 
A)  LIKE 
B)  HAVING 
C)  WHERE 
D)  HAVE

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

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

Question 4

Which function determines the number of rows in a table?

Accepted Answer

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

Question 5

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 
A)  SUM function 
B)  COUNT function 
C)  MAX function 
D)  MIN function

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 
A)  LIKE clause 
B)  CONTAINS clause 
C)  BETWEEN clause 
D)  IN clause

Question 7

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 
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 8

All SELECT statements require a WHERE clause.

Accepted Answer

A) True 
 B)False

Question 9

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 
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 10

It is possible to place one query inside another.

Accepted Answer

A) True 
 B)False

Question 11

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 
A)  double sort key 
B)  primary sort key 
C)  minor sort key 
D)  foreign sort key

Question 12

What SQL command do you use to query a database?

Accepted Answer

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

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 
A)  IS NULL 
B)  NOT NULL 
C)  !NULL 
D)  IS NOT NULL

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

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

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

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

Which function determines the number of rows in a table?

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

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) _____.

When a subquery is used in a SQL statement _____.

All SELECT statements require a WHERE clause.

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'));

It is possible to place one query inside another.

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

What SQL command do you use to query a database?

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

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

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.

Introduction to Kimtay Pet Supplies and Staywell Student Accommodation Databases

Database Design Fundamentals

Creating Tables

Multiple Table Queries

Updating Data

Database Administration

Functions Procedures and Triggers

Filters

Exam 4: Single Table Queries

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

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

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

Which function determines the number of rows in a table?

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

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) _____.

When a subquery is used in a SQL statement _____.

All SELECT statements require a WHERE clause.

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'));

It is possible to place one query inside another.

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

What SQL command do you use to query a database?

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

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

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.

Introduction to Kimtay Pet Supplies and Staywell Student Accommodation Databases

Database Design Fundamentals

Creating Tables

Multiple Table Queries

Updating Data

Database Administration

Functions Procedures and Triggers

Filters