Monday, January 28, 2013

trigger, query, Forms, Validation, module , array, Lov, Question and Answer with Oracle


Oracle, SQL, Interview Questions, Question Paper, Interview Questions,

1. You open a single property sheet to display properties for your 
      DEPARTMENT data block and DEPARTMENT canvas simultaneously. Which Property
      Palette display mode is likely to show more properties?
      A . Intersection
      B*. Union
      Explanation:
      Union
      The Intersection display mode shows only the properties that multiple
      selected objects have in common, while the Union display mode shows all
      properties for all selected objects, whether the objects share the
      properties in common or not.

      2. What does it mean when the Property Palette displays ***** as a 
      property's value?
      A*. Two or more objects are selected, and their values for that property
      are not the same.
      B . The value "*****" will be inserted into the field automatically.
      C . You cannot update that property for the object you have selected.
      D . The property is not applicable for the object you have selected.
      Explanation:
      Two or more objects are selected, and their values for that property are
      not the same
      Because the Property Palette cannot display more than one value per
      property, the only way it can deal with multiple objects is to display
      something special when those objects' values are different. The special
      display is *****.

      3. What happens if you select multiple objects, open the Property Palette, 
      and change a property's value?
      A . The changed value displays as *****.
      B . The Property Palette shows each object's old and new values for that
      property.
      C*. The change is applied to all selected objects.
      D . You cannot change a property for multiple objects at one time.
      Explanation:
      The change is applied to all selected objects

      4. Which data block property would you consider changing if your records 
      include LONG items that are not likely to be edited?
      A*. Update Changed Columns Only
      B . Update Allowed
      C . Query Allowed
      D . DML Array Size
      Explanation:
      Update Changed Columns Only
      If your records include LONG items that are not likely to be edited, this
      data block property can improve application performance by keeping the
      application from sending the voluminous LONG data back to the server
      during an update command.

      5. What does the Property Palette toolbar field labeled Find do?
      A . Locates other objects containing the same property as the one you
      currently have selected
      B . Allows you to search-and-replace a given property value with a
      different value
      C . Locates Form Builder files on your hard disk
      D*. Forces the Palette to place its focus on the first property matching
      the characters you type
      Explanation:
      Forces the Palette to place its focus on the first property matching the
      characters you type
      The Property Palette toolbar field labeled Find makes the Property Palette
      quickly jump to specific properties. If the group containing the matching
      property is closed, the Find field will even open it up for you.

      6. What would be the result of completely deleting a data block from the 
      Object Navigator?
      A . The data blocks and components are deleted but can be retrieved using
      the Edit | Undo command.
      B . The data blocks and components are irreversibly deleted, and all
      components from the data block are removed from any canvas that contained
      them, including the data block's frame and boilerplate title text.
      C*. The data blocks and components are irreversibly deleted, and all
      components from the data block are removed from any canvas that contained
      them, but the data block's frame and boilerplate title text will stay on
      the canvas.
      D . The data blocks and components are irreversibly deleted, and all
      components from the data block stay on the canvas and must be deleted
      manually.
      Explanation:
      The data blocks and components are irreversibly deleted, all components from the data block are removed from any canvas that contained them, but the data block's frame and boilerplate title text will stay on the canvas.

      7. What does the Property Palette context bar do?
      A . Nothing
B*. Identifies which object's properties are currently being displayed by
      the Property Palette
      C . Identifies which program you are in when you open the Property Palette
      D . Provides help instructions based on your location in the Property
      Palette
      Explanation:
      Identifies which object's properties are currently being displayed by the
      Property Palette.

      8. Which of the following occur if you copy multiple properties from one 
      object and paste them into another?
      A*. No Answer is Correct
      B . Properties not relevant to the destination object will be added to
      that object.
      C . Properties with blank properties will be pasted.
      D . It is not possible to copy multiple properties at one time.
      E . If the destination is a different type of object than the source, the
      destination object will be changed to the same type of object as the
      source.
      Explanation:
      No Answer is Correct
      The Property Palette can copy and paste individual or multiple properties.
      When copying multiple properties, the Palette pastes only the properties
      for which an actual value is shown, and only the properties that are
      relevant to the object receiving the pasted properties.

      9. You created an LOV for stock items and included a Quantity Currently In 
      Stock column in the LOV. How can you ensure that the user sees accurate
      "in stock" numbers each time the LOV is invoked?
      A . There is no way to ensure this.
      B . Programmatically requery all tables in the application when the user
      opens that canvas.
      C*. Enable the LOV's Automatic Refresh property.
      D . Enable the LOV's Automatic Select property.
      Explanation:
      Enable the LOV's Automatic Refresh property
      The Automatic Refresh property determines whether the LOV's underlying
      query executes every time the LOV is invoked, or only the first time it is
      invoked. Setting the property to Yes configures it to requery every time.

      10. You have created a SALES_TICKET form for a point-of-sale application. 
      You now want to modify the Transaction_Date_Time item in the form so it is
      automatically populated with the current date and time each time a new
      record is created. How can you accomplish this?
      A . Set the Default Value property to SYSDATE.
      B . Set the Initial Value property to SYSDATE.
      C . Set the Default Value property to $$DATETIME$$.
      D*. Set the Initial Value property to $$DATETIME$$.
      Explanation:
      Set the Initial Value property to $$DATETIME$$.
      The is no Item property called Default Value, and while SYSDATE is a valid
      parameter in a SQL query, it will not work in the Initial Value property;
      you must use $$DATETIME$$.

      11. What does freezing the Property Palette do?
      A . Enables you to change a property in multiple objects at one time
      B . When multiple objects are selected, shows only those properties that
      all selected objects share in common
C*. Forces the Palette to continue displaying properties for the currently
      selected object(s), regardless of what object(s) you select from that
      point on
      D . Opens a second Palette for comparing multiple objects' properties
      Explanation:
      Forces the Palette to continue displaying properties for the currently
      selected object(s), regardless of what object(s) you select from that
      point on

      12. What is the best way to ensure that an item cannot accept query 
      criteria?
      A . Set the item's Query Length property to 0.
      B . Set the item's Queryable property to No.
      C*. Set the item's Query Allowed property to No.
      D . Set the item's Disable Query property to Yes.
      Explanation:
      Set the item's Query Allowed property to No
      There are no properties named Disable Query or Queryable. Setting the
      Query Length property to 0 simply tells Oracle Forms 6i to use the item's
      length as the maximum query length.

      13. How many characters would you need to type in an LOV to select the 
      WHEN-KEY-UP item from a list containing WHEN-BUTTON-PRESSED,
      WHEN-KEY-DOWN, and WHEN-KEY-UP, assuming they are the only items in the
      list and the LOV's properties are set to automatically display the LOV and
      automatically enter the value once a row is selected?
      A . 3 characters
      B . 1 character
      C*. 2 characters
      D . 10 characters
      Explanation:
      2 characters
      Because all three choices begin with "WHEN-," the LOV only cares about the
      first differentiating character, which is the "K" that identifies the KEY
      group. The next character needed is the "D" to select DOWN, after which
      the row's key value will automatically be entered into the text item.

      14. What is the definition of the term "text item"?
      A . Any control on your form that allows the user to view and edit text,
      numbers, or dates
      B . Any control on your form that allows the user to view and edit text
      C . Any control on your form that allows the user to view and edit text or
      numbers
      D . The label preceding a field on a form
      E*. Any control on your form that allows the user to view and edit text,
      numbers, dates, or long data
      Explanation:
      Any control on your form that allows the user to view and edit text,
      numbers, dates, or long data

      15. You have created an LOV for a text item on your canvas, and you would 
      like the LOV to appear automatically each time the user enters that text
      item. What is required to make that happen?
      A . Set the Automatic Select property in the LOV Property Palette to Yes.
      B*. Set the Automatic Display property in the LOV Property Palette to Yes.
      C . Set the Automatic Refresh property in the text item Property Palette
      to Yes.
      D . Set the Automatic Refresh property in the LOV Property Palette to Yes.
      E . Set the Automatic Display property in the text item Property Palette
      to Yes.
      Explanation:
      Set the Automatic Display property in the LOV Property Palette to Yes.
      No text item property would effect this change. Of the LOV properties
      listed, Automatic Refresh determines whether the LOV's contents are
      requeried each time it is opened, and Automatic Select specifies whether
      the selected LOV row is placed into the specified text item without the
      user having to double-click on the row or click the OK button.


      16. Which of the following actions can a user do with a display item?
      A . Delete existing database values.
      B . Update existing database values.
      C*. View existing database values.
      D . Insert new database values.
      E . All Answers are Correct
      Explanation:
      View existing database values
      A display item shows data but does not allow the user to change it. In
      essence, it is a read-only field.

      17. To which of the following items does a control block directly 
      correspond?
      A . All Answers are Correct
      B . Database
      C*. No answer is correct
      D . Table
      E . Column
      Explanation:
      No answer is correct
      A control block is not associated with a database object. Instead, it
      contains either controls (such as buttons), or a group of items with
      single values (such as calculated subtotals).

18. When a control block is created, what items does it contain?
      A . None, because, you cannot put items in a control block.
      B . Text items for all columns in the related database table.
      C*. None. You must manually create any items that will go into a control
      block.
      Explanation:
      None. You must manually create any items that will go into a control
block.
      By definition, a control block is not related to a database table. And you
      can put items into a control block-that is what it's for. But you must do
      it manually after the block is created.

      19. What is the definition of an input item?
      A . A form object through which the user can view data
      B . A dialog box
      C . A graphics element affecting how a chart will look
      D*. A form object through which the user can enter and change data
      E . A form object through which the program can enter and change data
      Explanation:
      A form object through which the user can enter and change data
      Input items are the basis of forms-they enable a user to add or edit data.
      A dialog box may contain input items, but the dialog itself is a window,
      not an input item.

      20. Users of your application have requested that they be able to see 
      STOCK and CUSTOMER canvases on the screen simultaneously. You add a second
      window to the application. How can you make the CUSTOMER canvas use the
      second window?
      A . Change the window's Primary Canvas property.
      B . Change the canvas's Visual Attributes group.
      C*. Change the canvas's Window property.
      D . It is not possible to change a canvas's display window.
      Explanation:
      Change the canvas's Window property
      A canvas's Window property determines which window the canvas is visible
      in. The Visual Attributes Group has no window selection properties, and a
      window's Primary Canvas property specifies the primary canvas for a window
      that displays multiple canvases.

      21. Which check box property controls the text that displays next to the 
      check box?
      A*. Label
      B . Text
      C . Name
      D . A check box's text is fixed and cannot be changed.
      Explanation:
      Label
      Remember that both Prompt and Label can place text next to a radio button.
   
22. Which type of canvas is best suited for displaying tutorial text on 
      the same canvas as the form about which the user is being taught?
      A . Tab
      B . Viewport
      C*. Stacked
      D . Toolbar
      E . Content
      Explanation:
      Stacked
      The requirement that the tutorial text be visible on the same form limits
      the choices to either stacked or tab. A tab canvas might be useful for a
      multipage tutorial, but the requirements did not state the need for
      multiple pages, so a simple stacked canvas will fulfill the requirement.

      23. You are working with an existing radio group in the Layout Editor and 
      try to add a radio button to the group. The Layout Editor responds by:
      A . Displaying a warning message, and then returning you to the Layout
      Editor
      B . Offering to create a check box instead, since a radio button group
      already exists
      C*. Presenting a dialog box giving you the chance to select a radio group
      for the new radio button, or create a new radio group for it
      Explanation:
      Presenting a dialog box giving you the chance to select a radio group for
      the new radio button, or create a new radio group for it
      The Layout Editor is willing to add buttons to an existing radio group. It
      just needs to know which group will get the new button, or if a completely
      new group is what you desire.

      24. Your Employee form includes a SALARY text item. You want to ensure 
      that standard users cannot input or change a salary value, but you want
      the value to look exactly like a regular field. What is the best way to do
      this?
A . Set the item's Enabled property to No, and its Update Allowed property
      to No.
      B*. Set the item's Insert Allowed property to No, and its Update Allowed
      property to No.
      C . Set the item's Enabled property to No.
      D . It is not possible for an unchangeable item to look like a changeable
      item.
      Explanation:
      Set the item's Insert Allowed property to No, and its Update Allowed
      property to No
      Changing an item's Enabled property to No causes its contents to display
      with light gray characters instead of black. Therefore, this is the only
      valid choice.

      25. What type of canvas can easily eliminate the need for a menu in your 
      application?
      A*. Toolbar
      B . Content
      C . Tab
      D . Stacked
      Explanation:
      Toolbar
      A toolbar canvas's sole purpose is holding buttons that initiate actions.
      The buttons can replace every menu action your users would need to take.

      26. The DEPARTMENT table in your database has been augmented with a BUDGET 
      column. You want to add BUDGET as an item on your Department form, but the
      item should be a read-only text box so users cannot change it. The best
      way to do this is:
      A . In the Layout Editor, create a display item and set its Insert Allowed property to No, its Update Allowed property to No, and its Database Item property to No.
      B . In the Data Block Wizard, move the BUDGET column into the Available
      Items area. Change the new data block item's Insert Allowed and Update
      Allowed properties to No. Proceed to the Layout Editor and add BUDGET as a
      text item.
      C . In the Data Block Wizard, move the BUDGET column into the Available
      Items are C:
      Proceed to the Layout Editor and add BUDGET as a text item, and change the
      item's Insert Allowed and Update Allowed properties to No.
      D*. In the Layout Editor, create a display item and set its Column Name
      property to BUDGET.
      Explanation:
      In the Layout Editor, create a display item and set its Column Name
      property to BUDGET.
      Setting an item's Database Item property to No keeps it from retrieving
      database data, eliminates two answers, but it creates a normal-looking
      text box that actually allows the user to type in data; it isn't until the
      user tries to save their work that the data block's Insert Allowed and
      Update Allowed properties halt the action. This is not optimal design. The
      third incorrect answer creates an application in which the field's data
      cannot be changed, but the user can still place focus on the field, which
      is also not optimal.

      27. You have created a form that contains two canvases, ten database 
      items, and four buttons. The items have all been placed into a group, and
      the buttons have been placed into a separate group. What happens when you
      click one of the buttons in the Layout Editor?
      A*. The group of buttons is selected.
      B . Nothing is selected.
      C . All groups are selected
      D . The button is selected.
      E . All items on the button's canvas are selected
      Explanation:
      The group of buttons is selected.
      The primary reason for groups is to ensure that when any item in the group
      is selected, all items are selected with it.

      28. Which canvas type is most dissimilar to the others?
      A . Content
      B . Stacked
      C . Tab
      D*. Toolbar
      Explanation:
      Toolbar
      Content, stacked, and tab canvases are all intended to display database
      data. The toolbar canvas type is not; it is intended to display buttons
      that work in concert with the items on the other three canvas types.

      29. What is the primary difference between tab and stacked canvases?
      A . A stacked canvas can contain push buttons.
      B . A stacked canvas obscures what is beneath it.
      C*. A tab canvas can contain multiple pages.
      D . A tab canvas looks much cooler.
      Explanation:
      A tab canvas can contain multiple pages.
      The essence of a tab canvas is the fact that it consists of multiple pages
      of data, each page overlaying the others when it is selected by the user
      or developer. It is not possible to get this functionality from a single
      stacked canvas.

      30. What trigger would you use to execute code each time a user modifies 
      the value of a check box?
      A . ON-NEW-CHECKBOX-INSTANCE
      B . WHEN-CHECKBOX-UNCHECKED
      C . WHEN-CHECKBOX-CLICKED
      D . WHEN-CHECKBOX-CHECKED
      E*. WHEN-CHECKBOX-CHANGED
      Explanation:
      WHEN-CHECKBOX-CHANGED

      31. You would like to create a trigger that fires each time a window is 
      closed by the user. You will most likely place the trigger at which of the
      following levels:
      A . Canvas level
      B . Window level
      C . Data block level
      D . Item level
      E*. Form level
      Explanation:
      Form level
      Windows do not have triggers. Placing the WHEN-WINDOW-CLOSED trigger at
      the Form level allows it to fire when any window in the module is closed.

      32. What trigger would fire each time a new record is created?
      A . ON-NEW-RECORD
      B*. WHEN-NEW-RECORD-INSTANCE
      C . WHEN-VALIDATE-RECORD
      D . WHEN-DATABASE-RECORD
      Explanation:
      WHEN-NEW-RECORD-INSTANCE
      ON-NEW-RECORD is not a valid trigger name. Choices WHEN-VALIDATE-RECORD
      and WHEN-DATABASE-RECORD fire at other times. Review the section
      "Supplementing the Functionality of Input Items" if you need a reminder on
      this topic.

      33. What do you need to do to within Form Builder to run a form module in 
      debug mode?
      A . Enable Debug Messages and then run your form. The Debugger will appear
      automatically.
      B*. Enable the Debug Mode button, run the form, and the Debugger displays
      automatically.
      C . Run the form, and in the Forms Runtime program execute the Help |
      Debug menu command.
      D . Enable the Debug Mode button, run your form, and in the Forms Runtime
      program execute the Help | Debug menu command.
      Explanation:
      Enable the Debug Mode button, run the form, and the Debugger displays
      automatically.
      See the section "Running a Form Module in Debug Mode" for a refresher on
      this topic.

      34. When does the PRE-QUERY trigger fire?
      A*. After the user enters query criteria, but before the query executes
      B . Before the form enters Enter-Query mode
      C . After the form enters Enter-Query mode, but before the user enters
      query criteria
      D . After the query executes, but before records are shown to the user
      Explanation:
      After the user enters query criteria, but before the query executes
      The PRE-QUERY trigger fires after Enter-Query mode but before a query's
      select statement has been finalized, and therefore before the query is
      executed.

      35. Which built-in causes an editor to display for a text item?
      A . WHEN-NEW-ITEM-INSTANCE
      B . SHOW-EDITOR
      C*. SHOW_EDITOR
      Explanation:
      SHOW_EDITOR
      SHOW-EDITOR is formatted as a trigger, not a built-in, and doesn't exist.
      WHEN-NEW-ITEM-INSTANCE exists but is also a trigger, not a built-in.

      36. You want to write a trigger that screens a query condition. At what level will you place the trigger?
      A . Block
      B*. Form
      C . Item
      D . Record
      Explanation:
      Form

      37. You wish to have certain values in a form initialized when the form is 
      first opened. What trigger will you use?
      A . WHEN-NEW-CANVAS-INSTANCE
      B*. WHEN-NEW-FORM-INSTANCE
      C . WHEN-NEW-FORM
      D . WHEN-FORM-OPENED
      E . WHEN-NEW-CANVAS
      Explanation:
      WHEN-NEW-FORM-INSTANCE
      None of the other choices are valid triggers.
      38. What part of a trigger specifies the trigger's actions?
      A . Type
      B . Name
      C*. Code
      D . Scope
      Explanation:
      Code
      A trigger's actions are defined entirely by its code.
     
39. Which built-in causes an LOV to display for a text item that has one 
      defined?
      A . WHEN-NEW-ITEM-INSTANCE
      B . WHEN-NEW-LOV
      C . GO_ITEM
      D*. SHOW_LOV
      Explanation:
      SHOW_LOV
      WHEN-NEW-ITEM-INSTANCE and WHEN-NEW-LOV are triggers, not built-ins.
      GO_ITEM navigates to an item but does not open an LOV.

      40. What trigger can you use to ensure that a query entered by the user 
      includes at least one item that is indexed, and keep the query from
      occurring if not?
      A*. PRE-QUERY
      B . WHEN-CLEAR-BLOCK
      C . ON-SELECT
      D . POST-SELECT
      E . ON-FETCH
      Explanation:
      PRE-QUERY
      While the other triggers listed are query triggers, only the PRE-QUERY
      trigger fires before the select statement is executed.
     
41. What is the purpose of the KEY-OTHERS trigger?
      A . Provides code to execute if a key's own trigger fails
      B*. Provides code to execute if user presses a key that has no trigger
      attached
      C . Provides code to execute if user presses wrong key
      D . Provides code that accesses another key's trigger and executes the
      code it contains
      Explanation:
      Provides code to execute if user presses a key that has no trigger
      attached.
      See the section "Form Trigger Categories" for a refresher on this topic.
     
42. Your data analysis application is slowing the network to a crawl. You 
      analyze the queries users are performing and discover that the majority of
      their queries are too broad, returning many more records than necessary.
      You decide to require that any query have at least three fields containing
      criteria. What type of trigger can you use to enforce that requirement?
      A . POST-QUERY
      B . ON-NEW-QUERY-INSTANCE
      C . PRE-UPDATE
      D*. PRE-QUERY
      E . POST-UPDATE
      Explanation:
      PRE-QUERY
      The PRE-QUERY trigger fires before a query's select statement has been
      finalized, and is therefore ideal for screening query criteria before the
      query is executed.

      43. You have created an alert with three buttons. What value will be 
      returned if the user selects the second button?
      A . BUTTON2
      B . DIALOG_BUTTON2
      C*. ALERT_BUTTON2
      D . It depends on the choice being offered by the button.
      Explanation:
      ALERT_BUTTON2

      44. What is the default level at which validation occurs in the Forms 
      Runtime program?
      A*. Item
      B . Form
      C . Block
      D . Record
      Explanation:
      Item
      By default, the Forms Runtime program validates an item immediately when
      the user tries to leave the item.
      
45. How does the Forms Runtime program respond when a user enters text 
           into a text item that has an LOV attached and the VALIDATE_FROM_LIST
          property set to Yes?
      A . The Forms Runtime program ignores the LOV if the user types a value
      directly into the field.
      B . The Forms Runtime program populates the item automatically with the
      first value in the LOV that matches the user's entry.
      C*. The Forms Runtime program opens the LOV and shows only items that
      match what the user has typed so far.
      D . Validate From List is a Data Block property, not an Item property.
      Explanation:
      The Forms Runtime program opens the LOV and shows only items that match
      what the user has typed so far.
      See the section "Introduction to Form Builder Validation Properties" for a
      refresher on this topic.
     
46. How can you cause a block to use a database sequence to get unique 
IDs?
      A . Set the Initial Value property to :sequence.sequence-name.nextval.
      B . Set the Validate From List property to
:sequence.sequence-name.nextval.
      C . Set the DML Array Size property to :sequence.sequence-name.nextval.
      D*. This action is not possible.
      Explanation:
      This action is not possible.
      Data blocks cannot read sequences, and in fact cannot store values at all.
      Items, on the other hand, can.
      Give yourself half a point if you answered:
      Set the Initial Value property to
      :sequence.sequence-name.nextval.
      which would have been the right answer if the question had referred to an
      item instead of a block, and remember to pay closer attention to the
      wording of questions. In some Oracle exam questions, a single word defines
      why one choice is right and another choice wrong.

      47. You have written a contact-tracking application that includes a field 
      for the last date a client was contacted. You want to use a trigger to
      guarantee that whenever the date in that field is changed, the date
      entered is later than the date that was there before. What is the best
      trigger to use?
      A . PRE-UPDATE
      B . ON-COMMIT
      C . ON-UPDATE
      D*. PRE-COMMIT
      E . POST-UPDATE
      Explanation:
      PRE-COMMIT
      PRE-COMMIT is a form-level trigger that fires only once at the beginning
      of a transaction, so it cannot perform validation on a row-by-row basis.
      ON-UPDATE and ON-COMMIT only occur if you have replaced the default Forms
      Runtime transaction processing. POST-UPDATE occurs after the update has
      occurred, so it is too late for a validity check. The remaining trigger,
      PRE-COMMIT, is perfect.

      48. Your form module's Validation Unit property is set to Form. The module 
      includes a data block that has a PRE-TEXT-ITEM trigger. At what point will
      the trigger fire?
      A*. Never
      B . When data is committed
      C . Before the form is validated
      D . After the form is validated
      Explanation:
      Never
      The trigger will not fire because the object level defined in the trigger
      name item is smaller than the module's validation unit.
     
49. You want to add a delete-confirmation dialog to your application. You 
      can do so by creating which type of object?
      A*. Alert
      B . Message
      C . Editor
      D . Message box
      Explanation:
      Alert

      50. You would like to keep the user from seeing the Forms Runtime 
      program's "nn records applied and saved" messages. What would you put in
      the form's WHEN-NEW-FORM-INSTANCE trigger?
      A . :system.message_level := 0;
      B . :system.suppress_working := 'TRUE';
      C . :system.suppress_working := 'FALSE';
      D*. :system.message_level := 5;
      Explanation:
      :system.message_level := 5;
      See the section "Controlling System Messages" for a refresher on this
      topic.
      51. What is the last DML statement processed during a commit transaction?
      A*. INSERT
      B . UPDATE
      C . DELETE
      D . POST
      Explanation:
      INSERT
      The post command does not perform a commit. Of the three remaining
      choices, their processing order is delete, update, and then insert.

      52. Which of these built-ins can you use in a PRE-UPDATE trigger? 
      A . DOWN
      B . COMMIT_FORM
      C*. No Answer is Correct.
      D . All Answers are Correct.
      E . GO_ITEM
      Explanation:
      No Answer is Correct.
      Each built-in listed is a navigational built-in, which cannot be used
      within the navigational trigger PRE-UPDATE.

      53. Which navigational built-in will move the focus to a subsequent record 
      and place it on the same item it was on in the original record?
      A . NEXT_BLOCK
      B . NEXT_ITEM
      C*. DOWN
      D . The described action is not possible from a single built-in.
      Explanation:
      DOWN

      54. You would like to modify your form so it uses array processing to send 
      DML statements to the server in batches of 50. How would you do this?
      A . Set the canvas's DML Array Size property to 50.
      B*. Set the data block's DML Array Size property to 50.
      C . Set the window's DML Array Size property to 50.
      D . Array processing is limited to 25 records per batch.
      Explanation:
      Set the data block's DML Array Size property to 50.

   

0 comments:

Post a Comment