Creategroupfromquery prod select pid as id name

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: d, '|| ' 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 produts ' ); Answer: C,E QUESTION 69: Exhibit: You want to create a menu item to enable users to sort the tabular display of a form either by customer ID, last Actualtests.com - The Power of Knowing 1Z0-141 name, or department ID. You decide to create a radio group as shown in the exhibit. Which statement about this radio group is true? A. You must create the radio group before creating Radio menu items for it. B. You must create a Radio menu item before the radio group is created. C. You must name the radio group the same as the submenu name so that it will be associated with that submenu. D. You must name the radio group Sort, the same as the submenu label, so that it will be associated with that submenu. Answer: B QUESTION 70: You created a LOV based on the query Record Group PRODUCTS. The LOV is attached to the :PROD.DESC text item. The validate from List property is set to No for the :PROD.DESC Text item. Which built-in can you call to execute the query associated with the Record Group? A. SHOW_LOV B. ADD_GROUP_ROW C. ADD_GROUP_COLUMN D. SET_GROUP_SELECTION E. CREATE_GROUP_FORM_QUERY F. VALIDATE(ITEM_SCOPE) when :PROD.DESC is the current item. Answer: A The show_lov (answerA) will be correct as it would invoke the lov and answer F is wrong as the set validate is set to no so will not validate from list and thus not fire the lov (thus not invoking the record group.) QUESTION 71: Exhibit: Actualtests.com - The Power of Knowing 1Z0-141 You are developing and testing a Forms application on a machine that has plenty of memory. The Customers block, whose Property Palette is shown in the exhibit, is based on a table that contains a large number of records. The initial query on the block appears quickly. However, after scrolling through hundreds of records in the block, you notice that it i...
View Full Document

Ask a homework question - tutors are online