Oracle Exam 1Z0-151 Topic 7 Question 9 Discussion

Actual exam question for Oracle's 1Z0-151 exam

Question #: 9
Topic #: 7

You have a form with a single multi-record block. During a session, a user performs an insert and clicks Save

What is the behavior of the record being inserted violates a database constraint?

AThe record is posted to the database but not committed. The form redisplays the record with an error message so that the user can correct the data. Navigation to another record cannot occur until the correct data is committed or the new record is deleted. If the user exits the form without correcting the entry, a database rollback is performed.

BThe record is committed to the database. The form redisplays the record with an error message so that the user can correct the data. The user is unable to exit the form or move to another record until the correct data is committed of the new record is deleted.

CA database rollback is performed. The form redisplays the record with an error message so that the user can correct the entry. The user is able to navigate to another record or exit the form.

DA database rollback is performed. The form redisplays the record with an error message so that an correct the entry. Navigation to another record cannot occur until the correct data is committed or the record is deleted.

EThe record is committed to the database. The form redisplays the record with a warning in case the user would like to correct the entry. The user is able to navigate to another record or exit the form.

Show Suggested Answer

Suggested Answer: C

by Lynelle at May 06, 2022, 04:36 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-151 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!