nerdexam
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)
  • A
    84% (37)
  • B
    2% (1)
  • C
    9% (4)
  • D
    5% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice