Study tips 1Z0-051

Which statement is true regarding this SQL statement?

Which is the correct syntax to create this table?

Which WHERE clause could be used in the SELECT statement to get the required output?

Which three statements are true about multiple-row sub queries?

Which two statements are true regarding the ORDER BY clause?

Which two statements are true regarding the USING clause in table joins?

Which constraint can be defined only at the column level?

What is true about the WITH GRANT OPTION clause?

Which substitution variable would you use if you want to reuse the variable without prompting the user each time?

What is true about your ALTER statement?