Oracle
1Z0-071 · Question #391
No-user-defined locks are used in your database. Which three are true about Transaction Control Language (TCL)?
The correct answer is A. COMMIT erases all the transaction's savepoints and releases its locks. C. COMMIT ends the transaction and makes all its changes permanent. F. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes, releases. https://docs.oracle.com/cd/A58617_01/server.804/a58233/trans.htm https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9021.htm
Manipulating Data
Question
No-user-defined locks are used in your database. Which three are true about Transaction Control Language (TCL)?
Options
- ACOMMIT erases all the transaction's savepoints and releases its locks.
- BROLLBACK TO SAVEPOINT undoes the transaction's changes made since the named savepoint
- CCOMMIT ends the transaction and makes all its changes permanent.
- DROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does
- EROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does
- FROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes, releases
How the community answered
(30 responses)- A83% (25)
- B3% (1)
- D3% (1)
- E10% (3)
Explanation
https://docs.oracle.com/cd/A58617_01/server.804/a58233/trans.htm https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9021.htm
Topics
#COMMIT#ROLLBACK#savepoints#TCL behavior
Community Discussion
No community discussion yet for this question.