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?

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?

Accepted Answer

B. The DELETE command will immediately delete the row.

Answer

A. The DELETE command will wait for HR'S transaction to end then delete the row.

Answer

C. The DELETE command will immediately return an error.

Answer

D. The DELETE command will wait for HR'S transaction to end then return an error.

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…

Question

Options

How the community answered

Community Discussion