Question 1

If Mack wants to display the number of days between two dates, such as the current date and an invoice date from a table, which function can he use in his MySQL query to accomplish this?

Accepted Answer

A)  DATE_ADD() 
B)  SUBTRACT() 
C)  DATEDIFF() 
D)  SYSDATE()

Question 2

Discuss two reasons for creating a stored procedure.

Accepted Answer

The answer of Discuss two reasons for creating a stored...

Question 3

When creating a stored procedure to retrieve a single row with embedded SQL, you must place the procedural code _____.

Accepted Answer

A)  inside a SELECT or WHERE clause 
B)  within the DELIMITER clause 
C)  between the BEGIN and END commands 
D)  after the DECLARE statement

Question 4

What function can you use to obtain today's date in MySQL?

Accepted Answer

A)  TODAYS_DATE() 
B)  CURRENT_DATE() 
C)  DATE() 
D)  CURDATE()

Question 5

Which command do you use to write a procedure that should be executed automatically when a certain database operation is performed?

Accepted Answer

A)  SET AFTER 
B)  SET ON UPDATE 
C)  CREATE PROCEDURE 
D)  CREATE TRIGGER

Question 6

The DATE_ADD function has one argument.

Accepted Answer

A) True 
 B)False

Question 7

MySQL procedures without error handling _____.

Accepted Answer

A)  display helpful error messages to the user 
B)  include "declare an exception" clauses 
C)  return unclear results when used with invalid arguments 
D)  are common and acceptable

Question 8

How do you add a specific number of days to a date in MySQL?

Accepted Answer

A)  use the DATE_ADD function without an INTERVAL unit 
B)  use an expression with a plus (+) operator such as "+ 14" 
C)  use the ADD_DAYS function 
D)  use the SUM operator

Question 9

A trigger is executed _____.

Accepted Answer

A)  regularly at given time intervals 
B)  in response to a command such as INSERT, UPDATE, or DELETE 
C)  in response to a TRIGGER command 
D)  at a user's request

Question 10

What is the difference between a nonprocedural language and a procedural language? Give an example of each.

Accepted Answer

The answer of What is the difference between a nonprocedural...

Question 11

A procedure that is executed automatically in response to an associated database operation is called a _____.

Accepted Answer

A)  cursor 
B)  trigger 
C)  waypoint 
D)  fetchpoint

Question 12

Applying the function ROUND(PRICE,0) to the price 24.95 results in 24.

Accepted Answer

A) True 
 B)False

Question 13

Which WHERE clause can you use with a SELECT statement to perform a case-insensitive search for rows containing the first name Marco?

Accepted Answer

A)  WHERE FIRST_NAME = UPPER('MARCO') 
B)  WHERE FIRST_NAME = LOWER('MARCO') 
C)  WHERE LOWER(FIRST_NAM
E)  = 'MARCO' 
D)  WHERE UPPER(FIRST_NAM
E)  = 'MARCO'

Question 14

How do you write a procedure to delete a table row?

Accepted Answer

The answer of How do you write a procedure to...

Question 15

What does the error code 1172 stand for?

Accepted Answer

A)  illegal value 
B)  not found 
C)  invalid argument 
D)  too many rows

Exam 8: Functions Procedures and Triggers