Study tips 1Z0-047

Which two statements are true regarding the above SQL statements?

Which three statements are true regarding group functions?

The row will be inserted in______________.

Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command?

Which command would work in relation to the EMPDET table?

Which three tasks can be performed using regular expression support in Oracle Database 10g?

Which three statements are true regarding single-row functions?

Which statement is true regarding the execution of this SQL statement?

Which two statements are true regarding the execution of the correlated subqueries?

Which statement is true regarding the PROD_ID_PK constraint?