Oracle Forms and Reports - Practice Test

1. what are the different types of window in oracle form

root and secondary

primary & secondary

modal and secondary

None of the Above

2. Can a tabbed canvas be placed on a stacked canvas?

Yes

3. In Oracle Reports, a bind parameter is used to replace a single value.

TRUE

False

4. In Oracle forms, which information can’t be passed from one form to another form?

local variables

Parameters

Global Variables

None of the above

5. Can a LOV created in Oracle Forms dynamically

Yes

6. In Oracle Reports, the between pages trigger fires for which of the following events?

Before First page

After Last page

None

A & B both

7. Select the Sequence of triggers that fire for a Text Item
1) When-New-Item
2) When-Validate
3) Key-Next
4) Pre-Text

1,2,3,4

4,1,3,2

4,1,2,3

3,2,1,4

8. A _______ is an argument to pass parameters from oracle reports to oracle applications

Parameter

Profile

Tokem

None of the above

9. Valid layoutts of the block in Oracle forms are

Tabular

Form

A&B

none

10. _______ flex fields captures the unique information

Key Flexfields

Descriptive Flexfields

Custom Flexfields

None of the above

11. Custom library allows extension of Oracle Applications forms without modification of Oracle applications code

TRUE

False

12. The value recorded in system.last_record variable is of type

Number

Boolean

Character

None of the above

13. How many group required for matrix report?

Two

Three

Four

One

14. In Oracle Forms, how many buttons are created on an alert?

15. Can you have a form without a Canvas?

Yes

16. How are images stored in database

long raw datatype

long

double

byte

17. Is it possible calling a report from a report?

Yes

18. Can a Block be associated to multiple objects like a Table, View or Synonym?

TRUE

False

Can’t say

None of the above

19. Which is used to identify menus, forms, concurrent programs, and application components

Short Name

Bast path

Application Name

None of the above

20. ______ is used for customizations such as form, enforcing business rules and disabling fields that are not required for site without modifying standard apps forms

APPCORE.pll

CUSTOM.pll

APPTREE.pll

None of the above

21. Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?

Yes

22. Committed block sometimes refer to a BASE TABLE ?

TRUE

False

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

TRUE

False

Can’t say

None of the above

24. What is template form?

All forms in oracle application will be developed using this form, to get standard appearance oracle application provide this form.

It’s an normal Oracle form.

None of the above

25. How many content canvases can a form have

26. Which library we can use to change the profile value?

APPCORE

FNDSQF

CUSTOM

None of the above

27. How to enfore the user to enter value in text item in oracle forms?

set required property to rue

set mandatory property to true

all text items are required

none

28. In Oracle Reports, Queries in are created in

Layout editor

Data model editor

A and B

None of the above

29. What is use of custom library?

By using this library we have to do cosmetic and navigation change in form customization.

By using this library we can compile the library

None of the above

30. 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

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: