Quiz 1Z0-872

Quiz 1Z0-872, Sun Certified MySQL 5 Developer Part II

Which of the following statements can be used to drop a trigger named trigger l on table tabiel in the test database?

With triggers, which of the following is true in regards to their association with databases and tables?

In stored routines, which of the following demonstrates valid methods for working with loops?

In a stored routine, what is the proper order of use of the declare statement?

Which of the following are true in relation to stored procedures and functions?

What would be the consequence of this query if executed in a stored procedure?

Is the following valid syntax to create a function that returns the number of records in the Country table? If not, why?

Which of the following, when enabled, can prevent a client from ciefining stored routines?

Assuming this query returns no results, what will be the contents of the variable pop?

When used in a stored routine, which of the following demonstrates correct usage of case?