Study tips 1Z0-051

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?

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?