Question 1

Discuss two reasons for creating a stored procedure.

Accepted Answer

When you anticipate running a particular...

Question 2

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() E) A) and C)
F) None of the above

Question 3

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

Accepted Answer

You begin by specifying a non-semicolon ...

Question 4

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 acceptableE) All of the above
F) C) and D)

Question 5

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

Accepted Answer

A nonprocedural language is one in which...

Question 6

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)   fetchpointE) A) and D)
F) All of the above

Question 7

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 TRIGGERE) B) and D)
F) A) and B)

Question 8

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

Accepted Answer

A)   TODAYS_DATE() 
B)   CURRENT_DATE() 
C)   DATE() 
D)   CURDATE() E) B) and D)
F) B) and C)

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 requestE) B) and C)
F) A) and D)

Question 10

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 statementE) C) and D)
F) A) and B)

Question 11

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 operatorE) A) and D)
F) All of the above

Question 12

What does the error code 1172 stand for?

Accepted Answer

A)   illegal value
B)   not found
C)   invalid argument
D)   too many rowsE) All of the above
F) B) and D)

Question 13

The DATE_ADD function has one argument.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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'E) C) and D)
F) All of the above

Exam 8: Functions Procedures and Triggers

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

Correct Answer
verified

What does the error code 1172 stand for?

Correct Answer
verified

Discuss two reasons for creating a stored procedure.

Correct Answer
verified
When you anticipate running a particular...
View Answer

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

Correct Answer
verified
A nonprocedural language is one in which...
View Answer

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

Correct Answer
verified

The DATE_ADD function has one argument.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified
You begin by specifying a non-semicolon ...
View Answer

A trigger is executed _____.

Correct Answer
verified

MySQL procedures without error handling _____.

Correct Answer
verified

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?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Exam 8: Functions Procedures and Triggers

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

Correct AnswerverifiedShow Answer

What does the error code 1172 stand for?

Correct AnswerverifiedShow Answer

Discuss two reasons for creating a stored procedure.

Correct AnswerverifiedWhen you anticipate running a particular...View AnswerShow Answer

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

Correct AnswerverifiedA nonprocedural language is one in which...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

The DATE_ADD function has one argument.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedYou begin by specifying a non-semicolon ...View AnswerShow Answer

A trigger is executed _____.

Correct AnswerverifiedShow Answer

MySQL procedures without error handling _____.

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
When you anticipate running a particular...
View Answer

Correct Answer
verified
A nonprocedural language is one in which...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
You begin by specifying a non-semicolon ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified