Transactional trigger c stored procedure d from

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ype can you assign to the data block for this form without having the DBA create a database object? A. database table B. transactional trigger C. stored procedure D. FROM clause query E. client-side procedure Answer: D Explanation : The From clause data source enables you to create a block based on a SELECT statement. This is similar to basing a block on a view, however, the view does not have to be created in the database. When a query is executed on this type of block, the SELECT statement is sent to the database, and the resultant rows are returned to the block. Use this data source in place of creating a database view or table. However, unlike a table or view, DML operations are not allowed. QUESTION 57: Where can you add your own PL/SQL code in relation-handling triggers? A. Before the "End default relation program section" comment. B. After the "Begin default relation program section" comment. C. Before the "Begin default relation program section" comment. D. It is not possible to modify the relation-handling code that Forms automatically creates for relations. Answer: C Explanation : Relation-Handling triggers are created automatically when relation is built between Master and Detail blocks. Relation-handling will have comments inserted automatically Before the "Begin" and after the "End" default sections to allow users to replace them with developer PL/SQL custom code. QUESTION 58: Which value is valid for the iterate parameter in SET_TIMER built-in procedure? A. REUSE B. RECYCLE - The Power of Knowing 1Z0-132 C. NO_CHANGE D. OCCURRENCE Answer: C Explanation : SET_TIMER Changes the settings for an existing timer. You can modify the interval, the repeat parameter, or both. The parameter NO_CHANGE Specifies that the milliseconds property is to remain at its current setting. QUESTION 59: You create a data block based on a relation table containing a REF column. You select the REF column for your form module. Which statement about the REF column is true? A. It is created as a nondisplay item. B. The Lock Record property is set to Yes. C. It cannot be referenced in item level triggers. D. It is placed on the canvas with the highest sequence number. Answer: A Explanation : When creating a data block based on a table that contains a REF column, the Data Block Wizard will display two instances of this type of column. The first instance is the regular object column and all of its attributes. Selecting the attributes of this instance creates normal items in the data block. The second instance is the REF itself. Choosing this instance creates a nondisplay item on a null canvas. QUESTION 60: Which three objects can be components of a menu module? (Choose three) A. windows B. parameters C. object groups D. report objects E. visual attributes Answer: B, C, E Explanation : Menu module components could be parameters which can be passed between menu item and forms. Also menu module component could be Object Group and Visual Attributes. QUESTION 61: You create a package that contains PL/SQL variables that must be shared among several forms in the Travel application. You place the package in a library and attach the library to all the forms that need to share the data. Which parameter in the OPEN_FORM built-in must you set to ensure that changes made by one form are visible to the other forms in the application? - The Power of Knowing 1Z0-132 A. data_mode B. paramlist C. query_mode D. session_mode Answer: A Explanation : Use OPEN_FORM to create multiple-form applications, that is, applications that open more than one form at the same time. Data mode value is NO_SHARE_LIBRARY_DATA (The default.) At runtime, Form Builder will not share data between forms that have identical libraries attached (at design time). QUESTION 62: How can you change the cursor style in your form? A. Open the form module property palette and set the Cursor Style property. B. From the Tools menu, select Preferences-->Runtime Settings. C. Use the GET_APPLICATION_PROPERTY and SET_APPLICATION_PROPERTY built-ins. D. You cannot change the cursor style. Answer: C Explanation : GET_APPLICATION_PROPERTY and SET_APPLICATION_PROPERTY built-ins are used to Get and Set properties of the form applications. CURSOR_STYLE parameter Returns the name of the current cursor style property. QUESTION 63: Which trigger property applies to Key triggers? A. Hide Keys B. Show Menu Keys C. Hide Menu Keys D. Display in 'Keyboard Help' E. Hide Keys Description Answer: D Explanation : Key triggers allow you to modify the standard functionality of a function key. These triggers are subprograms that execute when a certain key is pressed. Key triggers allow you to modify, replace, or disable the standard functionality of a function key. Display in 'Keyboard Help' can be an application of key trigger. QUESTION 64: Which two statements are true about record groups? (Choose two) - The Power of Knowing 1Z0-132 A. They are sto...
View Full Document

Ask a homework question - tutors are online