Upwork Test Answers: Get all the correct answers of most recent and possible Upwork Tests A to Z (Updated on Jan, 2016)
Cover Letter Templates: These cover letter samples are not only for Upwork job, but also you will have some idea about your real life job
 
Freelance Profile Overviews: Different Profile samples and overviews of experts, advanced and intermediate level freelancers
For Newbie of Upwork: Upwork Help - How to apply for a job in Upwork with 10 most important articles about Upwork

A to Z View - All Upwork Test Answers

Oracle Forms 9i Test Answers

Here you will find most recent test questions and correct answers of Upwork test. Oracle Forms 9i test is an important test for database experts of Upwork freelancer for their strong profile. In this post, you will find Upwork Oracle Forms 9i Test answers of Upwork Database category and It will help you to get the related jobs. Search your desired answers of the test questions by pressing Ctrl + F button.


1. In the Human Resource form, you created a LOV based on a record group. 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. You attach the LOV to the Job_ID item and set its Validate property from List property to Yes. You run the form to test it. You enter 'Pro' (without the quotes) into the Job_ID item. What is the behavior when you press the Tab key?
 Answers: • 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.
 
 2. 'Create a library module' is a method of reuse that is possible with a PL/SQL program unit, but not with a Forms trigger.
 Answers: • False
 
 3. In the Human Resource form, you created a LOV based on a record group. 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. You attach the LOV to the Job_ID item and set its Validate property from List property to Yes. You run the form to test it. You enter 'Pro' (without the quotes) into the Job_ID item. What is the behavior when you press the Tab key?
 Answers: • The LOV will appear. If the user clicks Cancel, the cursor will remain in the Job_ID item and an error message will appear.
 
 4. A user has requested a change to the Summit.fmb module. The form has two windows, DEPT_WIN and EMP_WIN. DEPT_WIN is always visible to the user. However, EMP_WIN is only occasionally required to be opened. The user complains that once EMP_WIN is open, it is not possible to make the window invisible. The user can navigate between the open windows. You are asked NOT to write code to close EMP_WIN explicitly. What changes should you make to the Summit form?
 Answers: • Define EMP_WIN as a modeless window, set the Hide on Exit property to Yes
 
 5. An application uses a menu that contains a Check type Menu Item. You want to programmatically toggle the checked/unchecked state of the Check item. Which of the following built-ins can you use to accomplish this?
 Answers: • GET_MENU_ITEM_PROPERTY