Study tips 1Z0-047

Which two statements are true about the GROUPING function?

Which statement is true regarding the output for this command?

Which rows would be made permanent in the CUST table?

SELECT employee_id FROM employees WHERE job_id = ‘SA_MAN’ ________________ SELECT employee_id FROMjob_history WHERE job_id=’SA_MAN’

Which two WHERE clause options can give you the desired result?

Which SET operator should be used in the blank space in the following SQL statement to display the cities that have departments located in them?

Which statement is true regarding the above commands?

Which DELETE statement would execute successfully?

Which two statements are true regarding roles?

Which two statements are true regarding the EXISTS operator used in the correlated subqueries?