Question 1

What clause can you use to list data in a specific order?

Accepted Answer

A)  ORDER 
B)  SET ORDER 
C)  ORDER BY 
D)  LIST BY 
A)  ORDER 
B)  SET ORDER 
C)  ORDER BY 
D)  LIST BY C

Question 2

Bradford would like to write a query that returns the average unit sales over the last 30 days for each of his bakery's product types: cupcakes, muffins, and cookies. There are several flavors of each in the table, but the product types are identified in a CATEGORY column as "Cupcake," "Muffin," or "Cookie." What should the last part of his query be, following the part shown below? ​
SELECT CATEGORY, AVG(UNIT_SALES) FROM PRODUCTS

Accepted Answer

A)  ORDER BY CATEGORY; 
B)  GROUP BY CATEGORY; 
C)  BETWEEN ('Cupcake', 'Muffin', 'Cookie'); 
D)  WHERE CATEGORY IN ('Cupcake', 'Muffin', 'Cookie'); 
A)  ORDER BY CATEGORY; 
B)  GROUP BY CATEGORY; 
C)  BETWEEN ('Cupcake', 'Muffin', 'Cookie'); 
D)  WHERE CATEGORY IN ('Cupcake', 'Muffin', 'Cookie'); B

Question 3

You form compound conditions by connecting two or more simple conditions using _____.

Accepted Answer

A)  multiple SELECT statements 
B)  WHERE clauses 
C)  subqueries 
D)  AND, OR, and NOT operators 
A)  multiple SELECT statements 
B)  WHERE clauses 
C)  subqueries 
D)  AND, OR, and NOT operators D

Question 4

What is the appropriate sequence for the elements in a SQL query clause that displays the rows returned in a particular order?

Accepted Answer

A)  command, operator (if any), major sort key, minor sort key 
B)  primary sort key followed by operator (if any), secondary sort key followed by operator (if any), command 
C)  command, major sort key followed by operator (if any), minor sort key followed by operator (if any) 
D)  command, secondary sort key followed by operator (if any), primary sort key followed by operator (if any) 
A)  command, operator (if any), major sort key, minor sort key 
B)  primary sort key followed by operator (if any), secondary sort key followed by operator (if any), command 
C)  command, major sort key followed by operator (if any), minor sort key followed by operator (if any) 
D)  command, secondary sort key followed by operator (if any), primary sort key followed by operator (if any)

Question 5

Imagine you are working with a MySQL table called LIBRARY_MEMBERS that includes the following columns: MEMBER_ID, MOBILE_NUMBER, MAX_BOOKS (the maximum number of books that member can check out at one time), and BOOKS_CHECKED_OUT (the number of books currently checked out). Write a SQL query that will display a grid including the MEMBER_ID for all rows plus a column called CAN_CHECK_OUT that indicates how many more books that library member must check out to reach his or her maximum.

Accepted Answer

SELECT MEMBER_ID, MA

Question 6

In the SELECT clause, you can indicate that you want to include all columns using the _____.

Accepted Answer

A)  \ symbol 
B)  / symbol 
C)  * symbol 
D)  "?" symbol 
A)  \ symbol 
B)  / symbol 
C)  * symbol 
D)  "?" symbol

Question 7

Describe simple and compound conditions.

Accepted Answer

A simple condition has this form: column

Question 8

The only arithmetic operators that can be used in SELECT statements are + for addition and - for subtraction.

Accepted Answer

A) True 
 B)False

Question 9

It is possible to use both a WHERE clause and a HAVING clause in a SELECT statement.

Accepted Answer

A) True 
 B)False

Question 10

Which function calculates a total of the values in a column?

Accepted Answer

A)  TOTAL 
B)  CALCULATE 
C)  SUM 
D)  ADD 
A)  TOTAL 
B)  CALCULATE 
C)  SUM 
D)  ADD

Question 11

How do you construct the SELECT query?

Accepted Answer

In SQL, you use the SELECT command to qu

Question 12

Which clause lets you group data on a particular column?

Accepted Answer

A)  GROUP 
B)  GROUP BY 
C)  SET GROUP 
D)  GROUPING 
A)  GROUP 
B)  GROUP BY 
C)  SET GROUP 
D)  GROUPING

Question 13

When you need to find rows with null values in a MySQL table, you can use the _____.

Accepted Answer

A)  SELECT NULL command 
B)  GROUP BY NULL condition 
C)  = NULL condition 
D)  IS NULL operator 
A)  SELECT NULL command 
B)  GROUP BY NULL condition 
C)  = NULL condition 
D)  IS NULL operator

Question 14

Which MySQL clause used with the query SELECT* FROM PACKAGE would be the most likely to yield the following results?

Accepted Answer

A)  WHERE PACKAGE_NAME DESC, PRICE 
B)  WHERE PRICE DESC, PACKAGE_NAME 
C)  ORDER BY PACKAGE_NAME, PRICE DESC 
D)  ORDER BY PRICE DESC, PACKAGE_NAME 
A)  WHERE PACKAGE_NAME DESC, PRICE 
B)  WHERE PRICE DESC, PACKAGE_NAME 
C)  ORDER BY PACKAGE_NAME, PRICE DESC 
D)  ORDER BY PRICE DESC, PACKAGE_NAME

Question 15

When a SQL query is written so as to display the results in a specific order, this order is determined by the _____.

Accepted Answer

A)  operator 
B)  sort key 
C)  primary key 
D)  WHERE clause 
A)  operator 
B)  sort key 
C)  primary key 
D)  WHERE clause

Question 16

Preceding a condition with which SQL operator reverses the truth of the original condition?

Accepted Answer

A)  REVERSE 
B)  NOT 
C)  NULL 
D)  OR 
A)  REVERSE 
B)  NOT 
C)  NULL 
D)  OR

Question 17

The basic form of the SQL SELECT command is _____.

Accepted Answer

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

Question 18

Compare the WHERE and HAVING clauses.

Accepted Answer

Just as you can use the WHERE clause to

Question 19

Which operator is inclusive, meaning that a query selects a value equal to either value in the condition along with those in the range of the values?

Accepted Answer

A)  AND 
B)  BETWEEN 
C)  OR 
D)  NOT 
A)  AND 
B)  BETWEEN 
C)  OR 
D)  NOT

Question 20

Adding a ORDER BY UNIT_PRICE clause to a SQL query will _____.

Accepted Answer

A)  display the results in ascending order by UNIT_PRICE 
B)  set UNIT_PRICE as the primary key for the table being queried 
C)  display the results in descending order by UNIT_PRICE 
D)  display UNIT_PRICE as the first column in the results 
A)  display the results in ascending order by UNIT_PRICE 
B)  set UNIT_PRICE as the primary key for the table being queried 
C)  display the results in descending order by UNIT_PRICE 
D)  display UNIT_PRICE as the first column in the results

What clause can you use to list data in a specific order?

You form compound conditions by connecting two or more simple conditions using _____.

What is the appropriate sequence for the elements in a SQL query clause that displays the rows returned in a particular order?

In the SELECT clause, you can indicate that you want to include all columns using the _____.

Describe simple and compound conditions.

The only arithmetic operators that can be used in SELECT statements are + for addition and - for subtraction.

It is possible to use both a WHERE clause and a HAVING clause in a SELECT statement.

Which function calculates a total of the values in a column?

How do you construct the SELECT query?

Which clause lets you group data on a particular column?

When you need to find rows with null values in a MySQL table, you can use the _____.

Which MySQL clause used with the query SELECT* FROM PACKAGE would be the most likely to yield the following results?

When a SQL query is written so as to display the results in a specific order, this order is determined by the _____.

Preceding a condition with which SQL operator reverses the truth of the original condition?

The basic form of the SQL SELECT command is _____.

Compare the WHERE and HAVING clauses.

Which operator is inclusive, meaning that a query selects a value equal to either value in the condition along with those in the range of the values?

Adding a ORDER BY UNIT_PRICE clause to a SQL query will _____.

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

What clause can you use to list data in a specific order?

You form compound conditions by connecting two or more simple conditions using _____.

What is the appropriate sequence for the elements in a SQL query clause that displays the rows returned in a particular order?

In the SELECT clause, you can indicate that you want to include all columns using the _____.

Describe simple and compound conditions.

The only arithmetic operators that can be used in SELECT statements are + for addition and - for subtraction.

It is possible to use both a WHERE clause and a HAVING clause in a SELECT statement.

Which function calculates a total of the values in a column?

How do you construct the SELECT query?

Which clause lets you group data on a particular column?

When you need to find rows with null values in a MySQL table, you can use the _____.

Which MySQL clause used with the query SELECT* FROM PACKAGE would be the most likely to yield the following results?

When a SQL query is written so as to display the results in a specific order, this order is determined by the _____.

Preceding a condition with which SQL operator reverses the truth of the original condition?

The basic form of the SQL SELECT command is _____.

Compare the WHERE and HAVING clauses.

Which operator is inclusive, meaning that a query selects a value equal to either value in the condition along with those in the range of the values?

Adding a ORDER BY UNIT_PRICE clause to a SQL query will _____.

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