READ Free Dumps For Oracle- 1z0-047
| Question ID 6419 | What would be the outcome after executing the statements? |
| Option A | SCOTT would be able to query the OE.ORDERS table |
| Option B | SCOTT would not be able to query the OE.ORDERS table |
| Option C | The REVOKE statement would remove the SELECT privilege from SCOTT as well as from the role R1. |
| Option D | . The REVOKE statement would give an error because the SELECT privilege has been granted to the role R1. |
| Correct Answer | A |
| Question ID 6420 | Which statement is true regarding the effect of the above SQL statement? |
| Option A | . Any synonym existing on the EMP table would have to be re-created |
| Option B | . Any constraints defined on the MGR_ID column would be removed by the above command. |
| Option C | Any views created on the EMP table that include the MGR_ID column would have to be dropped and re-created |
| Option D | . Any index created on the MGR_ID column would continue to exist until the DROP UNUSED COLUMNS command is executed |
| Correct Answer | B |