If the INSERT INTO command is used to insert data values that violate an existin

Question

If the INSERT INTO command is used to insert data values that violate an existing constraint in a table, which of the following will happen?(Points : 4) a) Oracle will raise an error, and you will have to go update the incorrect data.
b) Oracle will raise an error, and the entire row will be rejected.
c) Oracle will raise an error, and the invalid piece of data will be rejected.
d) Oracle will raise an error, and all current transactions will be rolled back. If the INSERT INTO command is used to insert data values that violate an existing constraint in a table, which of the following will happen?(Points : 4) a) Oracle will raise an error, and you will have to go update the incorrect data.
b) Oracle will raise an error, and the entire row will be rejected.
c) Oracle will raise an error, and the invalid piece of data will be rejected.
d) Oracle will raise an error, and all current transactions will be rolled back.

Explanation / Answer

b) Oracle will raise an error, and the entire row will be rejected.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.