Study tips 1Z0-047

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?

What would be the outcome of the above statement?

What correction needs to be done to the above statement?

Which statement is true regarding the effect of the command?

Which two statements are true regarding roles?

Which statement is true regarding Flashback Version Query?

What would be the status of the foreign key EMP_MGR_FK?

Which statements are correct regarding indexes?