1Z0-141 · Question #62
The DBA informed you that a number column called ORDER_STATUS has been added to the ORDERS table. The DBA ran a SQL script to populate that column. You want to update the Orders form to display the…
The correct answer is A. Set the Database Item property to Yes for the Order_Status item. See the full explanation below for the reasoning.
Question
The DBA informed you that a number column called ORDER_STATUS has been added to the ORDERS table. The DBA ran a SQL script to populate that column. You want to update the Orders form to display the additional data. You currently have a non- base-table display item in the Orders block called Order_Total that you no longer want to use. The Order_Total item is located on the canvas in the position where you want the Order_Status item to appear. You open the Property Palette for Order_Total, change its name to Order_Status, and change its item type to Text Item. You run the form, but when you execute a query on the block, no data is displayed in the Order_Status item. What should you do to correct this problem?
Options
- ASet the Database Item property to Yes for the Order_Status item.
- BUse the form to populate the Order_Status item, since the SQL script that the DBA ran
- CSet the Name property for the Order_Status item to ORDER_STATUS, because it must be
- DUse the Data Block Wizard in reentrant mode to add the item, because you cannot add a
How the community answered
(24 responses)- A71% (17)
- B8% (2)
- C4% (1)
- D17% (4)
Community Discussion
No community discussion yet for this question.