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