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, 10 months agohighwater
Most Recent 4 months, 1 week agoJanThanh
10 months, 3 weeks agoacd3ea6
10 months, 3 weeks agoarchit4321
1 year, 3 months agoMIGHTYSTUNNERS
1 year, 3 months agopresido11111
1 year, 6 months agohmatinnn
1 year, 6 months agodilshod
2 years, 1 month agoDiplomiraniZnalac
2 years, 10 months ago