1Z0-007 · Question #161
Examine the structure of the EMPLOYEES table: You issue these statements: CREATE table new_emp ( employee_id NUMBER, name VARCHAR2(30)); INSERT INTO new_emp SELECT employee_id , last_name from…
The correct answer is A. You have no rows in the table. At the end of this transaction you will not have rows in the table. Incorrect Answers B: All transactions will be roll backed, so it will be no rows in the table. C: It is possible to roll back to the same savepoint more than once. D: Your last update will not fail because…
Question
Examine the structure of the EMPLOYEES table:
You issue these statements:
CREATE table new_emp ( employee_id NUMBER, name VARCHAR2(30)); INSERT INTO new_emp SELECT employee_id , last_name from employees; Savepoint s1; UPDATE new_emp set name = UPPER(name); Savepoint s2; Delete from new_emp; Rollback to s2; Delete from new_emp where employee_id =180; UPDATE new_emp set name = 'James'; Rollback to s2; UPDATE new_emp set name = 'James' WHERE employee_id =180; Rollback; At the end of this transaction, what is true?
Options
- AYou have no rows in the table.
- BYou have an employee with the name of James.
- CYou cannot roll back to the same savepoint more than once.
- DYour last update fails to update any rows because employee ID 180 was already deleted.
How the community answered
(34 responses)- A74% (25)
- B9% (3)
- C15% (5)
- D3% (1)
Explanation
At the end of this transaction you will not have rows in the table. Incorrect Answers B: All transactions will be roll backed, so it will be no rows in the table. C: It is possible to roll back to the same savepoint more than once. D: Your last update will not fail because there is employee with ID 180 in the table and transactions have been rolled back only to the savepoint s2 before issue this update.
Topics
Community Discussion
No community discussion yet for this question.