Quiz 1Z0-872

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

Will the following create view statement successfully create a view of this select? If not, why?

Which of the following statements are true?

For which of the following create view statements will MySQL elect to use the temptable algorithm?

Is the following statement true or false?

Which of the following results should be expected when executing the statement?

Which of the following statements are equivalent to the above example?

What would be the result if the above statement was issued and the view v_uscity did not previously exist?

If the view definition includes where age >= 17 with check option what will happen when the following statement is executed?

When performing a select for a value that is in an index

Assuming you want to add an index on the isofficial column, which of the following statements are true?