ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-809 All Questions

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

Exam 1z0-809 topic 1 question 197 discussion

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

Given the EMPLOYEE table:

Given the code fragment:

Assuming the database supports scrolling and updating, what is the result?

  • A. The program throws a runtime exception at Line 1.
  • B. A compilation error occurs.
  • C. A new record is inserted and Employee Id: 102, Employee Name: Peter is displayed.
  • D. A new record is inserted and Employee Id: 104, Employee Name: Michael is displayed.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by fffff at Feb. 11, 2021, 10:29 a.m.

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
Submit Cancel
fffff
Highly Voted 3 years, 11 months ago
102, peter is printed, tested
upvoted 6 times
...
6c84cb9
Most Recent 4 months ago
Answer C. A row with new data (104, Michael) has been added to the database, but it is not displayed in the program output because the cursor returned to the previous row after inserting the new record
upvoted 1 times
...
DarGrin
7 months, 2 weeks ago
Selected Answer: C
Employee Id: 102, Employee Name: Peter is displayed.
upvoted 1 times
...
iSnover
11 months, 2 weeks ago
Selected Answer: C
Answer is C, new record is inserted and Employee Id: 104, Employee Name: Peter is displayed.
upvoted 1 times
...
duydn
1 year, 3 months ago
Selected Answer: D
moveToCurrentRow() -> the newest row that we inserted https://docs.oracle.com/javase%2F7%2Fdocs%2Fapi%2F%2F/java/sql/ResultSet.html
upvoted 1 times
...
WilsonKKerll
2 years, 9 months ago
A new record is inserted and Employee Id: 104, Employee Name: Peter is displayed.
upvoted 1 times
...
WilsonKKerll
2 years, 10 months ago
Answer is C.
upvoted 2 times
...
DmitryK
3 years, 10 months ago
calling the method absolute(-2)moves the cursor to the next-to-last row
upvoted 2 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago