Oracle Exam 1Z0-151 Topic 9 Question 19 Discussion

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

Question #: 19
Topic #: 9

You do not want users to execute queries while in the Order_Items block, so you write the following key-Exeqry trigger for the Order_Items block:

GO_BLOCK('orders');

EXECUTE_QUERY;

This works fine except that in the Order_Items block, when you click Enter Query first, and then click Execute Query, you get the error message ''FRM-41009: Function key not allowed.'' What can you do correct this?

ASet the Fire in Enter-Query Mode property of the Key-Exeqry trigger to Yes.

BAdd the following as the first of the key-Exqry trigger to Yes.
SYSTEM.mode := 'NORMAL';

CDelete the Key-Exqry trigger and define the following Key-Entqry trigger for the Order_Items block:
GO_BLOCK ('orders');
ENTER_QUERY;

DDelete the Key-Exqry trigger and define the following Key-Entqry trigger for the Order_Items block:
ENTER_QUERY;
GO_BLOCK ('orders');

EChange the key-Exqry trigger to:
IF : SYSTEM.MODE := 'ENTER-QUERY' THEN
GO_BLOCK ('orders');
EXECUTE_QUERY;
ELSE
MESSAGE ('you cannot execute a query for the Order_Items block'):
END IF;
Define the following Key-Entqry trigger for the Order_Items block:
GO_BLOCK ('orders');
ENTER_QUERY

FChange the Key-Exeqry trigger to:
IF :SYSTEM.MODE != 'ENTER-QUERY' THEN
GO_BLOCK('orders');
EXECUTE_QUERY;
ELSE
MESSAGE ('You cannot execute a query in this block');
ENTER_QUERY;
GO_BLOCK ('orders');

GYou cannot change this behavior, but you should use the On-Message trigger to display a more meaningful message.

Show Suggested Answer

Suggested Answer: C

by Merilyn at May 06, 2022, 04:02 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-151 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

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