Study tips 1Z0-051

Which three statements are true regarding sub queries?

Which SQL statement would produce the required result?

What is true about them?

Where can sub queries be used?

Which three SQL statements would display the value 1890.55 as $1,890.55?

Which statement is true regarding the outcome of the above query?

Which statement correctly describes SQL and /SQL*Plus?

Which four are types of functions available in SQL?

Which MERGE statement is valid?

Which view should a user query to display the columns associated with the constraints on a table owned by the user?