Study tips 1Z0-051

Which set of SQL statements achieves the desired results?

What would be the outcome of the above query?

Which query would give the required result?

Identify the reason for the SQL statement failure?

Which arithmetic operations can be performed on a column by using a SQL function that is built into Oracle database?

Which WHERE clause would give the required result?

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?