Study tips 1Z0-047

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?

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?