Oracle 1Z0-141 Online Practice Questions and Exam Preparation

Oracle 1Z0-141 Online Questions & Answers

• Question 121:

  View the Exhibit.

  master-detail form displays Orders and Order Items. What can you tell about the run-time behavior of the form by looking at the exhibit, assuming that the master-detail triggers and relations have not been modified since they were created?

  

  A. Users will be unable to delete detail records if master records exist.
  B. Users will be unable to delete master records if detail records exist.
  C. If users delete a master record, its detail records will also be deleted.
  D. Users will be able to delete a master record even if detail records exist.
  E. If users delete all detail records, the master record will also be deleted.
  B. Users will be unable to delete master records if detail records exist.

• Question 122:

  The Warehouse.fmb module contains two data blocks. You want to display items from each data block on separate content canvases. You must ensure that both content canvases are visible together at run time.

  Which two statements about content canvases are correct? (Choose two.)

  A. A window cannot display more than one content canvas during a run time session.
  B. A content canvas can be associated with a window by setting the Window property of the canvas.
  C. Two or more content canvases can be displayed by associating each of them with a different window.
  D. A content canvas can be associated with a window by setting the Primary Canvas property of the window.
  E. A content canvas can be associated with two or more windows by setting the Primary Canvas property of the windows.
  F. Two or more content canvases can be displayed by setting their viewports to be smaller than the window with which they are to be associated.
  B. A content canvas can be associated with a window by setting the Window property of the canvas.
  C. Two or more content canvases can be displayed by associating each of them with a different window.

• Question 123:

  You need to restrict access to a form. Access must be limited to particular times of the day and to certain authorized users.

  You write a procedure (get_authorization) in the form that checks the username of the person logging on and validates the time of day. If the person is not authorized to use the form at that time, the following code is executed:

  ...

  MESSAGE

  ('You are not authorized to access the form at this time'); RAISE FORM_TRIGGER_FAILURE;

  What is the best trigger from which to call this procedure?

  A. Pre-Form at form level
  B. When-Validate-Item at form level
  C. When-New-Form-Instance at form level
  D. Pre-Block on the first enterable block
  E. When-Validate-Item on the first enterable item
  F. Pre-Text-Item on the first navigable text item in the first navigable block
  A. Pre-Form at form level

• Question 124:

  Which statement is true about built-ins that invoke one form from another?

  A. CALL_FORM cannot be issued while in Enter-Query mode.
  B. CALL_FORM does not issue a savepoint.
  C. NEW_FORM invokes the second form in a modal state so the user can navigate freely between the two running forms.
  D. NEW_FORM improves performance but consumes more memory because the first form is retained in memory and returning to it is more efficient than reloading it.
  E. OPEN_FORM invokes the second form in a modeless state and optionally within a different transaction scope.
  F. OPEN_FORM is the only way to invoke the second form in "query only" mode.
  E. OPEN_FORM invokes the second form in a modeless state and optionally within a different transaction scope.

• Question 125:

  How can you restrict a query on a block temporarily, so that the restriction is in effect only for the first query on the block after setting the property?

  A. Set the Where Clause block property at design time.
  B. Set the DEFAULT_WHERE block property programmatically.
  C. Set the ONETIME_WHERE block property programmatically.
  D. Set the Onetime Where Clause block property at design time.
  E. Set the Default Where clause for the block either at design time or programmatically.
  F. Set the Onetime Where clause for the block either at design time or programmatically.
  C. Set the ONETIME_WHERE block property programmatically.

• Question 126:

  There is a requirement to invoke the Orders form from the Customers form. Your colleagues offer some suggestions about which built-in to use and their reasons for the choice.

  Which suggestion names a built-in that will meet the requirement and offers a correct reason?

  A. CALL_FORM, because NEW_FORM is no longer valid for Web-deployed forms due to the extra network traffic that it causes
  B. CALL_FORM, because it can be issued in Enter-Query mode and can be constrained to be "query only"
  C. CALL_FORM, because the second form is invoked in a modeless state and it saves on memory resources
  D. NEW_FORM, because the second form is invoked in a modeless state and the user can navigate freely between the two running forms
  E. OPEN_FORM, because the second form is invoked in a modal state and there can be only one "Open form stack"
  F. OPEN_FORM, because it causes a savepoint to be issued and the current form is validated before invoking the second form.
  B. CALL_FORM, because it can be issued in Enter-Query mode and can be constrained to be "query only"

• Question 127:

  The Products.fmb module has one content canvas, which displays information about products sold by your company. You increase the canvas display area by creating an overlay canvas to enable product images to be displayed on request. At run time, however, the overlay canvas is never displayed; users complain that there is only a brief flash on their screen.

  How do you correct this problem?

  A. Ensure that the current item is not hidden by the overlay canvas.
  B. Call the built-in GET_VIEW_PROPERTY to set the canvas VISIBLE property to True.
  C. In the Layout Editor, choose View Stacked Views. Then select the overlay canvas in the Stacked Canvases dialog box.
  D. Change the stacking order of canvases under the Canvases node in the Object Navigator. Ensure that the overlay canvas is the first canvaslisted under this node.
  E. Change the stacking order of canvases under the Canvases node in the Object Navigator. Ensure that the overlay canvas is the last canvaslisted under this node.
  A. Ensure that the current item is not hidden by the overlay canvas.

• Question 128:

  The Products.fmb module has one content canvas, which displays information about products sold by your company. You want to increase the canvas display area by creating an overlay canvas to enable images of selected products to be displayed on request.

  How can you size the display area of the overlay canvas?

  A. Define the display area for a stacked canvas by using the built-in procedure SET_CANVAS_PROPERTY.
  B. Define the display area for a stacked canvas by using the built-in procedure SET_WINDOW_PROPERTY.
  C. Define the display area for a content canvas by using the built-in procedure SET_CANVAS_PROPERTY.
  D. Define the display area for a content canvas by using the built-in procedure SET_VIEW_PROPERTY.
  E. Define the display area for a stacked canvas by using the built-in procedure SET_VIEW_PROPERTY.
  E. Define the display area for a stacked canvas by using the built-in procedure SET_VIEW_PROPERTY.

• Question 129:

  Consider the following scenario:

  In a multiform application, the user started in FormA.

  1.

  From FormA, the user invoked FormB using CALL_FORM.

  2.

  From FormB, the user invoked FormC using OPEN_FORM.

  3.

  From FormC, the user invoked FormD using OPEN_FORM.

  4.

  From FormB, the user invoked FormE using CALL_FORM.

  There is an additional form in the application, called FormF. Which statement is true?

  A. FormF can be invoked from FormC using CALL_FORM.
  B. FormF can be invoked from FormA using OPEN_FORM.
  C. FormF can be invoked from FormD using CALL_FORM.
  D. FormF can be invoked from FormE using CALL_FORM.
  E. FormF can be invoked from FormB using OPEN_FORM.
  D. FormF can be invoked from FormE using CALL_FORM.

• Question 130:

  You are developing an Order Entry application. The Customers form calls the Orders form and passes the value of Customer_Id as a parameter by the same name, so that the orders for only that customer are displayed. Which three statements are true? (Choose three).

  A. You must create the parameter at design time in the Customers form.
  B. You must create the parameter at design time in the Orders form.
  C. You must create the parameter programmatically in the Customers form.
  D. You must create the parameter programmatically in the Orders form.
  E. You can programmatically refer to the parameter as :parameter.customer_id in the Customers form.
  F. You can programmatically refer to the parameter as :parameter.customer_id in the Orders form.
  B. You must create the parameter at design time in the Orders form.
  C. You must create the parameter programmatically in the Customers form.
  F. You can programmatically refer to the parameter as :parameter.customer_id in the Orders form.