Oracle Forms and Reports - Practice Test

1. Can a content canvas be placed on a stacked canvas?

Yes

2. Which of the following is not a valid oracle forms object?

Group

Text item

block

trigger

3. Which is the first trigger fired when a form is opened

Item level

Form Level

Block Level

none

4. While specifying master/detail relationship between two blocks specifying the join condition is a must ?

TRUE

False

5. In Oracle Reports, Use a ____ parameter, when you want the parameter to substitute any part of the select statement at runtime.

bind

lexical

Unbind

None of the above

6. How is relative positioning in Oracle reports achieved?

using groups

using triggers

using anchors

None

7. In Oracle forms, Stacked and Tab canvasses are always built over a content canvas.

TRUE

False

8. Of the following which is not an executable method in Oracle Apps?

Host

Immediate

Oracle Forms

Oracle Reports

9. How are images stored in database

long raw datatype

long

double

byte

10. How can you change the select statement of a query at run time?

Using bind parameter

Using system parameter

Using lexical parameter

Using user parameter

11. In Oracle forms, the block to which form builder should first navigate is set with ________ property of the form module.

Initial Data block

First Navigation Data block

All of the above

None of the above

12. Which of the following are valid extension in Oracle Forms

fmb

fmt

A&B

None

13. In Oracle forms a block can be based on the following objects?

database trigger

view procedure

A & B

None

14. Use the ADD_GROUP_ROW procedure to add a row to a static record group

TRUE

False

15. In Oracle Forms, Data blocks can be created from _______ and Stored Procedure

Table or View

Editor

Alert

None of the above

16. How many types of canvas are there in a form?

17. CALL_FORM can calls the other form by which the parent form will be inactive

TRUE

False

18. What is SECURE property?

Hides characters that the operator types into the text item. This setting is typically used for password protection

You can restrict delete option using this property.

You can secure your form using this option.

None of the above

19. Is it possible to use User Exits in Report builder?

Yes

Not applicable

20. Can you call a database procedure from trigger in Oracle reports?

Yes

21. Name the directory having the FORMS source codes ( FMB files ) ?

AU_TOP forms directory

FND_TOP

None

22. A query fetched 10 records How many times does a PRE-QUERY Trigger

PRE-QUERY fires once..

PRE-QUERY fires 10 times.

PRE-QUERY fires 2 times.

None of the above

23. Which Triggers are created when Master-Detail relationship is established.

on-clear-details(form level)

on-check-delete-master fires whenever u r deleting the master records

on-check-delete-master(master block level)

All the above

24. How many times a pre-query trigger executed for a block of 10 records in oracle forms?

25. When-Validate-Item trigger can have navigational built-ins in them.

TRUE

False

Can’t say

None of the above

26. Key next item trigger is common in form level, block level and item level

TRUE

False

27. Global variables are defined with __________ data type and ________ size.

Long & 2 GB

LOB & 4 GB

Char & 255

Any Data type and Any Size

28. What are valid program units in Oracle Forms?

procedure

function

package

all the above

29. Which of the following property determines the type of an item.

Form.Item Type

Block.Item Type

Item Type

None

30. Which of the following is not an Oracle Reports built-in package?

srw.message

srw.do_sql

go_item

srw.do_sql

Question 1 of 30

Upload your own post and refer it anywhere anytime:

Upload your own post

Oracle Forms and Reports – Practice Test

Like this:

Share this post:

Like this: