Exam 8: Functions Procedures and Triggers

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?

Discuss two reasons for creating a stored procedure.

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

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

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

The DATE_ADD function has one argument.

MySQL procedures without error handling _____.

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

A trigger is executed _____.

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

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

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

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

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

What does the error code 1172 stand for?