Jul 2016 updated: Ucertify Oracle 1z0-141 practice exam 41-50

Cause all that matters here is passing the Oracle 1z0-141 exam. Cause all that you need is a high score of 1z0-141 oracle9i forma developer:build internet applications exam. The only one thing you need to do is downloading {brand} 1z0-141 exam study guides now. We will not let you down with our money-back guarantee.

2016 Jul 1z0-141 Study Guide Questions:

Q41. The database EMPLOYEES table has a foreign key constraint referencing the DEPARTMENTS table.

You are developing a Human Resources application. HR clerks use the Employees form to query, update, and insert employee records. They occasionally attempt to add an employee who is in a new department that has not yet been entered into the database. When this happens, they receive an error indicating that the parent record cannot be found, so they cannot commit the employee record.

The HR clerks have requested that you place a button on the form to enable them to invoke the Departments form to enter the new department and save it independently. Then they want to be able to return to the Employees form and decide whether or not to save the new employee record.

How should you code the When-Button-Pressed trigger to achieve this?

A. NEW_FORM('Departments');

B. OPEN_FORM('Departments',NO_ACTIVATE,NO_SESSION);

C. OPEN_FORM('Departments');

D. CALL_FORM('Departments'); E. POST;

NEW_FORM('Departments',FULL_ROLLBACK);

F. CALL_FORM('Departments',NO_HIDE);

G. OPEN_FORM('Departments',ACTIVATE,SESSION);

Answer: G

Q42. The Orders form has two Record Groups: the SHIP Record Group that was created at design time, and the SOLD Record Group that was created at run time. You are required to write a Program Unit that will delete both Record Groups. Which two statements describe your situation? (Select two.)

A. You cannot delete Record Group SOLD at run time.

B. You should delete Record Group SHIP with built-in DELETE_GROUP('SHIP');

C. You cannot delete Record Group SHIP at run time.

D. You should delete Record Group SHIP with built-in DELETE_GROUP_ROW('SHIP',ALL_ROWS);

E. You should delete Record Group SOLD with built-in DELETE_GROUP_ROW('SOLD',ALL_ROWS);

F. You should delete Record Group SOLD with built-in DELETE_GROUP('SOLD');

Answer: CF

Q43. View the Exhibit.

You are coding a When-New-Form-Instance trigger to populate a hierarchical tree item called Emp_Tree that should initially appear as shown in the exhibit. Mr. King, the president of the company, is the only employee who does not have a manager.

In the trigger, you declare a variable called rg_emps that is of the RECORDGROUP data type.

You will use this record group to populate the tree. You use the following code to create the record group:

rg_emps := Create_Group_From_Query('rg_emps', 'select 1, level, last_name, NULL,

to_char(employee_id) from employees connect by prior employee_id = manager_id start with manager_id is null');

You then programmatically populate the record group, and then populate the tree with the record group.

You run the form to test it. Will the tree initially appear as shown? If not, why not?

A. No. You should eliminate the last element selected in the select statement, because you do not want to display the employee ID.

B. No. The "connect by" statement should be "connect by prior manager_id = employee_id".

C. Yes, the tree will appear as shown.

D. No. The first element selected in the select statement should be 4 because you want four levels of the tree to be displayed.

Answer: C

1z0-141  real exam

Regenerate 1z0-141 practice exam:

Q44. You are developing a form that serves as a front end to access the Order Entry application. Within the form you want to store the usernames of those users who have permission to run the application. This information is accessed when the form starts up to determine if the user is authorized. The list of usernames is not stored in the database and should not be visible to users.

How will you store this information?

A. In a record group

B. You cannot store this information within a form; you must create a database table to store it and query the information at run time.

C. In a list item

D. In a list of values

E. In a set of parameters

Answer: A

Q45. In the Orders form, you create a button in the CONTROL block to send the input focus to the INVENTORIES block and cause it to be queried.

You write this code in a When-Button-Pressed trigger:

GO_BLOCK('Inventories');

EXECUTE_QUERY;

What happens when you test the form?

A. The form compiles and runs as required. Focus moves to the INVENTORIES block, and it is queried automatically when the button is clicked.

B. The form will not compile because the block name must be uppercase.

C. The form compiles, but clicking the button causes a Navigation Trap to be encountered. You must revise the code to avoid such a trap.

D. The form compiles, but clicking the button leaves the focus in the original block, which is then queried. This could have been prevented if you had coded a check for FORM_SUCCESS after the GO_BLOCK();

E. The form compiles, but clicking the button causes an error message to appear. GO_BLOCK() is a restricted procedure and cannot be called from any "When" triggers.

F. The form compiles and focus moves to the INVENTORIES block. But because the internal cursor is still in the CONTROL block, the query is attempted against the wrong block.

Answer: A

Q46. During testing, you received comments that the default functionality of the [Commit] key can cause an error message to be displayed if there are no changes to save when it was activated.

You decide to provide a button for users to validate the form and issue a commit if necessary. To implement this, you write a form-level procedure called VALIDATE_AND_COMMIT.

The same functionality must be provided when the user chooses File > Save from the menu or presses the [Commit] key.

Which should you use?

A. The When-Button-Pressed trigger with the code

DO_KEY('COMMIT_FORM');

A form-level Key-Commit trigger with the code

validate_and_commit;

B. The When-Button-Pressed trigger with the code

DO_KEY('[COMMIT]');

A form-level Key-Commit trigger with the code

DO_KEY('validate_and_commit');

C. The When-Button-Pressed trigger with the code

DO_KEY(commit;);

A form-level Key-Commit trigger with the code

validate_and_commit;

D. The When-Button-Pressed trigger with the code

validate_and_commit;

A form-level Key-Commit trigger with the code

DO_KEY('COMMIT_FORM');

E. The When-Button-Pressed trigger with the code

DO_KEY('COMMIT_FORM');

A form-level Key-Commit trigger with the code

DO_KEY('COMMIT_FORM');

validate_and_commit;

Answer: A

certleader.com

Actual 1z0-141 cram:

Q47. View the Exhibit.

You have created three list items, each of which is in a different list style. You have defined the same four list elements for each list item. The exhibit depicts the list items at run time after user input.

What is the list style of each list item?

A. List 1: Poplist; List 2: Combo box; List 3: Tlist

B. List 1: Tlist; List 2: Poplist; List 3: Combo box

C. List 1: Combo box; List 2: Poplist; List 3: Tlist

D. List 1: Poplist; List 2: Tlist; List 3: Combo box

E. List 1: Tlist; List 2: Combo box; List 3: Poplist

F. List 1: Combo box; List 2: Tlist; List 3: Poplist

Answer: A

Q48. You are developing a Human Resources form for HR clerks to insert, update, and delete records from the EMPLOYEES table. When the user commits records, Forms displays the default informative message "FRM-40400: Transaction complete: <n> records applied and saved."

You want to replace that with the message "Records inserted: <n> Records updated: <n> Records deleted: <n>", where <n> represents the number of records inserted, updated, and deleted.

Which triggers must you create or modify to accomplish this?

A. Post-Insert, Post-Update, Post-Delete, and On-Message

B. Post-Database-Commit and On-Message

C. On-Message only

D. Post-Commit and On-Message

E. When-Validate-Record and On-Message

Answer: A

Q49. An application uses a menu that contains a Check type menu item. You have programmatically obtained the menu item ID of the Check item and now you want to write code to toggle its checked/unchecked state. Which two built-ins can you use to accomplish this? (Choose two.)

A. FIND_MENU_ITEM

B. GET_ITEM_PROPERTY

C. FIND_ITEM

D. REPLACE_MENU

E. SET_ITEM_PROPERTY

F. GET_MENU_ITEM_PROPERTY

G. SET_MENU_ITEM_PROPERTY

Answer: FG

Q50. What type of message indicates a Forms message that cannot be suppressed?

A. a level 50 message

B. a message with a level greater than 25

C. a level 0 message

D. a message with a level less than 0

E. a message with a level greater than 50

F. a Working message

G. a level 25 message

H. a Busy message

Answer: B

About 1z0-141 Information: 1z0-141 Dumps

Certleader Dumps
Certleader is a company specialized on providing high quality IT exam materials and fully committed to assist our respected clients crack any IT certification tests on their 1st efforts.