Oracle Exam 1Z0-151 Topic 5 Question 30 Discussion

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

Question #: 30
Topic #: 5

The Orders form has three blocks: Orders, Orders_Items, and inventories. It also has a button labeled Next Block with a When-Pressed trigger.

IF :SYSTEM.cursor_block = 'orders' THEN

GO_BLOCK('order_items');

ELSIF :SYSTEM.cursor_block = 'order_items' THEN

GO_BLOCK('inventories');

ELSIF :SYSTEM.cursor_block = 'inventories' THEN

GO_BLOCK ('orders');

END IF;

The button is not functioning correctly; it does not cause navigation to occur. What must you do to fix the issue?

AChange all occurrences of :SYSTEM.cursor_block to :SYSTEM.trigger_block.

BUse system variables in the GO_BLOCK statements.

CChange the block names to uppercase in the GO_BLOCK statements.

DChange the block names to uppercase in the condition (IF ...THEN) statements.

Einstead of naming the block to navigate to, replace the GO_BLOCK built-in with NEXT_BLOCK

FMove the code to a PL/SQL program unit.

Show Suggested Answer

Suggested Answer: D

by Tasia at May 05, 2022, 02:53 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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