Oracle
1Z0-071 · Question #402
1Z0-071 Question #402: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #402. The question stem and answer options stay visible for context.
Question
Table HR.EMPLOYEES contains a row where the EMPLOYEE_ID is 109. User ALICE has no privileges to access HR.EMPLOYEES. User ALICE starts a session. User HR starts a session and successfully executes these statements: GRANT DELETE ON employees TO alice; UPDATE employees SET salary = 24000 WHERE employee_id = 109; In her existing session ALICE then executes: DELETE FROM hr.employees WHERE employee_id = 109; What is the result?
Options
- AThe DELETE command will wait for HR'S transaction to end then delete the row.
- BThe DELETE command will immediately delete the row.
- CThe DELETE command will immediately return an error.
- DThe DELETE command will wait for HR'S transaction to end then return an error.
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.