Oracle Oracle Certifications 1Z0-151 Questions & Answers

• Question 11:

  View the Exhibit.

  

  You have just created a new object library as shown in the Exhibit. You want the tabs to have descriptive names.

  You cannot change the names of the default object library tabs, so you must create new tabs in order to have descriptive names.

  A. True

  B. False

  Correct Answer: B

• Question 12:

  Which symbol when used in an object's Property Palette, indicates an inherited property that has been changed?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 13:

  You have written a Forms application that your users log in to with their database login. Which Forms component is utilized first when a user runs the application?

  A. Forms Client (applet)

  B. Forms Runtime

  C. Forms Servlet

  D. Forms Listener Servlet

  Correct Answer: A

  Note: ORACLE APPLICATION SERVER FORMS SERVICES ARCHITECTURE The OracleAS Forms Services consists of three components: a Forms Client that is downloaded automatically to the end user's browser and cached, the Forms Listener Servlet, and the Forms Runtime - on the middle tier.

  Forms Client (Java Applet) When a user runs a Forms session, the Forms Client - a thin 100 percent Java Applet - dynamically downloads from the Oracle Application Server. This generic Java Applet provides the user interface for the associated Forms Runtime process on the middle tier, and handles user interaction and visual feedback such as that generated by navigating between items or checking a checkbox. The same Java applet is used for any Forms application, therefore it is downloaded only once and cached on the client and so is available for subsequent Forms applications

• Question 14:

  You have been assigned to maintain a Forms application that was designed by a developer who has left the company.

  The CV_Tools canvas contains several buttons. There is limited space on the canvas, but the first button is not quite wide enough to display its complete label. In the Layout Editor, you widen the button slightly and find that the width of all the buttons increases so that they now overlap each other.

  What could have caused this problem?

  A. The buttons inherit their properties from the same property class.

  B. The buttons were created by dragging them from an object group.

  C. The buttons were created by using a Smart Class.

  D. All other buttons were subclassed from the first button.

  E. All other buttons were copied from the first button.

  F. The first button was subclassed from another button.

  G. The first button was copied from another button.

  Correct Answer: D

  D (not F): With subclassing you can make an exact copy, and then alter the properties of some objects if desired. If you change the parent class, the changes also apply to the properties of the subclassed object that you have not altered. However, any properties that you override remain overridden. This provides a powerful object inheritance model.

  Incorrect answers:

  A: A property class is a named object that contains a list of properties and their settings. You can use

  property classes to increase productivity and improve network performance.

  Here are some of the uses of a property class:

  *

  It increases productivity by setting standard or frequently used values for common properties and

  associates them with several form builder objects.

  *

  It defines standard properties not just for one particular object but also for several at a time. This results

  in increased productivity, because it eliminates the time spent on setting identical properties for several

  objects.

  *

  It improves network performance by increasing the efficiency of message diffing.

  C: A SmartClass is a special member of an Object Library. It can be used to easily subclass existing

  objects in a form using the SmartClass option from the right mouse button popup menu. E, G: When you

  copy an object, a separate, unique version of that object is created in the target module. Any objects

  owned by the copied object also get copied. Changes made to a copied object in the source module do not

  affect the copied object in the target module.

• Question 15:

  Which statement is true about flexible code?

  A. It is designed for reuse.

  B. It typically includes hard-coded object names.

  C. It is more difficult to maintain.

  D. It is more difficult to write, so it decreases developer productivity.

  E. It is specific to a particular module.

  Correct Answer: A

• Question 16:

  View the Exhibit.

  

  You have defined the window, canvas, and text items shown in the Exhibit. What happens when click Run Form?

  A. The form runs with the cursor initially in TEXT_ITEM8.

  B. The form runs with the cursor initially in TEXT_ITEM9.

  C. The form does not compile until you move TEXT_ITEM8.

  D. The form does not compile until you move TEXT_ITEM10.

  Correct Answer: A

• Question 17:

  You have a form with a single multi-record block. During a session, a user performs an insert and clicks Save

  What is the behavior of the record being inserted violates a database constraint?

  A. The record is posted to the database but not committed. The form redisplays the record with an error message so that the user can correct the data. Navigation to another record cannot occur until the correct data is committed or the new record is deleted. If the user exits the form without correcting the entry, a database rollback is performed.

  B. The record is committed to the database. The form redisplays the record with an error message so that the user can correct the data. The user is unable to exit the form or move to another record until the correct data is committed of the new record is deleted.

  C. A database rollback is performed. The form redisplays the record with an error message so that the user can correct the entry. The user is able to navigate to another record or exit the form.

  D. A database rollback is performed. The form redisplays the record with an error message so that an correct the entry. Navigation to another record cannot occur until the correct data is committed or the record is deleted.

  E. The record is committed to the database. The form redisplays the record with a warning in case the user would like to correct the entry. The user is able to navigate to another record or exit the form.

  Correct Answer: A

• Question 18:

  You have just created radio buttons labeled Outstanding, Exceeds, Meets, and Does not Meet for the employee appraisal rating, but you accidentally created it on the Employee_Training canvas rather than on the Employee_Appraisal canvas. How can you move them to the appropriate canvas?

  A. Open the Layout Editor for both canvases; drag the radio buttons from Employee_Training canvas to the Employee_Appraisal canvas.

  B. Drag the radio button nodes from the Object Navigator to the Employee Appraisal canvas in the Layout Editor.

  C. Drag the radio group node from the Object Navigator to the Employee__Appraisal canvas in the Layout Editor.

  D. Set the Canvas property for the radio buttons to Employee_Appraisal

  E. Set the Canvas property for the radio group to Employee_Appraisal.

  F. You cannot move existing radio buttons to another canvas; you will need to delete them from the Employee_Training canvas and create new ones on the Employee_Appraisal canvas.

  Correct Answer: A

  Note: Example of radio group:

  Creating radio buttons

  We will now create radio buttons for the Sex item to give the user an option of selecting either Male or

  Female.28.

  *

  To do this, right click on the Sex

  item in the Layout Editor and go to itsProperty palette.

  *

  In the Property Palette, Set:- Item Type : Radio Group- Initial Value : M30.

  Once you return back to the Layout Editor, you have to insert radio buttons.Select Radio Button icon from the toolbox. Drop the radio button into the form.

  *

  A window will appear, prompting you to select the radio group you would liketo attach this radio button to. Select the radio group Sex .

• Question 19:

  Which type of variable must be declared before it is used in a trigger?

  A. PL/SQL variable

  B. Form item

  C. global variable

  D. system variable

  E. parameter

  Correct Answer: A

  PL/SQL is the language used in Forms triggers and program units.

  PL/SQL lets you declare variables and constants, then use them in SQL and procedural statements anywhere an expression can be used. You must declare a constant or variable before referencing it in any other statements.

  Variables can have any SQL datatype, such as CHAR, DATE, or NUMBER, or a PL/SQL-only datatype, such as BOOLEAN orPLS_INTEGER.

  Note:

  PL/SQL's data types correspond with SQL's column types, making it easy to interchange PL/SQL variables with data inside a table.

• Question 20:

  View the Exhibit.

  

  To test how the Orders application works with database triggers, you add to the Orders table the following

  database trigger that fires before the update of Customer_Id:

  BEGIN

  If :old.customer_id != : new.customer_id then

  RAISE_APPLICATION_ERROR (-20101, 'Database trigger says no!'); end if;

  END;

  You run the Orders form, change the customer ID, and click Save. You receive the error message "FRM40509: Oracle error: unable to UPDATE record." You select Help > Display Error, and the Database Error

  dialog box that is shown in the Exhibit appears.

  Which code would you put in your Form-level On-Error trigger to display the ORA- error message instead

  of the FRM- error message?

  A. IF ERROR_CODE = 40509 THEN MESSSAGE (DBMS_ERROR_TEXT); END IF

  B. IF ERROR_CODE = 40509 THEN MESSSAGE (SQLERRM); END IF;

  C. IF ERROR_CODE = 06512 THEN MESSSAGE(DBMS_ERROR_TEXT); END IF;

  D. IF ERROR_CODE = 06512 THEN MESSSAGE (SQLERRM); END IF;

  E. IF ERROR-CODE = 20101 THEN MESSSAGE (DBMS_ERROR_TEXT); END IF;

  F. IF ERROR_CODE = 20101 THEN MESSSAGE(SQLERRM); END IF;

  Correct Answer: F

  The error code raised by your code is 20101.

  The SQLERRM function returns the error message associated with the most recently raised error

  exception.

  Note: The RAISE_APPLICATION_ERROR procedure lets you issue user-defined ORA-n error messages

  from stored subprograms. That way, you can report errors to your application and avoid returning

  unhandled exceptions.

  To invoke RAISE_APPLICATION_ERROR, use the following syntax:

  raise_application_error(

  error_number, message[, {TRUE | FALSE}]);

  where error_number is a negative integer in the range -20000..-20999 and message is a character string

  up to 2048 bytes long. If the optional third parameter is TRUE, the error is placed on the stack of previous

  errors. If the parameter is FALSE (the default), the error replaces all previous errors.