Oracle Fusion Middleware 11g: Build Application with Oracle Forms

Volume I (Lesson 1 to 5)
1. Web browser can run Java applet because it provides
a) Java Runtime Environment
b) Form service
c) User interface
d) Java
Archive
Answer: - a

2. Which tier contain web browser, where the application is displayed and used
a) Client-tier
b) Middle-tier
c) Database-tier
d) None
Answer: -
a

3. Which are types of list items styles?

a) Poplist
b) Combo box
c) Checked
d) Unchecked
Answer: - a or
b

4. Which two major environment variables that Forms Builder uses to format
date items:
a) Application date format mask
b) Database date format mask
c) Input date format mask
d) Built-in date format mask
e) B,C
f) A,D
Answer: -
e

5. Which is not the forms developer module type?

a) Form
b) Menu
c) BLOCK
d) PL/SQL
Library Answer: - c

6. Which are three major objects in a form?

a) Items
b) Source
c) Blocks
d) Table
e) A,C
f) B,D
Answer: -
e
7. DEPT block's source is DEPARTMENTS and EMP block's source is
EMPLOYEES table. What will be the default name of their relation object?
a) DEPARTMENTS_EMPLOYEES
b) DEPT_EMP
c) EMP_DEPT
d) EMPLOYEES
DEPARTMENTS Answer: - b

8. 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 you set in the property Palette for the
Shipping Date item to ensure that this data entry restriction is enforced?
a) Update Allowed
b) Insert Allowed
c) Update Only If
NULL Answer: - c

9. What is an indication that the Data Block Wizard is in reentrant mode?

a) There is a tabbed interface.
b) The Finish button is disabled.
c) There are no Next> or
d) The page to create relations does not
appear. Answer: - a

10. How many components of oracle application server:

a) 7
b) 4
c) 5
d) 6
Answer: -
c

11. How many components (major) in forms services architecture?

a) 3
b) 4
c) 5
d) 7
Answer: -
b

12. When you select multiple items and open the property palette, if same type
of properties has different values then, what are displays?
a) thus
b) Nothing
c) ********
d) 999999999
Answer: - c

13. By setting cascading property may remove many detail records when delete 1
record from master but the commit message shows only the number of records
deleted from the _ ?
 a) Master block
b) Detail block
c) Master and Detail block
d) Never display the number of records
deleted Answer: - a

14. What is indicated by the square of property palette icons?

a) Specify that the property value is the default value
b) Specify that the property value has been change from the default
c) Specify that the property value is inherited
d) Specify that the property value was inherited but has been
overridden. Answer: - b

15. A control blocks is a form block that

a) Does not have items that allow input from users.
b) Can have items relates to columns within database tables.
c) Is a main block in the form and it controls other blocks in the form?
d) Is not associated with any database table, and its items do not relate to any
columns within any database table.
Answer: - d

16. Which circumstance will cause the Data Block Wizard to display the Master-
Detail page?
a) When you are creating a control block.
b) When there is an existing block in the form
c) When you check the Enforce Data Integrity check box.
d) When a foreign key exists in the database which relates to the table you are using as
a Data source.
Answer: - d

17. How many architecture oracle forms server use to deploy database application?
a) Four-tier
b) Two-tier
c) Three-tire
d) Five-tier
Answer: - c

18. An HTML page to start the Form session dynamically created by

a) HTPP server
b) 0C4J
c) Form session
d) Form servlet
Answer: - d

19. What is true regarding check box?

a) Two-state interface object
b) Enable display of s defined set of choices
c) Set values either by user input or programmatically
d) None
e) A, C
 Answer: - e

20. The layout editor is a graphical design facility for creating and arranging
interface items€"
a) True
b) False
Answer: -
a

21. Reside on the middle-tire application server

a) Web browser
b) Application logic
c) J-locator
d) Form service Runtime
Engine Answer: - b or d

22. A master-detail relationship equates to the relationship in the entity

relationship diagram.
a) One-to-one
b) One-to-many
c) Many-to-one
d) Many-to-many
Answer: - b

23. In a master detail form, Relation is...

a) An object belonging to the master data block.
b) An object belonging to the detail data block.
c) An object belongs neither to the master data block nor the detail block.
d) Not an
object Answer: -
a

24. What is block?

a) Logical section of a form: owned by the form module
b) Produced to contain the views of canvas.
c) Named procedure, function or package
d) PL/SQL block executed on
events Answer: - a

25. Which master detail property would you use to delete the master record,
but prevent detail records from being deleted?
a) Non-isolated
b) Cascading
c) Isolated
d) Restricted
Answer: - c

26. Which property value deletes the records when a master record is deleted?
a) Non-Isolated
b) Isolated
c) Cascading
d) None
 Answer: c

27. By which the Java Applet is cached to run the Form without downloading it again
in future
a) application Server
b) Client
c) Form servlet
d) None
Answer: -
b

28. The client tier contains :

a) Application server
b) Database server
c) Web browser
d) From developer
Answer: - c

29. Which data type is better to use for storing phone number in the following
format ä€ce977-1-4123456ä€?
a) Text
b) AutoNumber
c) Number
d) Currency
Answer: - a

30. Which two statements are true statements about dependent objects?
a) Invalid objects cannot be described.
b) An object with status of invalid cannot be a referenced object.
c) The Oracle server automatically records dependencies among objects.
d) All schema objects have a status that is recorded in the data dictionary.
e) Both
A.C Answer:
-e

31. Pre-De1ete trigger is created when the deletion properties is set to?
a) Isolated
b) Non isolated
c) Cascading
d) when create manual relationship
Answer: - c

32. You are developing a single-block form with a block called Employees. While the
form is in development, you test it using the EMPLOYEES_TEST table in the
database, which has the same structure as the EMPLOYEES table in the same
database. When you put the form into production, you will run it using the
EMPLOYEES table. Which block property will you change to run the form
using the EMPLOYEES table?
a) WHERE clause
b) Database Data Block
c) Query Data Source Type
d) Query Data Source Name
33. You have been asked to define a data block based on a JUN. of multiple tables. The
read-only data will be used for calculations and lookups. The DBA is on holiday and
is unable to define a view on the database server. What is the simplest way for you
to continue to build the form?
a) Define a data block based on a Ref Cursor.
b) Define a data block based on a Table of Records.
c) Define a data block based in a From Clause query.
d) None of the above

34. The DBA has informed you that two new columns have been added to the
ORDERS table. The blocks in the Order Entry form were created manually. How
can you use a wizard to modify the Orders block to include items that corresponds
to these columns?
a) You cannot use wizards to add a new item to add data block that was
created manually.
b) Select the last item in the Orders block, then invoke the Layout Wizard from
the menu.
c) Select the Orders block in the Object Navigator, then invoke the Data Block
Wizard from the menu.
d) Select the Data Block node in the Object Navigator, and then invoke the Data
Block Wizard from the menu.
Answer: - c

35. How would you associate Database Tables with form objects in order to access
the tables from a form?
a) Create a data block and base it on all database tables you need to access.
b) Create a control block and associate its items with columns from database tables.
c) Create a data block for each database table you need to access.
d) Create a control block and associate its items with data blocks that are based
on database tables.
Answer: - c

36. How the detail records are displayed when a master block is queried depends on the
settings of
a) Relation properties
b) Two coordination properties
c) Cascading
IsolatedAnsw
1. How the detail records are displayed when a master block is queried depends on
the settings of
A. Relation properties
B. Two coordination properties
C. Cascading
D. Isolated
2. Pre-Delete trigger is created when the deletion properties is set to _?
A. Isolated
 B. NonIsolated
C. Cascading
D. When create manual relationship
3. By setting cascading property may remove many detail records when delete 1 record from
master but the commit message shows only the number of records deleted from the _ ?
A. Master block
B. Detail block
C. Master and Detail block
D. Never display the number of records deleted
4. DEPT block’s source is DEPARTMENTS and EMP block’s source is EMPLOYEES table.
What will be the default name of their relation object?
A. DEPARTMENTS_EMPLOYEES
B. DEPT_EMP
C. EMP_DEPT
D. EMPLOYEES_DEPARTMENTS
5. A master-detail relationship equates to the relationship in the entity relationship
diagram.
A. One-to-one
B. One-to-many
C. Many-to-one
D. Many-to-many