oracle 1Z0-151 Exam Questions

Questions for the 1Z0-151 were updated on : May 23 ,2024

Page 1 out of 6. Viewing questions 1-15 out of 90

Question 1

The Credit_Rating item in the Customers block of an Order Entry form must be restricted to three
possible values: Good, Poor, or Null (the latter value indicates that the credit rating has not been
determined). Order entry clerks must be able to update this item to any of the preceding three
values.
You want to change the item to a check box labeled "Credit Risk" that should be selected if the
customer has poor credit, the check box should not be selected if the customer's credit rating is good
or undetermined.

You change the item type to Checkbox, set other properties as shown in the Exhibit, and then run
your form and insert three records: two with good credit and the check box deselected, and one with
poor credit and the check box selected. You commit the data and query the records, with the
following result set:

The first two records show an undetermined credit rating, although your intention was to set the
value to Good for these customers. What change must you make in the properties of the
Credit_Ratinq item to enable values of Good, Poor, and Null to be entered?

  • A. 1, 2, 3, 4, 5, 6, 7, and 8
  • A. Change the initial Value property to Good.
  • B. 7, 5, 3, 2, 4, 6, and 8
  • B. Change the Check Box Mapping of Other Values property to Not Allowed.
  • C. 7, 5, 3, 2, 4, 6, and 8 only
  • C. Change the initial Value property to Good and the Value When Unchecked property to Null.
  • D. 7, 5, 3, 4, 6, and 8 only
  • D. Change the initial Value property to Good and the Chock Box Mapping of Other Valued property to Null.
  • E. 7 and 8 only
  • E. Change the initial Value property to Good and the Check Box Mapping of Other Values property to checked.
  • F. Change the item type. It is not appropriate to use a check box to enable entry and update of more than two values in an item.
Answer:

F

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%

Explanation:

Incorrect answers:
F: A check box is not limited to two values.

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

Question 2

When tabbing through items in the Employees form, users should not be able to navigate to the
Salary text item. If they need to update the item, they will have to explicitly navigate to it by using
the mouse.
Which property setting accomplishes this requirement?

  • A. True
  • A. Enabled = Yes; Keyboard Navigable = No
  • B. False
  • B. Enabled = No; Keyboard Navigable = Yes
  • C. Enabled = Yes; Keyboard Navigable = Yes
  • D. Enabled = No; Keyboard Navigable = No
  • E. Automatic Skip = Yes
Answer:

A

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
D
E
0 / 1000

Question 3

You have a text item in your form named Object1. You want to create Object2 as an exact duplicate of
Object1. You want to be able to change the properties of Object2. However if you change Object1,
you do not want Object2 to change.
Which method of reusing Object1 would be best for these requirements?

  • A. Change the second window to a modal window.
  • A. Copying Object1
  • B. Code a When-Window-Closed trigger for each window.
  • B. Subclassing Object1
  • C. Set Close Allowed to Yes for both windows.
  • C. Creating a property class from Object1
  • D. Set Hide on Exit to Yes for both windows.
  • D. Putting Object1 in an Object library
  • E. Referencing Object1 in a PL/SQL library
Answer:

A

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
0 / 1000

Question 4

The Orders form has four blocks. The Orders and Order_items block are on the CV_Order content
canvas; the inventories block items are on the CV_inventories content canvas; and Control block
buttons are on the CV_Buttons toolbar canvas. All buttons have mouse Navigate set to No.
The Order_Items block is a detail of Orders. The inventories block is a detail of Order_Items, showing
the stock of the selected product.
There is a button in the Control block with a When-Button-Pressed trigger:
IF GET_CANVAS_PROPERTY(:SYSTEM.cursor_item, item_canvas) = 'CV_ORDER' THEN
GO_BLOCK ('inventories')
ELSE
GO_BLOCK('orders');
END IF;
When you run the form and click the button, navigation does not occur, and the form displays the
runtime error FRM-41053: Cannot find Canvas: invalid ID. What should you do to correct this
problem?

  • A. You receive a compilation error.
  • A. Change the sequence of blocks in the Object Navigator
  • B. The form starts to run, but immediately closes. So If an error message Is displayed, you are unable to see it.
  • B. Chang the Mouse Navigator property of the button to yes
  • C. The form runs, but as soon as it appears, you receive a runtime error.
  • C. in the first line of code, change the built-in to GET_ITEM_PROPERTY
  • D. The form runs, but as soon as you perform any navigation, a runtime error occurs.
  • D. in the first line of code, change the system variable to: SYSTEM.CURSOR_CANVAS.
  • E. The form runs with no problem.
  • E. in the first line of code, change the CV_ORDER to lowercase
  • F. Chang the argument to the GO_BLOCK built-ins to uppercase
Answer:

C

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

Question 5

Which four types of variables must have their names preceded by a colon when they are referenced
in trigger code?

  • A. MENU3 only
  • A. PL/SQL variables
  • B. ITEM6 only
  • B. Form items
  • C. MENU3, ITEM4, ITEM5, ITEM5_MENU, and ITEMG
  • C. global variables
  • D. ITEM4, ITEM5, and ITEM6 only
  • D. system variables
  • E. ITEM4 and ITEM5 only
  • E. parameters
  • F. ITEM 4 and ITEM6 only
  • G. ITEM5 and ITEM only
  • H. MENU3 and ITEM5_MENU only
Answer:

BCDE

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
G
50%
H
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
G
H
0 / 1000

Question 6

The Order Entry application contains several forms. The inventories form uses an LOV that is based
on a record group that queries the Warehouses table to return a warehouse ID.
Several of the forms use LOVs that are based on the same query. You decide to centralize the creation
of the record group to the entry form of the application, which opens all the other forms, for
example, to open the inventories form, there is a When-Button Pressed trigger on the inventories
button with the following code;
OPEN _FORM ('inventories');
in a When-New-Form-instance trigger for the entry form, you create the warehouse_rg record group
by using the CREATE_GROUP_QUERY built in with the following arguments:
('warehouse_rg' , 'SELECT ALL WAREHOUSE.WAREHOUSE_ID, WAREHOUSE.WAREHOUSE_NAME
FORM WAREHOUSE order by warehouse_name);
You also populate the record group in this trigger.
What must you do to make this record group available to the inventories form and the other forms?

  • A. SHOW_LOV
  • A. in the When-New-Form-instance trigger for the entry form, add a values for the SCOPE argument of CREATE_GROUP_QUERY.
  • B. FIND_LOV
  • B. in the entry form, move the record group code to the end of the When-Button-Pressed triggers for the buttons that open other forms, so that the record group is created and populated immediately after OPEN_FORM is called.
  • C. GET_ITEM_PROPERTY
  • C. in the entry form, move the record group code to the beginning of the When-Button-Pressed triggers for the button that open other forms, so that the record group is created and populated just before OPEN_FORM is called.
  • D. GET_LOV_PROPERTY
  • D. in the When-Button_Pressed triggers of the entry from the buttons that open other forms, add a value for the SESSION argument of OPEN_FORM.
  • E. GET_APPLICATION_PROPERTY
  • E. in the other forms, refer to the record group as: global.warehouse_rg.
Answer:

A

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%

Explanation:
Note: The CREATE_GROUP_FROM_QUERY built-in is a function and must be invoked as part of an
expression. For example:
DECLARE
rg_id
RecordGroup;
BEGIN
rg_id := CREATE_GROUP_FROM_QUERY ('employee_rg', 'SELECT id,first_name,last_name,sal FROM
employee');
END;

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 7

View the Exhibit.

Iin the Human Resources form shown in the Exhibit, you want to modify the prompts, heights, and
widths of the Department Id, Manager Id, and Location Id Holds in the Departments data block.
What must you select before invoking the Layout Wizard in reentrant mode to modify these item
properties?

  • A. main menus
  • A. Frame5
  • B. individual menus
  • B. Frames
  • C. submenus
  • C. Canvas4
  • D. menu items
  • D. the Departments block
  • E. all of the above
  • E. the DEPARTMENT_ID, MANAGER_ID and LOCATION_ID items
Answer:

A

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 8

You are implementing a JavaBean in a form, the bean has no visible component on the form when
invoked, the bean displays an input text where users enter a zip code, the bean has a single method
that returns a short weather forecast for that zip code as a character value.
How can you retrieve that value so that you can display it to the user?

  • A. It is an iconic button.
  • A. Use FBEAN.ENABLE_EVENT to register a listener for the bean event. Obtain the value of SYSTEM.CUSTOM_ITEM_EVENT in a When-Custom item Event trigger, and then use that value as an argument to the MESSAGE built in.
  • B. It has no functionality.
  • B. Use FBEAN.REGISTER_BEAN as an argument to the MESSAGE built in to invoke the bean's method and return the value as a message displayed to the user.
  • C. It is not mouse navigable.
  • C. Use FBEAN.REGISTER_BEAN to register the bean, so that when the user enters a zip code into the bean s input text, the value is automatically displayed in the bean area item.
  • D. It is not keyboard navigable.
  • D. Use FBEAN.ENABLE_EVENT to register a listener for the bean event. Obtain the value of SYSTEM.CUSTOM_EVENT_PARAMETER in a When_Custom-item-Event trigger, and then use that value as an argument to the MESSAGE built-in.
  • E. It is in the control block by default.
  • F. It is not enabled.
Answer:

D

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
F
50%

Explanation:
When a user interacts with a JavaBean at run time, it usually causes an event to occur.
You can use FBEAN.ENABLE_EVENT to register a listener for the event, so that when
the event occurs Forms will fire the When-Custom-Item-Event trigger. In this trigger, you
can code a response to the event. The :SYSTEM.CUSTOM_ITEM_EVENT and
:SYSTEM.CUSTOM_EVENT_PARAMETERS variables contain the name of the event and
information the bean is sending to the form.

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
F
0 / 1000

Question 9

The Orders database table uses Order_id as its primary key. You have written the following code to
use in the Orders block of a form:
SELECT orders_seq.NEXTVAL
INTO :orders.order_id
FROM SYS.dual;
Which statement is true about this code?

  • A. 0
  • A. If you place this Code in a trigger that fires when the record is inserted into the database, you will likely have more gaps in Order IDs than if you use the sequence as a default value for the item.
  • B. 10
  • B. If you place this code in a trigger, you should ensure that Order_Id has its required property set to Yes.
  • C. 25
  • C. If you place this code in a trigger, you should ensure that Order_Id has its Database Item property set to No.
  • D. 50
  • D. If the named sequence does not exist, it is automatically created the first time the code is called.
  • E. You cannot use :SYSTEM.MESSAGE_LEVEL to suppress all system messages
  • E. You should place this code a in a database trigger to minimize the gaps in Order IDs.
  • F. You should place this code in Pre-insert trigger to minimize the gaps in Order IDs.
  • G. You should place this code in a Post_insert trigger to minimize the gaps in Order IDs.
Answer:

F

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
G
50%

Explanation:
Assigning Sequence Numbers to Records
You will recall that you can assign default values for items from an Oracle sequence, to
automatically provide unique keys for records on their creation. However, if the user does
not complete a record, the assigned sequence number is wasted.
An alternative method is to assign unique keys to records from a Pre-Insert trigger,
just before their insertion in the base table, by which time the user has completed the
record and issued the Save.
Assigning unique keys in the posting phase can:
* Reduce gaps in the assigned numbers
* Reduce data traffic on record creation, especially if records are discarded before
saving
Example
This Pre-Insert trigger on the ORDERS block assigns an Order ID from the sequence
ORDERS_SEQ, which will be written to the ORDER_ID column when the row is
subsequently inserted.
SELECT ORDERS_SEQ.nextval
INTO :ORDERS.order_id
FROM SYS.dual;

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
G
0 / 1000

Question 10

In Forms Builder, the iconic buttons on the form are blank, but when you click Run Form the form
appears in the browser with Images in the iconic buttons.
What are two things that you can check to track the source of this problem?

  • A. True
  • A. forms Builder runtime preferences
  • B. False
  • B. the UI_ICON setting in the operating system
  • C. the iconpath setting in the Forms registry file
  • D. the UI_ICOM_EXTENSION setting in the operating system
  • E. the iconextension setting in the Forms registry file
  • F. the FORMS_PATH setting in the Forms environment file
  • G. the classpath setting in the operating system
Answer:

B, D

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
D
50%
E
50%
F
50%
G
50%
Discussions
vote your answer:
A
A
B
B
C
D
E
F
G
0 / 1000

Question 11

You want to display employee records in tabular format, but the form is not wide enough to display
all the items in the Employees block. The employee IDs and names of displayed records should
always be visible, but you want to scroll the additional information as users tab through the Items,
the form should look like a spreadsheet with the first two columns frozen.
Which canvas types would be most appropriate in this scenario?

  • A. Change all occurrences of :SYSTEM.cursor_block to :SYSTEM.trigger_block.
  • A. content canvas in a window with a horizontal scroll bar
  • B. Use system variables in the GO_BLOCK statements.
  • B. content canvas and multiple tab canvases
  • C. Change the block names to uppercase in the GO_BLOCK statements.
  • C. content canvas and a tab canvas with multiple tab pages
  • D. Change the block names to uppercase in the condition (IF ...THEN) statements.
  • D. content canvas and a stacked canvas with a horizontal scroll bar
  • E. instead of naming the block to navigate to, replace the GO_BLOCK built-in with NEXT_BLOCK
  • E. multiple content canvases
  • F. Move the code to a PL/SQL program unit.
Answer:

D

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%

Explanation:
After an entity is divided into groups, if all groups cannot be displayed simultaneously,
it becomes necessary for two or more regions to be displayed in the exact same space,
one at a time, using a Tab control. The user can jump to a specific region by selecting a
tab or by progressing continuously through all fields of all Tab regions. A set of fields,
minimally the primary key fields, should remain visible so the user can maintain
context at all times. There, "frozen" fields must be placed inside the Tab control on the
left side.
When best to use Tab regions:
* When the user must see all fields of a record in a single window, but they do not
need to see them all simultaneously.
* When entire regions need to be hidden from a user due to security restrictions, the
current state of data, or other product installations.

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

Question 12

You have created a complex menu structure with several types of menu objects. To which objects
would you assign menu commands?

  • A. Change the sequence of blocks in the Object Navigator
  • A. main menus
  • B. Chang the Mouse Navigator property of the button to yes
  • B. individual menus
  • C. in the first line of code, change the built-in to GET_ITEM_PROPERTY
  • C. submenus
  • D. in the first line of code, change the system variable to: SYSTEM.CURSOR_CANVAS.
  • D. menu items
  • E. in the first line of code, change the CV_ORDER to lowercase
  • E. all of the above
  • F. Chang the argument to the GO_BLOCK built-ins to uppercase
Answer:

E

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%

Explanation:
The Menu Editor is a graphical design facility for laying out, modifying, and viewing menu modules
and their objects. You can use the Menu Editor to carry out all of your menu design work.
Note:
To use the Menu Editor to create a basic structure for your menu, perform the following steps:
1 .
With the SUMMIT_MENU module selected, perform one of the following actions to invoke the Menu
Editor:
Double-click the icon to the left of the module
Right-click the module and select Menu Editor
Select Tools > Menu Editor from the Forms Builder menu
2 .
When you invoke the Menu Editor, it automatically creates the main menu and one menu item. The
main menu is the menu whose items, which can be menu items or submenus, show in the menu bar
when you run a form.
In the Object Navigator, change the name of the main menu to MAIN_MENU in the same way that
you changed the name of the menu module.
3 .
In the Object Navigator, change the name of the menu item to File.
4 .
Note that the item's display label in the Menu Editor remains the same.
The label is the text that is displayed for the menu item at run time. The label may differ from the
name. You use the name programmatically, and it must follow PL/SQL naming conventions.
Change the label of the menu item by double-clicking <New_Item> in the Menu Editor and typing
the new label of File.
5 .
Create two menu items under File. In the Menu Editor, select File, then click Create Down twice.
6 .
In the Menu Editor, relabel the menu items to Save and Exit.
Note that creating menu items under the File object creates a FILE_MENU object as a menu with two
items under it. Also, when you relabel the items in the Menu Editor, the names of the items, as
shown in the Object Navigator, also change.
7 .
Create another submenu of the main menu and label it Edit by performing the following steps:
In the Menu Editor, select the File node.
Click Create Right.
Relabel the new menu Edit.
8 .
In a similar fashion to the way you created the File menu items, create two items for the Edit menu
labeled Copy and Paste.
9 .
You can also use the Object Navigator to add a menu item.
Under the Edit_Menu in the Object Navigator, select the Items node and click Create.
10 .
In the same way as you did with other items, relabel the new item in the Menu Editor with the label
Cut, which also renames it in the Object Navigator.
Reference: Creating Oracle Forms Menus

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

Question 13

View the Exhibit.

The Departments table in the database contains four columns. In a new form, you use the Data Block
Wizard to add all columns to the block, but in the layout Wizard, you choose all columns except
Location_Id to add to the canvas. The Object Navigator and layout Editor appear as shown in the
Exhibit.
You then decide that you do need to display Location_Id on the canvas. What object must you select
before invoking the Layout Editor in re-entrant mode to make this change?

  • A. True
  • A. the text item tool in the Layout Editor
  • B. False
  • B. Frame 16 in either the Object Navigator or the layout Editor
  • C. Canvas4 in either the Object Navigator or the Layout Editor
  • D. Location_Id in the Object Navigator
  • E. the Departments data block in the Object Navigator
Answer:

D

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
D
E
0 / 1000

Question 14

To avoid overloading the database during busy times, you decide to restrict the queries that are
executed on the Orders form so that users query by either Order ID or Customer ID during these
times. Which trigger is most appropriate for the code to enforce this restriction?

  • A. initial Value property
  • A. When-New-Form-instance
  • B. User input
  • B. When-New-Block-instance
  • C. When-Button-Pressed trigger
  • C. On-Query
  • D. Calculation
  • D. Pre-Query
  • E. Executing a query
  • E. Post-Query
Answer:

D

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%

Explanation:
About controlling queries with Pre-Query and Post-Query triggers
The Pre-Query and Post-Query triggers allow control over query processing. They can be defined at
the form or block level. Most often, attach them to specific blocks to control the query functionality
of those blocks.
The Pre-Query trigger fires just before Form Builder issues the SELECT statement to the database,
after the operator has defined the example record by entering query criteria in Enter Query mode.
Inside a Pre-Query trigger, the example record defined by the query criteria is the current record.
This means that trigger code can read and set the values of items in the example record using
standard :block_name.item_name syntax.
A Pre-Query trigger can be used to disallow query conditions that might be invalid. When a form is
in Enter Query mode, normal validation is suspended and no validation triggers fire as they do in
Normal mode. The Pre-Query trigger thus allows you to verify that any values entered by the
operator are valid query conditions.
When invalid query conditions have been entered, you can abort the query by raising the
FORM_TRIGGER_FAILURE built-in exception in the Pre-Query trigger.
You can also call SET_BLOCK_PROPERTY to modify the block's WHERE and ORDER BY clauses from
within the Pre-Query trigger, to further restrict or order the records the query will retrieve.

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 15

You have created an editor named MyEditor, and you want it to be available to edit the text item
Product_Description. You can associate the editor with the text item by setting the Editor property of
Product_Description to MyEditor.

  • A. When-New-Form-instance
  • A. True
  • B. When-New-Block-instance
  • B. False
  • C. On-Query
  • D. Pre-Query
  • E. Post-Query
Answer:

A

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
D
E
0 / 1000
To page 2