Oracle
1Z0-071 · Question #405
User HR has CREATE SESSION, CREATE ANY TABLE and UNLIMITED TABLESPACE privileges. User SCOTT has CREATE SESSION, CREATE TABLE and UNLIMITED TABLESPACE privileges. HR successfully executes this…
The correct answer is A. 1 only. See the full explanation below for the reasoning.
Question
User HR has CREATE SESSION, CREATE ANY TABLE and UNLIMITED TABLESPACE privileges. User SCOTT has CREATE SESSION, CREATE TABLE and UNLIMITED TABLESPACE privileges. HR successfully executes this statement: HR attempts to execute: 1. INSERT INTO scott.products VALUES (1, 'LAPTOP'); SCOTT attempts to execute: 2. SELECT * FROM products; 3. INSERT INTO scott.products VALUES (2, 'HDD'); 4. CREATE SYNONYM prod FOR products; Which will execute successfully?
Options
- A1 only
- B2 and 3 only
- C1, 2 and 3
- D2, 3 and 4
How the community answered
(44 responses)- A84% (37)
- B2% (1)
- C9% (4)
- D5% (2)
Community Discussion
No community discussion yet for this question.