Oracle Forms and Reports – Practice Questions

What is the difference between Per-Query and Post Query?

Select the Sequence of triggers that fire for a Text Item1) When-New-Item2) When-Validate3) Key-Next4) Pre-Text

A query fetched 10 records How many times does a POST-QUERY Trigger

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

Can we use GO-BLOCK package in a pre-field trigger

What is Post-Block?

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

EXIT_FORM is a restricted package procedure ?

The value recorded in system.last_record variable is of type

Can you change the default value of the radio button group at run time?

What is not the type of windows?

What are the different types of Delete details we can establish in Master-Details?

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

How do you pass values from one form to another form?

What is a RADIO GROUP?

How many no of columns can a RECORD GROUP have?

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

In Oracle Forms, The triggers that must fire when all the records are newly inserted and a commit is done are Pre-Insert, On-Insert and _____.

In Oracle Forms, The triggers that must fire when all the records are newly inserted and a commit is done are _______, On-Insert and Post-Insert.

In Oracle Forms, the Database item property is set to ‘no’ if the item is not associated with a base table column

Which text item data properties can restrict whether a user can insert new data?

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

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

In Oracle forms, the _______ block property can be used to sort the records queried from the database

In Oracle forms, which block property can be set programmatically?

In Oracle forms, A global variable is active and accessible within a _______

In Oracle Forms, If the not null constraint is defined, the _________ property is set to true.

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

In Oracle forms, Name_in is a function which writes values into a field

In Oracle forms, if you have a Post-query trigger which populates a non-base table field, what will be record status after querying?

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

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

If the same property is defined in both Property Class and the Visual Attributes then property value defined in which takes precedence over the other

Field variables and form System variables can be referenced in the library by

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

Which of the following function is used to check if a Parameter List is created or not.

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

Pick the correct sequence in which the trigger fires when a form loads.1) Post-Logon2) Pre-Form3) When-New-Record-Instance4) Pre-Record

A Data block can be associated with.

What is SECURE property?

If you have property class attached to an item and you have same trigger written for the item. Which will fire first?

Object group have a block

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

What is an LOV?

A control block is not associated with the database

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

Committed block sometimes refer to a BASE TABLE ?

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

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

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

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

What is template form?

Why we have to maintain the file names in Capital Letter? ( Library/FMB)

Which one is not the standard libraries available in template form?

What is use of custom library?

How can you change the default menu bar action?

By using APPDAYPK library you can display calendar window in date field LOV

Which library we can use to change the profile value?

How can I modify screen without modifying the underlying executable?

In Oracle Reports, What are the ways by which data can be generated for any parameter’s list of values?

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

In Oracle Reports, What type of columns will be used as an empty container to be populated from another object?

Which of the following is not a system variable in Oracle Reports?

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

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

Which of the following is not a Oracle Reports layout object?

Which of the following is not a system parameter in Oracle Reports.

In oracle report, what type of columns will be used for doing mathematical calculations?

In oracle report, If there are 10 pages in the report, then how many times the between pages trigger would fire?

In Oracle Reports, Queries in are created in

In Oracle Reports, The Report layout is created or modified in ______

Report Designer has file extension as _______.

In Oracle Reports, _____ determines the hierarchy of the data appearing in a report, and are used primarily to create breaks

In Oracle Reports, ______ are variables for your report that enable you to change the selection criteria at runtime.

In Oracle Reports, _____ are used to establish parent-child relationships between queries and groups via column-matching

In Oracle Reports, Developers can create 2 types of parameters viz: bind and

In Oracle Reports, Developers can create 2 types of parameters viz: ____ and lexical parameters

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

In Oracle Reports, Precede a bind parameter with a ______ while accessing the parameter in any code

In Oracle Reports, Report Totals at various groups can be created using _______.

In Oracle reports, A frame prints once for each record retrieved.

In Oracle reports, The print direction of a repeating frame can’t be _______

In Oracle reports, If you want to display or hide the contents of a Frame conditionally, then _________

Which is the report trigger will fire first?

How many group required for matrix report?

Is it possible calling a report from a report?

Is it possible to call a form from report?

Is it possible to change the table name of report query at run time?

How many report triggers are there in a Report?

Can we write format trigger in a repeating frame?

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

How many layout triggers are there in a report?

What is the fire sequence of between page trigger?

How many layout can have a report?

What is Flex?

What is fnd.srwinit ?

What is fnd.srwexit ?

After parameter form trigger will fire before the parameter form

Before report trigger will fire before the query will parse

which of them are valid report triggers

which of them are valid forms triggers

Which of the following is true about a property class in oracle forms

Can a record group be created dynamically in Oracle Forms

Can a LOV created in Oracle Forms dynamically

How many basetable blocks can a form have?

How many triggers can a form have?

Which is the first trigger fired when a form is opened

How many content canvases can a form have

How many stacked canvases can a forms have?

How many items can a form have?

How to hide an item from displayed?

What type of canvases are available in Oracle Forms

Which built-in is used to change item property at run time

In Oracle forms can you check whether an object exists or not

Can you attach a library to more than one form

Valid layoutts of the block in Oracle forms are

In Oracle forms which of the following items can be used as input items

Is the statement true ‘No of records displayed property of block can be set programatically in Oracle forms’?

Which of the following are valid extension in Oracle Forms

Can a block be created in oracle forms without a base table?

Which of the following are valid styles of alert in Oracle forms?

How to invoke a alter in oracle forms?

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

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

Valid file extenstion in Oracle reports are?

How is relative positioning in Oracle reports achieved?

Which of the following are valid layout formats in Oracle reprots

How to change the format of frame or item programatically in oracle reprots

Valid printing direction in Oracle reports are?

which of the following is not a valid oracle reports object?

What are the valid file extension Oracle libraries?

Number of records dispalyed in a block can be set at runtime in Oracle forms?

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

Which sub-routine is used to invoke alter in oracle forms

Which of the following is not a valid sub-function in oracle forms?

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

How to display message to user at runtime in Oracle Forms?

How is debugging message displayed in oracle reports

Can window property be changed at runtime in Oracle forms?

What are valid program units in Oracle Forms?

what are valid program units in Oracle Reports?

How are the font, colour are set for an object in oracle forms?

How to query data in a block at runtime in oracle forsm

Can you have more item then the columns of a table in a base table block

can you query data in a control block

How do you group objects to copy to another module?

which of the following are valid object in oracle forms

How to display a hint when cursor is moved from one item to another

How to display a message in the status bar when the cursor moved to the items

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

How is value defaulted in a text item in Oracle forms?

Can text item value be defaulted in oracle forns

Toolbar is not a valid canvas type in oracle forms?

A tab canvas can contain more than one page?

Can a PL/SQL library be attached to a form as well as report?

Can you call a database procedure from trigger in Oracle forms?

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

Can you call a Oracle form from an Oracle reports?

Can you call a Oracle report from an Oracle form?

Can a tabbed canvas be placed on a stacked canvas?

Can a content canvas be placed on a stacked canvas?

Can you call a stored procedure from a formula column in oracle reports?

How to run DDL statements from Oracle reprots

What are the mandatory parameters when we write concurrent program using stored procedures?

What is a collection of requests, request sets and concurrent programs

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

Is table registration mandatory when we use flexfields and alerts in apps?

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

Which is a container of valid values to its segments.

How do you access profile values in reports?

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

_______ determines the horizontal and vertical position of an object

Is it possible to use User Exits in Report builder?

Which parameter cannot be used in FROM clause?

How can we execute the query in the report trigger?

What is the correct Firing sequence of report triggers?

_______ flex fields captures the unique information

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

A _____ is a field made up of segments so that each segment has a name and a set of valid values

How many types of canvas are there in a form?

Can you have a form without a Canvas?

A _______ class is a named object that contains a list of properties and their settings

We can programatically submit the request with the help of ________ API

What different status of forms?

Can one issue DDL statements in oracle forms

Can one move FMX file from one Operating system to another operationg system

How many minimum groups are required for a matrix report

How many types of canvases are there.

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

What is the sequence of firing tigger in form of 1)Pre-form 2)Pre-block 3) When-new-form 4)When-validate-item 5)Post-block

How many parameter’s a concurrent program can take? (Maximum)

How can one see the query executed by system while runing execute_query statement

How are images stored in database

How many times a post query and pre query tigger gets fired in fetching 10 records

How many times a pre query and post query tigger gets fired for detail block in Master-Detail relationship

What are placeholders used for in oracle reports

Can single canvas be used for different blocks

How many radio options can be placed under a radio group

what are the different types of window in oracle form

what is the built-in used to show alert at run time

system variable :system.effective_date is read-only

Which is the predefined exception available in form 6i

what is the difference between key startup and pre-form tiggers