Home      Tests New!      Polls      Discussion Forums     Take a Quiz     Make a Quiz     Login     Contact QuizMoz         Find a quiz.   Example: Harry Potter Quiz Create your own Poll Create a Test Make a Trivia Quiz Make a Quiz about Yourself Make Free Personality Test Recommend QuizMoz   Personal Injury Law Quizzes   Hottest Quizzes Free IQ Test   Michael Jackson Quiz   English Language Test   Does He Love You Quiz   Business Phone Etiquette Quiz   Impossible Quiz   Personality Quiz   Free Quizzes   India Quiz   ICC World Cup Quiz   Kya Mast Hai Life Quiz   General Knowledge Questions   Are you in Love Quiz   Skeletal System Quiz   Love Personality Quiz   General Knowledge Test         Home > Quizzes and Fun Tests > Oracle OCP Practice Tests > Oracle Test OCP Practice Test - Oracle 9i Form OCP Test Questions   Hottest Quizzes Free IQ Test  Oracle Test OCP Practice Test - Oracle 9i Form OCP Test Questions Welcome to the QuizMoz Oracle Test OCP Practice Test - Oracle 9i Form OCP Test Questions. 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!!  Oracle Test OCP Practice Test - Oracle 9i Form OCP Test Questions Facts  Average Score for this quiz: 45.5%  No of times this quiz has been taken: 14  No of people passing this quiz: 6  No of people failing this quiz: 8  Maximum score for this quiz: 92% 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  Oracle Test OCP Practice Test - Oracle 9i Form OCP Test Questions Discussion Forum 1.  What happens on clicking the Run Form Debug in Forms Builder? a. The forms run on the local machine using a debug executable client b. The form runs in a three-tier environment using the application server URL that is specified in runtime preferences c. The form runs in a three-tier environment using the application server URL that is specified in debug preferences d. The form runs in a simulated three-tier environment using an applet viewer that is included with the product to enable debugging Please provide appropriate updations Ques What happens on clicking the Run Form Debug in Forms Builder? a. b. c. d. Please describe the changes made by you 2.  TOM wants to create a new data block. He clicked the Data Blocks node in the Object Navigator, and then clicked Create to invoke the Create Data Block dialog box. As he clicked through the pages of the wizard, Create Relationship option appears. Which of the following statements hold true about the form? a. The block he is creating is based on a view b. The block he is creating is based on a stored procedure c. The form contains at least one block in addition to the block he is creating d. In addition to the block he is creating, the form contains at least two other blocks that are master detail blocks e. The block he is creating is based on a table that has at least one foreign key relationship to another table Please provide appropriate updations Ques TOM wants to create a new data block. He clicked the Data Blocks node in the Object Navigator, and then clicked Create to invoke the Create Data Block dialog box. As he clicked through the pages of the wizard, Create Relationship option appears. Which of the following statements hold true about the form? a. b. c. d. e. Please describe the changes made by you 3.  A master-detail form displays Orders and Order Items. Which of these Triggers are being created based on the relationship created between the Orders and Order_Items Database Data Block? a. When-Validate-Record Trigger b. When-Create-Record Trigger c. Post-Query Trigger d. On-Check-Delete-Master Trigger e. On-Populate-Details Trigger Please provide appropriate updations Ques A master-detail form displays Orders and Order Items. Which of these Triggers are being created based on the relationship created between the Orders and Order_Items Database Data Block? a. b. c. d. e. Please describe the changes made by you 4.  Upon testing a form, it was discovered that pressing the Tab key with the cursor in the Product Id field moves the cursor to Order Id field. Pressing the Tab key twice more moves the cursor to Department Name and, finally, to Location Id. How can the navigation order be changed so that the cursor moves from Product Id to Department Name when tabbing forward through the items in the Products block? a. Set Keep Cursor Position for all items to Yes b. Set the Required property of the Department_Name item to Yes c. Set the Keyboard Navigable property for the Order_Id item to No d. Set the Automatic Skip property for the Department_Name item to No e. Set the Next Navigation Item property for the Product_Id item to DEPARTMENT_NAME f. Set the Previous Navigation Item property for the Department_Name item to Product_ID g. Drag the Department_Name item to a position just below the Product_Id item in the Object Navigator Please provide appropriate updations Ques Upon testing a form, it was discovered that pressing the Tab key with the cursor in the Product Id field moves the cursor to Order Id field. Pressing the Tab key twice more moves the cursor to Department Name and, finally, to Location Id. How can the navigation order be changed so that the cursor moves from Product Id to Department Name when tabbing forward through the items in the Products block? a. b. c. d. e. f. g. Please describe the changes made by you 5.  The Orders form must display the item total for products ordered. It was decided to implement this functionality by creating an item in the ORDER_ITEMS block as a Calculated item. The item total is calculated by multiplying the UNIT_PRICE of the product by the QUANTITY ordered. Which item properties must be set? a. Item Type must be set to Display Item b. Calculation Mode must be set to Formula c. Calculation Mode must be set to Summary d. Summarized Block must be set to ORDER_ITEMS e. Formula must be set to an appropriate calculation Please provide appropriate updations Ques The Orders form must display the item total for products ordered. It was decided to implement this functionality by creating an item in the ORDER_ITEMS block as a Calculated item. The item total is calculated by multiplying the UNIT_PRICE of the product by the QUANTITY ordered. Which item properties must be set? a. b. c. d. e. Please describe the changes made by you 6.  Order entry clerks use the Orders form to enter the shipping date of an order. Once the shipping date has been entered into the database, the clerks are not allowed to modify it. What property can be set in the Property Palette for the Shipping_Date item to ensure that this data entry restriction is enforced? a. Enabled b. Database Item c. Update Allowed d. Update Only If NULL Please provide appropriate updations Ques Order entry clerks use the Orders form to enter the shipping date of an order. Once the shipping date has been entered into the database, the clerks are not allowed to modify it. What property can be set in the Property Palette for the Shipping_Date item to ensure that this data entry restriction is enforced? a. b. c. d. Please describe the changes made by you 7.  How can the users be enabled to add a single value to a list item? a. Set the List Style property to combo box. From the When-List-Activated trigger, call the Add_List_Element built-in b. Set the List Style property to Tlist. From the When-List-Activated trigger, call the Populate_List built-in c. Set the List Style property to poplist. From the When-List-Activated trigger, call the Add_List_Element built-in. d. Set the List Style property to combo box. From the When-List-Changed  trigger, call the Add_List_Element built-in Please provide appropriate updations Ques How can the users be enabled to add a single value to a list item? a. b. c. d. Please describe the changes made by you 8.  In the Human Resource form, a LOV based on a record group was created. The record group query selects the job title and job ID from the JOBS table that contains the following records: JOB_TITLE JOB_ID Accountant FI_ACCOUNT Accounting Manager AC_MGR Administration AD_ASST Assistant President AD_PRES Programmer IT_PROG Public Accountant AC_ACCOUNT Purchasing Clerk PU_CLERK Purchasing Manager PU_MAN Sales Manager SA_MAN Sales Representative SA_REP The Job_ID value is returned to the Employees.Job_Id item in the form. The LOV was attach the to the Job_ID item and its Validate property was set from List property to Yes. The form was run to test it. 'Pro' (without the quotes) was entered into the Job_ID item. What is the behavior when the Tab key is pressed? a. The LOV will appear. If the user clicks Cancel, the cursor will move to the next navigable item in the form b. The LOV will appear. If the user clicks Cancel, the cursor will remain in the Job_ID item and an error message will appear c. The LOV will not appear. The Job_ID item will be assigned the value IT_PROG. The cursor will move to the next navigable item in the form d. The LOV will not appear. The Job_ID item will be assigned the value Programmer. The cursor will move to the next navigable item in the form Please provide appropriate updations Ques In the Human Resource form, a LOV based on a record group was created. The record group query selects the job title and job ID from the JOBS table that contains the following records: <br><br> JOB_TITLE JOB_ID<br> Accountant FI_ACCOUNT<br> Accounting Manager AC_MGR<br> Administration AD_ASST<br> Assistant <br> President AD_PRES<br> Programmer IT_PROG<br> Public Accountant AC_ACCOUNT<br> Purchasing Clerk PU_CLERK<br> Purchasing Manager PU_MAN<br> Sales Manager SA_MAN<br> Sales Representative SA_REP<br><br/> The Job_ID value is returned to the Employees.Job_Id item in the form. The LOV was attach the to the Job_ID item and its Validate property was set from List property to Yes. The form was run to test it. 'Pro' (without the quotes) was entered into the Job_ID item. What is the behavior when the Tab key is pressed?<br> a. b. c. d. Please describe the changes made by you 9.  JOHN is developing a form for customers to order tickets to events. There is a Date item in the Tickets block of the form that has a LOV whose record group uses the following query: SELECT event_name, event_date FROM events ORDER BY event_date; In the Choose_Event block of the form, he wants users to be able to select an event name into an Event_Name item. The event name will be selected from a LOV that is sorted by the name of the event. He does not want to modify either LOV or record group at run time. Which of the following statement is correct with regard to LOV and record group as specified at design time? a. He must define a new LOV for the Choose_Event.Event_Name item that uses a different record group b. He must define a new LOV for the Choose_Event.Event_Name item, but he can base it on the same record group c. He can use the same LOV and record group for the Choose_Event.Event_Name item that he used for the Tickets.Date item d. He can use the same LOV for both items, but he should specify that each item must use a different record group for the LOV Please provide appropriate updations Ques JOHN is developing a form for customers to order tickets to events. There is a Date item in the Tickets block of the form that has a LOV whose record group uses the following query:<br><br>SELECT event_name, event_date <br>FROM events<br>ORDER BY event_date;<br><br>In the Choose_Event block of the form, he wants users to be able to select an event name into an Event_Name item. <br>The event name will be selected from a LOV that is sorted by the name of the event.<br>He does not want to modify either LOV or record group at run time. Which of the following statement is correct with regard to LOV and record group as specified at design time? a. b. c. d. Please describe the changes made by you 10.  TOM is developing a form for customers to order tickets to events. There is an Event_Date item in the Ticket block of the form, and he wants users to enter dates only for existing events. He used the LOV wizard to create an LOV based on a record group with the following query: SELECT event_name, event_date FROM events  ORDER BY event_name On the Column Properties page of the LOV (as shown in the exhibit), he clicked Look up return item and select the Tickets. Event_Date item from the items list. He runs the form to test it. However, when he invoked the LOV and chose an event, he received the error FRM-40212: Invalid value for field EVENT_DATE.' What should he do to correct this problem? a. Change the Validate from List property for the Event_Date item to No b. Create another item in the form to which the event name can be returned c. Modify the Record Group Query property for the record group to sort the list by event date d. Modify the Column Mapping property of the LOV so that the Event Date, rather than the Event Name is returned e. Modify the Record Group Query property for the record group so that the event date is the first column selected Please provide appropriate updations Ques TOM is developing a form for customers to order tickets to events. There is an Event_Date item in the Ticket block of the form, and he wants users to enter dates only for existing events. <br>He used the LOV wizard to create an LOV based on a record group with the following query: <br><br>SELECT event_name, event_date FROM eventsORDER BY event_name<br><br>On the Column Properties page of the LOV (as shown in the exhibit), he clicked Look up return item and select the Tickets. Event_Date item from the items list. He runs the form to test it. However, when he invoked the LOV and chose an event, he received the error FRM-40212:<br>Invalid value for field EVENT_DATE.'<br>What should he do to correct this problem? a. b. c. d. e. Please describe the changes made by you 11.  The Wild Life Association tab canvas needs to be resized. The View port Width and Height properties are 200 and 300. The values are changed to 150 and 120, respectively. What implication may this have on the design? a. Some tab pages may be obscured at run time b. By decreasing the View port Width property, some tab pages may be deleted c. Objects previously within the borders of a tab page may fall outside the tab page border, compilation errors will occur d. Objects previously within the borders of a tab page may fall outside the tab page border and will be visible at run time only by navigating to them programmatically e. Objects previously within the borders of a tab page may fall outside the tab page border and will be assigned to the null canvas Please provide appropriate updations Ques The Wild Life Association tab canvas needs to be resized. The View port Width and Height properties are 200 and 300. The values are changed to 150 and 120, respectively. What implication may this have on the design? a. b. c. d. e. Please describe the changes made by you 12.  In the Online E-learning .fmb module, data block items are displayed on two content canvases. A set of icon buttons is defined that users must have access to at all times. Which canvases type is appropriate to display the buttons? a. Overlay stacked canvas b. Overlay Tab canvas that is associated with a separate window c. Content canvas that is associated with the same window as the two content canvases d. Horizontal Toolbar canvas that is associated with a separate window e. Horizontal Toolbar canvas that is associated with the same window as the two content canvases Please provide appropriate updations Ques In the Online E-learning .fmb module, data block items are displayed on two content canvases. A set of icon buttons is defined that users must have access to at all times. Which canvases type is appropriate to display the buttons? a. b. c. d. e. Please describe the changes made by you Think you know more about this quiz!   Please enter your Name and what you would like to tell everyone about Oracle Test OCP Practice Test - Oracle 9i Form OCP Test Questions  Name: Think you know more about Oracle Test OCP Practice Test - Oracle 9i Form OCP Test Questions 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) Oracle Test OCP Practice Test - Oracle 9i Form OCP Test Questions Discussion Forum Know the Latest News about Oracle Test OCP Practice Test - Oracle 9i Form OCP Test Questions! What others think about Oracle Test OCP Practice Test - Oracle 9i Form OCP Test Questions By: sudha on Sep 17, 2009    just learning By: sudha on Sep 17, 2009    just learning By: sudha on Sep 17, 2009    just learning By: sudha on Sep 17, 2009    just learning By: sudha on Sep 17, 2009    just learning By: sudha on Sep 17, 2009    just learning By: sudha on Sep 17, 2009    just learning By: sudha on Sep 17, 2009    just learning By: sudha on Sep 17, 2009    just learning By: sudha on Sep 17, 2009    just learning By: sudha on Sep 17, 2009    just learning By: sudha on Sep 17, 2009    just learning By: sudha on Sep 17, 2009    just learning By: sudha on Sep 17, 2009    just learning By: sudha on Sep 17, 2009    just learning By: sudha on Sep 17, 2009    just learning By: sudha on Sep 17, 2009    just learning By: sudha on Sep 17, 2009    just learning By: sudha on Sep 17, 2009    just learning By: sudha on Sep 17, 2009    just learning   Hottest Quizzes Free IQ Test   Christmas Quiz   Christmas Quizzes   Kids General Knowledge Quiz   2009 General Knowledge Quiz   2010 General Knowledge Test   Science Quiz for Kids   Medical Terminology Quiz   Career Quiz for Kids   General Knowledge Science Test   Harry Potter Quiz   IQ Tests   Cricket 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.