Quiz 1Z0-871

Quiz 1Z0-871, MySQL 5 Developer Certified Professional , Part I

Is the following statement true or false?

Which of the following are correct? A REPLACE statement may be used

Which of the following privileges is required for using TRUNCATE?

Which of the following will be the result of the following SELECT query given the codes table is of the type specified? SELECT * FROM codes

An UPDATE statement issued without a WHERE clause will

What will be the output of SELECT * FROM names now?

Which of the following INSERT statements are syntactically correct?

Why is it a bad idea to use SELECT * instead of specifying the required columns by their name?

What would be the outcome when following statement is executed?

Which of the following comparisons is equivalent to: ( age >= 4 ) and ( age <= 8 )