You are also maintaining an audit table with the

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. Because the item is sub classed, you cannot change any of its properties Answer: A QUESTION 173: You are developing a Human Resources form for HR clerks to insert, update, and delete records from the EMPLOYEES table. You are also maintaining an audit table with the following table description SQL>desc audlt changes Name Null? Type ------------------------------ -------- -- --------- ----------------------------TABLE NAME VARCHAR2 (30) ID NUMBER TIMESTAMP DATE CHANGE BY VARCHAR2 (30) CHANGE TYPE VARCHAR2 (6) Valid values for the CHANGE _TYPE column are INSERT, UPDATE, and DELETE. Which trigger(s) must you create or modify in the Human Resources form to track all the information in the audit table? A. Post-Commit B. Post-Data base-Commit C. When-Validate-Record D. Post-Insert, Post-Update and Post-Delete E. You cannot accomplish this using forms trigger; you must use a database trigger Answer: D QUESTION 174: You apply the Btn_PC property class to the Exit button and then make several changes in the property values of the button. The Btn_PC property class includes the item type Push Button. You accidentally change the Item Type property of the Exit Button to CheckBox . How can you change the Item Type of the Exit button back to Push Button, restore the subclassed relationship of the Item Type to the property class, and retain any other property changes that you have made? A. Select the Item Type property of the Exit button and click Inherit B. Change the Item Type property of the Exit button back to Push Button C. Select the Item Type property of the Exit button and click Property Class D. Set the Subclass Information property of the Exit button to NulI, then set it to Btn_PC E. Set the Item Type property in the Btn_PC property class to Check Box, then change it back to Push Button Actualtests.com - The Power of Knowing 1Z0-141 Answer: A QUESTION 175: Exhibit: You are coding a trigger (shown in the exhibit) to display the database error that occurs when users encounter the FRM-40505 error about being unable to execute a query. You have created an...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online