A. DML statements always start new transactions. (X). Not always
B. DDL statements automatically commit only data dictionary updates caused by executing the DDL. (X) Not "only" data dictionary
C. A session can see uncommitted updates made by the same user in a different session. (X) in the same session
D. A DDL statement issued by a session with an uncommitted transaction automatically commits that transaction.
E. An uncommitted transaction is automatically committed when the user exits SQL*Plus.
D. A DDL statement issued by a session with an uncommitted transaction automatically commits that transaction
E. An uncommitted transaction is automatically committed when the user exits SQL*Plus
A : transaction contains of one or more dml statements or DDL statement
D : because DDL make commit before and after DDL statement
https://docs.oracle.com/cd/E11882_01/server.112/e40540/transact.htm#CNCPT016
This section is not available anymore. Please use the main Exam Page.1z0-071 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.
holdfaststrongly
Highly Voted 2 years, 9 months agohighwater
Most Recent 2 months, 3 weeks agoJanThanh
9 months agoacd3ea6
9 months agoarchit4321
1 year, 1 month agoMIGHTYSTUNNERS
1 year, 1 month agopresido11111
1 year, 4 months agohmatinnn
1 year, 4 months agodilshod
2 years agoDiplomiraniZnalac
2 years, 8 months ago