Oracle 1z0-151 問題集

質問 1：
Immediately after creating a button in the Layout Editor, what is true about the button?
A. It is not enabled.
B. It is an iconic button.
C. It is in the control block by default.
D. It has no functionality.
E. It is not keyboard navigable.
F. It is not mouse navigable.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which three statements are true about the PL/SQL Packages panel in the Forms debugger?
A. You ran select an option button to view the packages that have not yet been instantiated.
B. You can view packages only while the runtime process executes PL/SQL.
C. You can view the values of variables that are defined in the package specification.
D. You can select an option button to view server packages.
正解：B,C,D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
View the Exhibit.

The Departments form has form level triggers defined as shown in the Exhibit. You have enabled array DML for the Departments block by setting its DML array size to 5 and setting the Primary Key property of Department id to Yes. You set runtime preferences for Forms Builder to use array processing.
You want to test that array processing is actually occurring, so, as shown in the Exhibit, the On-Update, On-Delete, and on insert triggers have code that:
1. Displays a message to indicate which trigger is firing for which record?
2. Does the thing (either updates, deletes, or inserts)
The other triggers simply display a message, indicating the trigger that is firing.
You run the form from Forms Builder, but from the messages, you can tell that array processing is not occurring. What should you change so that array DML gets implemented?
A. Delete the "On-" triggers; these triggers remove default processing, including array processing.
B. Use the SYNCHRONIZE built-in after the MESSAGE built-in; otherwise, the message are not displayed until the processing is finished, giving the appearance that array processing is not taking place.
C. Set the DML array size to a value of 10 or greater; for array sizes loss than 10, array processing Is inefficient, and so is not performed.
D. Set the Enforce Primary Key property of the Department block to Yes; it is not enough to just set the Department_Id to be the primary key.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 4：
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?
A. Change the block names to uppercase in the condition (IF ...THEN) statements.
B. Use system variables in the GO_BLOCK statements.
C. instead of naming the block to navigate to, replace the GO_BLOCK built-in with NEXT_BLOCK
D. Change all occurrences of :SYSTEM.cursor_block to :SYSTEM.trigger_block.
E. Change the block names to uppercase in the GO_BLOCK statements.
F. Move the code to a PL/SQL program unit.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Yon have created a list item for the Credit__Rating field in the Customers form, the Finance department usually determines a range of scores that pertain to the customer, the values in the list are Excellent, Good, Fair, and Poor, corresponding to the ranges provided by Finance. The default value Fair, because that is the range that applies to most customers.
Sometimes, Finance can provide an exact credit score; so users must be able to enter the exact numerical value if it is known. Often clerks enter the customer data before the performance of a credit check, so they must be able to enter a blank value if the credit rating is not yet determined.
Users want to be able to select a blank value from the list, but the list does not display a blank line for them to select. How can you meet this requirement without changing the default value of the list item?
A. Set Mapping of other Values for the Credit_Rating Item to NULL.
B. You cannot change this type of list item to display a blank value; users must delete the default value records if the credit rating is not known.
C. Add a blank line to the list item when you define the static values.
D. Delete the NOT NULL constraint for the Credit_Rating Column in the database.
E. Set the Required property of the Credit_Rating item to No.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You want to use WebUtil functionality in the Orders form. What three things must you do to integrate WebUtil into the Orders Form?
A. Attach the WebUtil library to the Orders form.
B. Ensure that the WebUtil block is the last block under the Data Blocks node in the Object Navigator.
C. Set the Implementation Class Property for any items that will implement WebUtil JavaBeans.
D. Subclass the WebUtil object group from the WebUtil object library into the Orders form.
E. Copy the WebUtil object group from the WebUtil object library into a separate object library.
F. in the When-New-Form-instance trigger, register the WebUtil javaBeans.
G. Ensure that the WebUtil block is the first block under the Data Blocks node in the Object Navigator.
H. Copy the WebUtil library to the same directory as the Orders form.
正解：A,B,D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
When users enter address information, you want them to be able to select the state from a static list of values. You have not used a list of states before, and there is no database table that contains state information.
What is the first step in creating such a list of values as quickly as possible?
A. Create a new record group that is based on a SQL query.
B. Create a list item instead; a list of values is not appropriate for a static list.
C. Create a new static record group.
D. invoke the LOV wizard.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 8：
You have a form that called a database stored procedure. You do not want processing to continue, so immediately after the call to the stored procedure, you add the following code:
IF NOT FORM_SUCCESS THEN
MESSAGE ('Stored Procedure failure');
RAISE FORM_TRIGGER_FAILURE;
END IF;
You test the code and input some data that intentionally causes the stored procedure to fail. However, the message that you defined does not appear. What are two possible reasons for this?
A. You must handle database errors in an exception clause of the trigger.
B. You cannot test for failure of a stored procedure, because database errors are transparent to Forms.
C. You must test for FORM_FATAL when testing for failure of a stored procedure.
D. You must test for FORM_FAILURE when testing for failure of a stored procedure.
E. FORM_SUCCESS tests for failure of Forms built-ins, not stored procedures.
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 9：
You are coding a When-Checkbox-Changed trigger.
Which statements are available for use in your code?
A. restricted and unrestricted built-ins only
B. unrestricted built-ins only
C. PL/SQL statements and unrestricted built-ins only
D. PL/SQL statement-, and any built-ins
正解：D
解説: (Topexam メンバーにのみ表示されます)