D and E are correct answers because DDL statements such as CREATE, ALTER, TRUNCATE, etc commit trunsactions. and you can also have multiple savepoints in the same transaction.
A - FALSE; DDL changes cannot be undone
B - FALSE; see A
C - FALSE; there can be multiple savepoints, see https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/SAVEPOINT.html#GUID-78EEA746-0021-42E8-9971-3BA6DFFEE794 where text "Savepoint names must be distinct within a given transaction. If you create a second savepoint with the same identifier as an earlier savepoint, then the earlier savepoint is erased." is mentioned
D - TRUE; savepoint helps to rollback some changes, thus it cannot issue a COMMIT
E - TRUE; DELETE is a DML change, and thus it can be undone with ROLLBACK
This section is not available anymore. Please use the main Exam Page.1z0-082 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Sharif1
Highly Voted 4 years, 2 months agoEkos
3 years, 11 months agoAbdullejr
Most Recent 9 months, 3 weeks agonautil2
1 year, 1 month agoHell3n
1 year, 2 months agoauwia
1 year, 4 months agoAramazd
2 years, 6 months agoryuah
2 years, 9 months ago