exam questions

Exam 1z0-809 All Questions

View all questions & answers for the 1z0-809 exam

Exam 1z0-809 topic 1 question 149 discussion

Actual exam question from Oracle's 1z0-809
Question #: 149
Topic #: 1
[All 1z0-809 Questions]

Given the records from the STUDENT table:

Given the code fragment:

Assume that the URL, username, and password are valid.
What is the result?

Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
DarGrin
1 week, 3 days ago
Selected Answer: D
D. SQL Exception due to rs.moveToInsertRow(); If we delete rs.moveToInsertRow(); the programm works fine
upvoted 1 times
...
lchowen
1 year, 8 months ago
Answer is D, because the correct way to insert a row is rs.insertRow(). Calling updateRow() at the insertion row throws SQL exception
upvoted 1 times
...
xijxeyho
3 years, 1 month ago
movetoInsertRow() moves position to "next row when record can be inserted". So it looks that content is inserted after row "114". refresh() is called after updateRow(). It is ok inserted content is not lost. C in my opinion.
upvoted 1 times
...
DmitryK
3 years, 3 months ago
This method cannot be called when the cursor is on the insert row. for rs.moveToInsertRow(); Ok
upvoted 1 times
...
JME_CHG
3 years, 3 months ago
D because called refresh() before calling rs.insertRow() so updates in insert row lost (can someone confirm this please???) Also, if moveToInsertRow() removed, and called rs.updateRow() at the end, then answer would be C???
upvoted 2 times
Svetleto13
3 years ago
Yes you are right.thats correct
upvoted 1 times
...
...
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.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago