Study tips 1Z0-047

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?

Which two tasks would require subqueries?

Which statement best describes the GROUPING function?

Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?