READ Free Dumps For Oracle- 1z0-047
| Question ID 6433 | SCOTT is a user in the database. Evaluate the commands issued by the DBA: 1 - CREATE ROLE mgr; 2 - GRANT CREATE TABLE, SELECT ON oe.orders TO mgr; 3 - GRANT mgr, create table TO SCOTT; Which statement is true regarding the execution of the above commands? |
| Option A | Statement 1 would not execute because the WITH GRANT option is missing. |
| Option B | . Statement 1 would not execute because the IDENTIFIED BY clause is missing. |
| Option C | Statement 3 would not execute because role and system privileges cannot be granted together in a single GRANT statement. |
| Option D | Statement 2 would not execute because system privileges and object privileges cannot be granted together in a single GRANT command. |
| Correct Answer | D |
| Question ID 6434 | Which statement best describes the GROUPING function? |
| Option A | It is used to set the order for the groups to be used for calculating the grand totals and subtotals |
| Option B | . It is used to form various groups to calculate total and subtotals created using ROLLUP and CUBE operators. |
| Option C | It is used to identify if the NULL value in an expression is a stored NULL value or created by ROLLUP or CUBE. |
| Option D | It is used to specify the concatenated group expressions to be used for calculating the grand totals and subtotals. |
| Correct Answer | C |