READ Free Dumps For Oracle- 1z0-047
| Question ID 6431 | Which statements are correct regarding indexes? (Choose all that apply.) |
| Option A | When a table is dropped, the corresponding indexes are automatically dropped |
| Option B | For each DML operation performed, the corresponding indexes are automatically updated. |
| Option C | Indexes should be created on columns that are frequently referenced as part of an expression. |
| Option D | A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index. |
| Correct Answer | ABD |
| Question ID 6432 | User OE, the owner of the ORDERS table, issues the following command: GRANT SELECT ,INSERT ON orders TO hr WITH GRANT OPTION; The user HR issues the following command: GRANT SELECT ON oe.orders TO scott; Then, OE issues the following command: REVOKE ALL ON orders FROM hr; Which statement is correct? |
| Option A | The user SCOTT loses the privilege to select rows from OE.ORDERS |
| Option B | The user SCOTT retains the privilege to select rows from OE.ORDERS. |
| Option C | The REVOKE statement generates an error because OE has to first revoke the SELECT privilege from SCOTT. |
| Option D | The REVOKE statement generates an error because the ALL keyword cannot be used for privileges that have been granted using WITH GRANT OPTION. |
| Correct Answer | A |