تصحيح أسئلة في IZ0-131:

[Essam]

هذا تصحيح لأسئلة اعتقد أنها خاطئة ,الإجابة التي اعتقد أنها صحيحة تلي السهم ,ارجوا المشاركة ممن لديه المعرفة الكافية,وشكرا...

NOTICE:
Exam: 1Z0-131
Title: Oracle 9i: Build Internet Applications I
Version: 6.30-03

QUESTION NO: 7
The DBA has indicated that lock contention is occurring in the payroll application. To
reduce contention you create a timer that will display an alert prompting the user to
commit a rollback data after they have held a lock for a specified period of time. Which
built-in could you use in a When-Timer-Expired trigger to implement this functionality?
A. FIND_TIMER
B. CREATE_TIMER
C. SET_TIMER
D. DELETE_TIMER
E. GET_APPLICATION_PROPERTY
Answer: CE


QUESTION NO: 19
You have created a LOV that displays the DEPT_ID and DEPT_NAME columns and returns a value only for the DEPT_ID column. Users want to select a department from the list of the DEPT_NAME columns only. How would you resolve this question?
A. Set the Visible property to No for the DEPT_ID text item.
B. You cannot hide or remove the DEPT_ID column from the LOV because the
DEPT_ID column is the primary key in both the data block and the database table.
C. Create a Key-Listval trigger for the text item in which you write a SELECT statement
to query the database table DEPT_ID value for the selected DEPT_NAME value.
D. Set the Display Width property to 0 (zero) for the DEPT_ID column in the Column
Mapping properties for the LOV.
Answer: CD


QUESTION NO: 21
Which built-in subprogram can be used to create global variables?
A. NAME_IN B. COPY
C. DEFAULT_VALUE
D. LIST_VALUES
Answer: B C

QUESTION NO: 25
You are building a new application using generic code where possible, accessing Forms
variable names at runtime. Which two built-ins can you use to access the Form
variables? (Choose two)
A. COPY
B. NAME_IN C. DISPLAY_ITEM
D. GET_FORM_PROPERTY
E. GET_PARAMETER_LIST
F. GET_APPLICATION_PROPERTY
Answer: E, FA,B


QUESTION NO: 28
Which master detail property would you use to delete the master record, but prevent
detail records from being deleted?
A. Non-isolated
B. Cascading
C. Isolated
D. Restricted
Answer: B C


QUESTION NO: 48
When does transaction processing occur?
A. When the user selects Action --->Post from the menu.
B. When the user selects Action --->Rollback from the menu.
C. When the COMMIT_FORM built-in is called from a trigger.
D. When the POST_CHANGES built-in is called from a trigger.
Answer: BC

QUESTION NO: 59
You are developing the payroll application that contains the SALARY and COMMISSION forms. When a user invoked the COMMISSION form from the SALARY form, the SAL value should be passed to the COMMISSION form. In which
form and what time should you define the parameter to accept the value?
A. Salary form at run time.
B. Salary form at design time.
C. Commission for at runt time.
D. Commission form at design time.
Answer: C D

QUESTION NO: 60
Which built-in allows you to dynamically change the alert message text?
A. SET_ALERT_MESSAGE
B. SET_ALERT_PROPERTY
C. CHANGE_ALERT_PROPERTY
D. CHANGE_MESSAGE_ALERT
Answer: CB

QUESTION NO: 61
You want to skip validation on one of the items in a form, so that validation is not
performed on that particular item. How could you do this?
A. Set the item’s Item Is Valid property.
B. Set the item’s Automatic Skip property.
C. Set the item’s Database Item property to No.
D. Set the validation unit to Record instead of Item.
Answer: BA

What are three main components to consider when you design a trigger? (Choose three)
A. Trigger code.
B. Trigger type.
C. Trigger menu.
D. Trigger scope.
E. Trigger navigation.
F. Trigger validation.
G. Trigger interaction.
Answer: C, D, EA,B,D



QUESTION NO: 65
In Form Builder you attempt to compile a trigger. You receive a compilation error that
gives no clear indication of the problem. What are two likely causes? (Choose two)
A. Dividing by zero.
B. Missing semicolon.
C. Mismatched quotes.
D. Mistyped variable name.
E. Trigger defined on wrong item.
F. Trigger defined at wrong item.
Answer: C, B


QUESTION NO: 68
You created a form that has two data blocks. Which two default navigation methods can
a user employ to move the cursor from the first block to the second block? (Choose two)
A. Press the [NEXT BLOCK] function key.
B. Click an item in the second block with the mouse.
C. Click the single right-arrow icon on the menu toolbar.
D. Right-click an item in the first block, and choose Next Block from the pop-up menu.
Answer: B, C

QUESTION NO: 76
Which three properties add functionality to a text item? (Choose three)
A. Window
B. Multi-Line
C. Wrap Style
D. Raise on Entry
E. Execution Style
F. Case Restriction
G. Horizontal Scroll Bar
Answer: B, C,F


The general ledger application contains a form that uses Oracle graphics to display a pie
chart for operating expenses by department. The user would be able to enter a specified
accounting period to be displayed. Which built-in could you use to populate the record
group to display data for a specified accounting period?
A. CREATE_GROUP_FROM_QUERY
B. POPULATE_LIST_WITH_QUERY
C. FIND_GROUP
D. POPULATE_GROUP
Answer: CA

Which two statements about list items are true? (Choose two)
A. A list item must have an access key.
B. A list item can be true, false, or null.
C. A list item is an alternative to a radio group.
D. A value in a list item can be set programmatically.
E. A list item can be used to select more than one value at the same time.
Answer: A, B C,D

What happens when a user clicks the red X icon on the default menu toolbar?
A. The current record is removed from the block.
B. The current record is deleted from the database.
C. The current record is blanked out to enable entry of new data.
D. The current record is placed at the end of the block’s list of records.
Answer: DA

You are customizing default functionality of an image item so that the image displays
when a user single-clicks the item. Which trigger would you use to accomplish the task?
A. When-New-Item-Instance
B. When-Image-Activated
C. When-Image-Pressed
D. When-Validate-Item
Answer: B C

QUESTION NO: 99
The menu tool bar icons do not in the order that you want. Which two ways can you
change the order of the items? (Choose two)
A. Alter the order of the menu items in the object navigator.
B. Change the order of the menu items in the menu editor.
C. Click and drag the icons in the layout editor to the appropriate position.
D. Cut and paste in the layout editor to position the icons.
E. Use the select tool in the menu editor to position the icons.
Answer: A, BC,D

QUESTION NO: 106
You created the EMP_DATA data block in the EMPLOYEE form based on all the
columns of the EMPLOYEE form based on all the columns of the EMP table. After
viewing the prototype, users are asking that you remove the SALARY column from the layout. This column is used in the data block to perform bonus calculations.
How would you remove this column from the layout while leaving it in the data block?
A. You must delete the EMP_DATA data block and recreate it.
B. Select the Salary item in the Layout Editor and press DELETE.
C. You must remove the column from the data block to remove it from the layout.
D. Select the frame surrounding the EMP_DATA data block in the Layout Editor, click
the Layout Wizard tool, and remove the SALARY column from the Displayed Item
list.
E. Select the EMP_DATA data block in the Object Navigator, choose Tools->Data Block
Wizard, and remove the SALARY column from the included list.
The SALARY column will automatically be removed from the layout.
F. Double-click the EMP_DATA data block in the Object Navigator to launch the Data
Block Wizard, remove the SALARY column from the included columns, enter the
Layout Wizard, and remove the SALARY column from the Displayed Items list.
Answer: FD



QUESTION .151You create a multi-record block. The user requests that the record with input focus be
displayed with a red background and white foreground. You create a visual attribute, red _white, for this
purpose. Which block property do you set to accomplish this task?
A. Records Displayed
B. Reference Information
C. Update Changed Columns
D. Current Record Attribute
Answer: CD