Home      Tests New!      Polls      Take a Quiz     Make a Quiz     Login     Contact QuizMoz Go to Home Page  
   
  Find a quiz.
  Example: Harry Potter Quiz


Create a Test
Make a Trivia Quiz
Make a Quiz about Yourself
Make Free Personality Test
Create a Survey


Now you can Read Books Online Free at ReadCentral.com









 

Featured Quizzes
 Love Compatibility Test
 English Language Test
 Does He Love You Quiz
 Business Phone Etiquette Quiz
 Impossible Quiz
 Personality Quiz
 CAT Preparation Mock Test
 Harry Potter Quizzes
 Keira Knightley Quiz
 Rage Against The Machines Quiz
 FIFA World Cup
 Are you in Love Quiz
 Skeletal System Quiz
 Love Personality Quiz
 Harry Potter Personality Quizzes



 



      Home > Quizzes and Fun Tests > Oracle OCP Practice Tests > Oracle OCP Practice Test - Oracle 9i Form OCP II

 Follow QuizMoz on Twitter  Oracle OCP Practice Test - Oracle 9i Form OCP II

Welcome to the QuizMoz Oracle OCP Practice Test - Oracle 9i Form OCP II. QuizMoz offers one of the Internet's largest collection of quizzes for you to tease your brain and pit your wits against the experienced QuizMoz quiz masters. Go ahead and find out what you know about yourself and the world around you. Best of luck!!

Coverage
:
  • Forms Developer Environment
  • Modes of Operation
  • Query/Where Dialog Box
  • Data blocks
  • Layout Wizard
  • Modifying Layout
  • Reentrant Mode
  • Master-Detail Relationship
  • Control Block
  • Item Properties
  • Input Items
  • Combo Box
  • Radio Group
  • Navigation Trap
  • Transaction Processing
  • Check Box
  • List Items
  • Visual Attribute
  • LOVs
  • Non Input Items
  • Canvas
  • Windows
  • Trigger Execution Hierarchy
  • 1. JOHN is running a multiple-form application. The Customers Form invoked the Orders Form. When the Orders Form launches, it displays orders for only the active customer from the Customers form. Forms exchange data with the GLOBAL.CUSTOMER_ID variable. The Orders Form should be restricted to the orders for the current customer only when the query is issued for the first time after invoking the Orders form. Which built-in helps him do this by setting the ONETIME_WHERE property to refer dynamically to the GLOBAL.CUSTOMER_ID?
    a.SET_APPLICATION_PROPERTY
    b.SET_FORM_PROPERTY
    c.SET_BLOCK_PROPERTY
    d.SET_RECORD_PROPERTY
     
    2. An application is being created on a Windows PC. A form needs to be tested. How would an OC4J instance be started on the PC?  
    a.From the Forms Builder menu
    b.From the Windows Start menu
    c.By executing a batch file that is included with Oracle9iDS
    d.From the test form that is included with Oracle9iDS
    e.From the HTML front end (runform.htm) that is included with Oracle9iDS
     
    3. The DBA has been informed that two new columns have been added to the ORDERS table. The blocks in the Order Entry form were created manually. How can he use a wizard to modify the Orders block to include items that corresponds to these columns?
    a.He cannot use wizards to add a new item to add data block that was created manually
    b.Select the last item in the Orders block, then invoke the Layout Wizard from the menu
    c.Select the Order Block in the Object Navigator, then invoke the Data Block Wizard from the menu
    d.Select the Data Block node in the Object Navigator, then invoke the Data Block Wizard from the menu
     
    4. In the Human Resources form , the prompt, heights, and widths of the Department Id, Manager Id, and Location Id fields in the Department data block have to be modified. What must be selected prior to invoking the Layout Wizard in Re-Entrant mode to modify these item properties?    
    a.Frame consisting of the Employee_id, Employee_Name  ,Employee_Address Items.  
    b.Canvas
    c.Frame consisting of the DEPARTMENT_ID, MANAGER_ID, and LOCATION_ID items.
    d.The Departments block. The DEPARTMENT_ID, MANAGER_ID, and LOCATION_ID items
    All of the above
     
    5. A developer wants to change an existing application which requires to change the source table of the block from Order items to Products table to provide information related to the various products sold by the company during the year 2004-2005.How this change can be implemented?
    a.Select the Frame consisting of the items of the  Order Items block. Click on the Tools menu button and click the Layout Wizard
    b.Multi Select the Items of the Orders Items table then right-click and click on the Data Block wizard
    c.The table which is being associated with a Database Data block cannot be changed once it has been created
     
    6. What is the use of creating a control block in a Forms module?
    a.To control relationship between a master block and its detail block
    b.To control the way additional forms are opened and to track the call stack in Multiform Application
    c.To control navigation within the form so that users cannot randomly navigate to any item
    d.To place various control items (such as buttons) on a single block that is not related to a table in the database
    e.To control all items in other blocks that are not base table items
     
    7. A number column called STATUS was added to the table. The Order Entry form has to be updated to display the additional data. The Layout Editor was opened for the canvas on which items from the Customers, Orders, and Order_Items blocks are displayed. The text item tool was used to create a new text item on the canvas, then its Property Palette was opened and set the Name property to STATUS and the Column Name property to Status. When the form was run for testing, the  error 'FRM 40505 ORACLE error unable to perform query' appeared. What could be the cause of this error?
    a.The default value was not changed for the Data Type property of the Status text item
    b.The WHERE clause of the Orders block was not modified to include the ORDER_STATUS column
    c.The Orders block was not selected from the block poplist in the Layout Editor prior to creating the item
    d.The Column Name was not defined in uppercase so that the column value can be retrieved from the database
    e.The default value was not changed for the Database Item property of the Status text item
     
    8. Which of the following actions allow the user to view the display item at run time?
    a.Define MAIN_WIN as a modal window and display it with a horizontal scroll bar
    b.Define MAIN_WIN as a modeless window and display it with a horizontal scroll bar
    c.Define MAIN_WIN as a dialog window and display it with a horizontal scroll bar
    d.Define MAIN_WIN as a document window and display it with a Vertical Scroll bar
    e.Define MAIN_WIN as a modeless window and display it with a Vertical Scroll bar
     
    9. A calculated item has to be created in the Control block of the Resource Management form. This item should contain the total of employee salaries for employees in a particular department. Which statement is true about how to create the calculated item?
    a.It can be created by first creating a text item and then changing the item type
    b.It can be created in the Layout Editor using a special tool that creates a calculated item
    c.It can be created by first creating a display item and then setting appropriate properties in its Calculation property group
    d.It can be created in the Layout Editor by selecting the Salary item of the Employees block, selecting the Control block from the block list, clicking the Text Item tool, and drawing a text item on the canvas to automatically calculate a sum of the selected Salary item
     
    10. The user must be able to invoke a list of values for valid sales representative in the Orders form. To facilitate this, a button was created and positioned next to the Sales Rep ID field The text item has these properties set:

    - Required: Yes
    - List of Values: SALES_REP_LOV
    - Validate from List: No
    The button has these properties set:
    - Keyboard Navigable: Yes
    -Mouse Navigate     :Yes
    - Iconic            :Yes
    - Icon Filename     :list .ico

    An appropriate LOV (called SALES_REP_LOV) was created and associated with the text item. An icon file (list.gif) exists in the appropriate directory. All other properties are left at their defaults. A When-Button-Pressed trigger was written at the item level with this code:
    LIST_VALUES;

    To test the form, it was attempted to enter a new record. What is the run-time behavior of the form?
    a.The form doesn't compile and therefore cannot be tested
    b.The icon is not displayed on the button. When the Sales Rep Id field is clicked and then the button is clicked, the LOV is invoked
    c.The icon is displayed on the button. When the Sales Rep Id field is clicked and then the button is clicked, the LOV is not invoked and an error is reported
    d.The icon is not displayed on the button When the Sales Rep Id field is clicked and then the button is clicked, the LOV is not invoked and an error is reported
     
    11. A STATE column is added to the CUSTOMERS table and the DBA has been asked to add a corresponding State item to the Customers block of the Orders form. He wants to make it easier for order entry clerks to enter the correct state abbreviation. Most customers are located in five southeastern states, although on very rare occasions there will be customers from outside that area. He decided to implement a list item with five values for the State item and allow clerks to enter the state abbreviation directly for those customers outside the region. Which style of list item should he create for the State item?
    a.A poplist
    b.A T-list
    c.A combo box
    d.There is no style of list item that allows users to enter values that are not on the list
     
    12. Three possible credit ratings are assigned to customers: Poor, Good, and Excellent (represented numerically by 1, 2, and 3). A RATING column was added to the CUSTOMERS table and the DBA has to add an item to his form so that credit ratings can be recorded.
    To restrict data entry clerks to one of these three values, he decided to create a radio group for the Rating item. With the item node of the Customers block selected in the Object Navigator, he clicked Create. He then opened the Property Palette for the new item and set properties as follows:

    Name: RATING
    Item Type: Radio Group
    Data Type: Number
    Column Name: Rating
    Canvas: CUSTOMER_CV

    He opened the CUSTOMER_CV canvas in the Layout Editor, but the Rating item does not appear. How can he get the Rating item to appear on the canvas?
    a.Create a Radio Button for the radio group
    b.Set the Visible property of the Rating item to Yes
    c.Delete the radio group and create it in the Layout Editor because a radio group that is created in the Object Navigator will not appear on a canvas
    d.Change the width of the Rating item because the default width of a radio group is 0, so it does not appear on the canvas
     
    13. A form was written in which there were two text items (FIELD 1 and FIELD2) and a button (BTN1) arranged in the following sequence:

    FIELD1, BTN1, FIELD2

    Which of the following conditions will combine to produce a Navigation Trap when the focus is in FIELD1 and the user presses the [Next Item] key?
    a.FIELD1 has a Post-Text-Item trigger that fails
    b.FIELD1 has a Pre-Text-Item trigger that fails
    c.FIELD1 has a When-New-Item-Instance trigger that fails //no effect
    d.FIELD2 has a Post-Text-Item trigger that fails
    e.FIELD2 has a Pre-Text-Item trigger that fails
    f.FIELD2 has a When-New-Item-Instance trigger that fails //no effect
    g.The Keyboard Navigable property of BTN1 is set to No
    h.The Keyboard Navigable property of BTN1 is set to Yes
     
    14. In the Orders Form five LOVs were defined and one button was created to be used to display any of the LOVs. The button is enabled only when the user navigates through a field with an attached LOV. If the user supplies only a part of the required input data, LOVs use that input as search criteria to automatically reduce the LOV Contents. If the LOVs hold only one value that can possibly match user-supplied input, the LOVs auto-complete the input field and are not displayed. Which built-in properties should be used to display the LOVs?
    a.Use the List_Values(RESTRICT) built-in, and set the Mouse Navigate property value to NO
    b.Use the List_Values(RESTRICT) built-in, and set the Mouse Navigate property value to YES
    c.Use the List_Values(NO_RESTRICT) built-in, and set the Mouse Navigate property value to NO
    d.Use the List_Values(NO_RESTRICT) built-in, and set the Mouse Navigate property value to YES
     
    15. A LOV was created based upon a three-column Record Group called CUST, which was created at design time. Column names are ID,DESC,DATE. At run time, the user sometimes requires the LOV to be populated from the PROD Record Group. Which built-ins will enable the creation of the PROD Record Group and repopulate the LOV?
    a.RETRIEVE_LIST(lov_id, 'PROD');
    b.POPULATE_LIST(lov_id, 'PROD');
    c.SET_LOV_PROPERTY(lov_id, GROUP_NAME, 'PROD');
    d.CREATE_GROUP_FROM_QUERY ('PROD', 'SELECT P_id', || 'date_sold as Date, Name as Desc' || 'from products');
    e.CREATE_GROUP_FROM_QUERY ('PROD', 'SELECT P_id as ID', || 'Name as Desc, date_sold as Date' || 'from products');
    f.CREATE_GROUP_FROM_QUERY ('PROD', 'SELECT rownum as index, P_id as ID,' || 'Name as Desc, date_sold as Date' || 'from products ');
     
    16. JOHN is writing a Forms application, and he plans to include several JavaBeans. What should he do to facilitate the communication between Forms and the JavaBeans?
    a.Write Java wrapper classes to integrate the JavaBean into Forms
    b.Use the FBEAN PL/SQL Package and its built-ins to register and invoke the JavaBeans
    c.Add a special layer of Java code to register the properties and methods of the JavaBeans
    d.He does not need to use any built-in package or write any code to integrate JavaBeans into forms
     
    17. MARY is writing a Forms application, and plans to include a Hierarchical Tree Item. What should she do to facilitate this Functionality?
    a.Write Java wrapper classes to integrate the Hierarchical Tree item  into Forms
    b.Add a special layer of Java code to register the properties and methods of the Hierarchical Tree Item
    c.Use the FTree PL/SQL Package and its built-ins to register and invoke the Hierarchical Tree Item
     
    18. DANNY is 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, DANNY declares a variable called rg_emps that is of the RECORD GROUP data type. He will use this record group to populate the tree. He uses the following code to create the record group:

    rg_emps := Create_Group_Form_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');

    He then programmatically populates the record group, and then populates the tree with the record group. He runs the form to test it. Will the tree initially appear as shown? If not, why?
    a.Yes, the tree will appear as shown
    b.No. The first element selected in the select statement should be 4 because he wanted four levels of the tree to be displayed
    c.No. He should eliminate the last element selected in the select statement, because he does not want to display the employees ID
    d.No, The 'connect by' statement should be 'connect by prior manager_id = employee_id'
     
    19. A user has requested a change to the Product Management .fmb module. The form has two windows, Orders_Win and Products_Win. Orders_Win is always visible to the user. However, Products_Win is only occasionally opened. The user complains that once Products_Win is open, it is not possible to make the window invisible. The user can navigate between the open windows. The code should not be written to close Products_Win explicitly. What changes should be made to the Summit form?
    a.Define Products_Win as a modal window, set the Hide on Exit property to No
    b.Define Products_Win as a modeless window, set the Hide on Exit property to No
    c.Define Products_Win as a modeless window, set the Hide on Exit property to Yes
    d.Define Products_Win as a modeless window, set the Close Allowed property to Yes
     
    20. The Product Line data block is defined in the Order Management .fmb module.
    Product Line items are displayed in the default window at run time. In a second window called Buttons a set of icon buttons is displayed. At run time, the user must be able to freely navigate between the two windows.
    Which of the following statements identifies the types of windows to be defined?
    a.Both windows must be defined as dialog and modal
    b.Both windows must be defined as document and modeless
    c.Both windows must be defined as document and modal
    d.The default window must be defined as modeless and the Buttonswindow must be modal
     
    21. JOHN is building the Animal.fmb module, and he defined a multi record data block based on the Animal table. The data block is called Animal. He specified a Tabular layout style for the Animal items. When the window is at its maximum size, only some of the items can be viewed in the window. To view all items together, he should enable users to scroll horizontally through the Animal  items; however, the Animal_Id and Animal_Name items should always be visible. Which combination of canvas types is most appropriate to display the Animal items together?
    a.Content canvas and an overlay Tab canvas
    b.Tab canvas and an overlay stacked canvas
    c.Vertical Toolbar canvas and a Tab canvas
    d.Content canvas and an overlay Stacked canvas
     
    22. The Child_Birth .fmb module has one content canvas, which displays information about the Number of Births Taken place during the year 2004-2005. TOM wants to increase the canvas display area by creating an overlay canvas to enable images of selected the child to be displayed on request. How can he 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
     
    23. The Geographical .fmb module contains the City data block. City items have to be displayed at run time. Which are the valid considerations that affect the design?
    a.A City item can be associated directly with a window.
    b.A City item cannot be associated directly with a window
    c.A City item can be assigned to a content canvas by setting the item Canvas property
    d.A City item can be assigned to a canvas by setting the Data Block Scroll Bar Canvas property
    e.A City item is automatically assigned to the null_canvas. It can be assigned to a window by setting the item Rendered property
    f.A City item is automatically assigned to the null_canvas. It can be assigned to a window by setting the item Synchronize with item property
     
    Think you know more about this quiz!

     
    Please enter your Name and what you would like to tell everyone about Oracle OCP Practice Test - Oracle 9i Form OCP II
     Name:
    Think you know more about Oracle OCP Practice Test - Oracle 9i Form OCP II and would like others to know too? Whether its a great fact, a joke, a personal experience or an interesting anecdote, please share it with all the human beings on planet earth. Your contribution will help keep QuizMoz a free site for all.

       (Optional)
     (average submission size - 5 to 10 lines)


    Know the Latest News about Oracle OCP Practice Test - Oracle 9i Form OCP II!

    Follow QuizMoz on Twitter


    What others think about Oracle OCP Practice Test - Oracle 9i Form OCP II
    By: Fiz on Oct 10, 2010
      This is best place to practice
      

    Quizzes for this month are sponsored by www.ExpertRating.com


     

    Most Popular Quizzes
     Be A MakeUp Artist Course
     Big Brother
     FIFA
     Soccer WAGs Quizzes
     NBA 2010 Quiz
     Science Quiz for Kids
     Medical Terminology Quiz
     Career Quiz for Kids
     Home And Away Quiz
     Harry Potter Quiz
     Harry Potter and the Deathly Hallows
     US History Quiz
     Am I Pregnant Quiz
     Dating Etiquette Quiz
     Email Etiquette Quiz





     
    Home     About Us      Advertise     Terms of Service     Privacy Policy     Contact QuizMoz    FAQ     SiteMap
    Copyright © 2007.www.quizmoz.com. All rights are reserved.