Exam 1: Efficiency Improvements for Creating Reports and Removing Rows in MySQL

In the following shorthand representation of a database, the underlined items are _____. INVOICES (INVOICE_NUM, INVOICE_DATE, CUST_ID) INVOICE_LINE (INVOICE_NUM, ITEM_ID, QUANTITY, QUOTED_PRICE) ITEM (ITEM_ID, DESCRIPTION, ON_HAND, CATEGORY, LOCATION, PRICE)

Write a MySQL command to create a table called CANDY that contains the following columns: .Candy ID, five characters; will function as primary key .Candy name, 25 characters .Description, 50 characters .Quantity per unit, whole number

A condition is true only if it satisfies all values produced by a subquery when that subquery is preceded by which operator?

Henry uses a large database to generate reports and would like to make report delivery more efficient (faster). The reports derive from the following tables. ? CANDY table, with these columns: PROD_ID, NAME, UNITS_SOLD_LAST_30DAYS EMPLOYEE table, with these columns: EMP_ID, FIRST_NAME, LAST_NAME, OFFICE_PHONE ? Write SQL commands to improve the efficiency of creating these two reports: .Employee records alphabetized by last name, then first name .Names of candy products listed by units sold in the last 30 days, in descending order

Which of the following tables is in third normal form, given that DOC_ID determines DOC_FIRST_NAME and DOC_LAST_NAME?

Imagine you have created a table called BOXES in MySQL to store data about various sizes of cardboard boxes that your organization sells. Its columns include PRODUCT_ID, NAME, DESCRIPTION, HEIGHT_IN, WIDTH_IN, and DEPTH_IN. Write a SQL command to remove any rows describing boxes with a height of 24 inches from the table.

The DATE_ADD function has one argument.

Which of the following SQL commands changes the value in the column LAST_NAME within the row containing a REP_ID of 007?