Question 1

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)

Accepted Answer

A)  relations 
B)  entities 
C)  nonkey columns 
D)  primary keys D

Question 2

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

Accepted Answer

CREATE TABLE CANDY
(
CANDY_ID CHAR (5) PRIMARY KEY,
CANDY_NAME CHAR (25),
DESCRIPTION CHAR (50),
QTY_PER_UNIT INT
);

Question 3

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

Accepted Answer

A)  TRUE 
B)  ALL 
C)  IS ALL 
D)  ALWAYS B

Question 4

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

Accepted Answer

The answer of Henry uses a large database to generate...

Question 5

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

Accepted Answer

A)  PATIENT (PATIENT_ID, FIRST_NAME, LAST_NAME, DOC_ID, DOC_FIRST_NAME, DOC_LAST_NAM
E)  
B)  PATIENT (PATIENT_ID, FIRST_NAME, LAST_NAME, VISIT_DATE, (SERVICE, BILLING_COD
E) ) 
C)  PATIENT (PATIENT_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NO, DOC_I
D)  
D)  PATIENT (PATIENT_ID, DOC_ID, FIRST_NAME, LAST_NAME, (ADMIT_DATE, RELEASE_DAT
E) )

Question 6

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.

Accepted Answer

The answer of Imagine you have created a table called...

Question 7

The DATE_ADD function has one argument.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A)  UPDATE SALES_REP SET LAST_NAME = 'Bond' WHERE REP_ID = '007'; 
B)  CHANGE SALES_REP LAST_NAME = 'Bond' WHERE REP_ID = '007'; 
C)  REPLACE SALES_REP LAST_NAME = 'Bond' WHERE REP_ID = '007'; 
D)  INSERT SALES_REP SET LAST_NAME = 'Bond' WHERE REP_ID = '007';

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?

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

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?