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

Exam 1z0-149 All Questions

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

Exam 1z0-149 topic 1 question 59 discussion

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

Examine these statements from a block of code:

Which two are true? (Choose two.)

  • A. The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.
  • B. Only the PRICE column can be updated in the PRODUCTS table.
  • C. The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.
  • D. The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.
  • E. An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.
Show Suggested Answer Hide Answer
Suggested Answer: AD 🗳️
by 826cb95 at Feb. 21, 2025, 5:23 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
826cb95
1 month, 3 weeks ago
Selected Answer: AD
A - The lock acquired by the FOR UPDATE clause is released when the cursor is closed, not necessarily after a COMMIT or ROLLBACK. However, issuing a COMMIT or ROLLBACK will also release the lock. INTERVIEWSANSAR.COM D The WHERE CURRENT OF clause is used in conjunction with a cursor that has been declared with the FOR UPDATE clause. It allows you to perform updates or deletes on the current row fetched by the cursor.
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago