Forms Reports Interview Questions
In user parameter property we have list of values.
Can we write select query for binding?
for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
How to use buttons, check boxes in paper layout, paper design and paper parameter form in oracle report developer 10g ?
What is the difference between formula column and place holder?
How to create placeholder columns?
How cost of one Forms created & Report Created?
Table 1: STUDIES PNAME (VARCHAR), SPLACE (VARCHAR), COURSE (VARCHAR), CCOST (NUMBER) Table 2: SOFTWARE PNAME (VARCHAR), TITLE (VARCHAR), DEVIN (VARCHAR), SCOST (NUMBER), DCOST (NUMBER), SOLD (NUMBER) Table 3: PROGRAMMER PNAME (VARCHAR), DOB (DATE), DOJ (DATE), SEX (CHAR), PROF1 (VARCHAR), PROF2 (VARCHAR), SAL (NUMBER) PNAME – Programmer Name, SPLACE – Study Place, CCOST – Course Cost, DEVIN – Language the software or package is developed in, SCOST – Software Cost, DCOST – Development Cost, PROF1 – Proficiency 1 Use the above table definitions to answer the questions that follow. Find out the selling cost average for packages developed in Oracle. Display the names, ages and experiences of all programmers How much revenue has been earned through ?
How to create LOV in Oracle forms?
What is the difference between BPA AND Contract What are documents and test cases u followed ?
In what situation you create the BPA.?
What is responsibility and how you attach How to create user and how u attach with responsibility?
What is 4-way match?
Can you mention lexical parameter in select statement in the data model?
What are the types of trigger actions?
How do you give the list of values in bind parameter?
How you define procure to pay?
What is user exit.?
Where do you define the select statement of the parameter? is it followed by the & variable ?
What is integrity and how many integrity rules are there?
Difference between global and context sensitive segments?
Explain tkprof?
What is the source file of po report?
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
How to solve the error ?Frequency below its group? while running the report. Why it is happened and How to solve that?
What is the usage of the Flex mode in Layout Editor ?
What is the usage of the confine mode in Layout Editor ?
What is the use of Data Link in Reports?
How can you format a character field in a report Layout editor ?
Running a report from Form or other Report , The Parameter Form Page will be Display first . I don’t want to display the screen . What I have to do ?
What are the type of triggers available in Oracle Reports ?
What is the usage of frame ?
What is the use of Page Protect Property?
What is the difference between Anchoring Object and Enclosing Objects ?
What is the use of Printer Definition file (PRT) in Reports ?
What is the use of Validation triggers in Reports?
What is summary column in Oracle Reports ?
How can you create Lexical parameter and Bind parameter in Reports ?
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
Where we can use the placeholder columns?
What is the sequence the Report triggers will fires while running a report ?
What are all the system Parameters available in ORACLE Reports
How can you store a picture file in oracle database? explain the path/command?
What is a package and what are the packages available in report?
What is lexical parameter ?
How we can validate the run-time parameters in reports 6i ?
I don’t want to give the path of .Dat file in .Ctl file dynamically i want to give how ?
How do you run sql loader ?
If some data is not transferred where it will get stored ?
Did you received a single file or multiple files ?
Can i send the control file path as a parameter ?
What you write in Ctl file ?
How to load data into base tables ?
Why the Ctl file you put only in bin folder why not in other folder ?
Can my report have different layouts ?
Can i write commit in Before report trigger ?
Suppose you have seven tables based on that you have to create a report you don’t have access to db. then how do you find the relation between tables ?
i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output ?
Difference between repeating frame and frame ?
Difference between place holder and formula column ?
What is difference between group above and group left report ?
How will the report recognize the parameter ?
Can you call procedure or function is sq l query in reports ?
If you develop report do u ask for anything from u r team leader ?
From where do you receive the information to develop report ?
What is bit map and character mode?
What is procedure like symbols of bind and lexical ?
If u have one group can you create another from that ?
What are the various types of reports ?
Where do you put the report file ?
What exactly you write in when_new_form_instance ?
A text item is there what are the different types of triggers associated with it ?
How do you place it in required folder ?
.fmb will be in which folder ?
If you want to delete all these detail block etc what will happen in form ?
If i want to change the functionality of an item in report during runtime how like what do you write in when_button_pressed ?
How do you compile a form i.e .fmb file in Unix or in dos ?
What is latest version in reports ?
How to call Report from other Report ?
There are Two pl/sql Libraries Lib1,Lib2 are attached to a form and these two libraries contains functions with same name fun1 (i,e lib1 have a function fun1 and lib2 also have a function fun1).how to call these functios from forms?
What built-in is used for showing the alert during run-time?
What is a library in Forms 4.0?
What built-in is used to trapping errors in forms 4?
What is a predefined exception available in forms 4.0?
Is it possible to attach same library to more than one form?
What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?
What is the order of the triggers fired once the form is opened?
Can a single canvas be used by different blocks ?
What is AppCore and AppCore2 ?
Can you truncate a table in a procedure in Oracle Forms?
What is the use of transactional triggers?
What is trigger associated with the timer?
What is a difference between pre-select and pre-query?
What are the differences between post database commit and post-form commit?
What are built-ins associated with timers?
What is a timer?
What are the vbx controls?
What is strip sources generate options?
What is the advantage of the library?
What is a library?
What is new_form built-in?
What is difference between open_form and call_form?
What are display items?
What is a combo box?
What is a text list?
What is pop list?
What are the different display styles of list items?
What are the difference between lov & list item?
What is system.coordination_operation?
What is the difference between $$DATE$$ & $$DBDATE$$
What are the master-detail triggers?
What is WHEN-Database-record trigger?
What is forms_DDL?
What is synchronize?
What is an User_exit?
What is a Text_io Package?
What are the important difference between property clause and visual attributes?
Can a property clause itself be based on a property clause?
What is a property clause?
What are visual attributes?
What are the different styles of activation of ole Objects?
What is the difference between OLE Server & Ole Container?
What is the difference between object embedding & linking in Oracle forms?
What is an OLE?
State any three mouse events system variables?
What are the various sub events a mouse double click event involves?
When a form is invoked with call_form, Does oracle forms issues a save point?
How do you create a new session while open a new form?
What is the use of image_zoom built-in?
What are the trigger associated with image items?
What is the difference between boiler plat images and image items?
What are different types of images?
Can you pass data parameters to forms?
When do you use data parameter type?
What are the different Parameter types?
How do you reference a parameter indirectly?
How do you reference a Parameter?
How do you call other Oracle Products from Oracle Forms?
What is the maximum no of chars the parameter can store?
What are the Built-ins used for sending Parameters to forms?
What are parameters?
Use the Add_group_row procedure to add a row to a static record group 1. true or false?
Use the add_group_column function to add a column to record group that was created at a design time?
What are the built-ins used for finding object ID functions?
What are the built-ins used for processing rows?
What are the built-in used for getting cell values?
What are the built -ins used for Modifying a group’s structure?
What are the built-ins used for Creating and deleting groups?
What is a Static Record Group?
What is a Non Query Record Group?
What is a Query Record Group?
What are the different types of Record Groups?
What is the Maximum allowed length of Record group Column?
How many number of columns a record group can have?
What are the built-ins that are used for setting the LOV properties at runtime?
What is the “LOV of Validation” Property of an item? What is the use of it?
What is the basic data structure that is required for creating an LOV?
What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?
What are the Built-ins to display the user-named editor?
What is the User-Named Editor?
What are the different types of Co-ordinations of the Master with the Detail block?
What are the Coordination Properties in a Master-Detail relationship?
What are the different default triggers created when Master Deletes Property is set to isolated?
What are the different default triggers created when Master Deletes Property is set to Cascade?
What are the different default triggers created when Master Deletes Property is set to Non-isolated?
What are the different types of Delete details we can establish in Master-Details?
What are Most Common types of Complex master-detail relationships?
What are the two phases of block coordination?
What is coordination Event?
What is a master detail relationship?
What are the default extension of the files created by library module?
What are the default extensions of the files created by menu module?
What are the default extensions of the files created by forms modules?
What are different types of modules available in oracle form?
What are the different window events activated at runtimes?
Can you have more than one content canvas view attached with a window?
How many windows in a form can have console?
What is the remove on exit property?
What built-in is used for showing the alert during run-time?
Can you attach an alert to a field?
What are the display styles of an alert?
What is an Alert?
List the built-in routines for the controlling canvas views during run-time?
What is the content view and stacked view?
What are the types of canvas-views?
What is a canvas-view?
What built-in is used for changing the properties of the window dynamically?
List the windows event triggers available in Forms 4.0?
List the built-in routine for controlling window during run-time?
Can a root window be made modal?
What are the different types of windows?
What is a window?
What are the types of visual attribute settings?
What is a visual attribute?
can you change the default value of the radio button group at run time?
What are the display styles of list items?
what is a display item?
What are the three types of user exits available ?
What is an user exit used for?
How can a cross product be created?
What are the two panes that Appear in the design time pl/sql ?
What are the two ways by which data can be generated for a parameter’s Using static values?
How can a button be used in a report to give a drill down facility?
What is the purpose of the product order option in the column property sheet?
With which function of summary item is the compute at options required?
If a break order is set on a column would it effect columns which are under the column?
Is it possible to set a filter condition in a cross product group in matrix reports?
To execute row from being displayed that still use column in the row which property can be used?
What are the sql clauses supported in the link property sheet?
If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?
Is it possible to insert comments into sql statements return in the data model editor?
What is term? What is use of term?
Which parameter can be used to set read level consistency across multiple queries?
What are the default parameter that appear at run time in the parameter screen?
Where is the external query executed at the client or the server?
Where is a procedure return in an external pl/sql library executed at the client or at the server?
What use of command line parameter cmd file?
What is bind reference and how can it be created?
Is it possible to disable the parameter from while running the report?
From which designation is it preferred to send the output to the printed?
What are the different file extensions that are created by oracle reports?
What are the triggers associated with a check box?
What is a Check Box?
Can you change the color of the push button in design time?
What is a Navigable item?
List the Types of Items?
What is a Layout Editor?
What are the design facilities available in forms 4.0?
What are the types of Pop-up window ?
What do you mean by a pop-up window ?
Deleting a page removes information about all the fields in that page ?
What is the significance of PAGE 0 in forms 3.0 ?
Two popup pages can appear on the screen at a time ?
What do you mean by a page ?
What is the difference between system.current_field and system.cursor_field ?
List the system variables related in Block and Field?
When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?
What package procedure used for invoke sql plus from sql forms ?
What package procedure is used for calling another form ?
What the PAUSE package procedure does ?
How does the command POST differs from COMMIT ?
Identify package function from the following ?
What is the difference between NAME_IN and COPY ?
What ERASE package procedure does ?
What Enter package procedure does ?
What are the unrestricted procedures used to change the popup screen position during run time ?
What SYNCHRONIZE procedure does ?
Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?
What is the difference between restricted and unrestricted package procedure ?
What are the different types of Package Procedure ?
What is a Package Procedure ?
What is the difference between keystartup and pre-form ?
What is Post-Block?
When does an on-lock trigger fire ?
How can you execute the user defined triggers in forms 3.0 ?
Is a Keystartup trigger fires as result of a operator pressing a key explicitly ?
Can we use GO-BLOCK package in a pre-field trigger ?
When is PRE-QUERY trigger executed ?
What is the difference between a POST-FIELD trigger and a POST-CHANGE trigger ?
What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?
What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger ?
A query fetched 10 records How many times does a PRE-QUERY Trigger and POST-QUERY Trigger will get executed ?
When will ON-VALIDATE-FIELD trigger executed ?
What is the usuage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ?
State the order in which these triggers are executed ?
How do you trap the error in forms 3.0 ?
What does an on-clear-block Trigger fire?
What is the difference between a Function Key Trigger and Key Function Trigger ?
What are the different types of key triggers ?
what are Navigational Triggers?
What are the types of TRIGGERS ?
What is a Trigger ?
While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False.
Can we create two blocks with the same name in form 3.0 ?
Committed block sometimes refer to a BASE TABLE ? True or False.
How do you control the constraints in forms ?
What is the maximum size of a form ?
What is an SQL FORMS ?
What are the built_in used to trapping errors in forms 4?
Can a formula column referred to columns in higher group?
How can a text file be attached to a report while creating in the report writer?
What is the built_in routine used to count the no of rows in a group?
What is the built-in function used for finding the alert?
What is an anchoring object & what is its use?
Can a repeating frame be created without a data group as a base?
Which of the two views should objects according to possession?
What are modeless windows?
List some built-in routines used to manipulate images in image_item?
What are the triggers available in the reports?
what are the different objects that you cannot copy or reference in object groups?
Explain about stacked canvas views?
What are different types of canvas views?
Can a field be used in a report wihtout it appearing in any data group?
What are the various methods of performing a calculation in a report ?
What is the built-in used to get and set lov properties during run-time?
What is a physical page ? What is a logical page ?
What is an object groups?
List system variables available in forms 4.0, and not available in forms ?
Is it possible to attach same library to more than one form?
At what point of report execution is the before Report trigger fired?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size? If yes,how?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?
Give built-in routine related to a record groups?
What are the ways to monitor the performance of the report?
Can you change the alert messages at run-time?
Is it possible to split the printpreviewer into more than one region?
What are the different modals of windows?
Explain about horizontal, Vertical tool bar canvas views?
Do user parameters appear in the data modal editor in 2.5?
How do you pass the parameters from one form to another form?
The join defined by the default data link is an outer join yes or no?
How is link tool operation different between reports 2 & 2.5?
What are the menu items that oracle forms 4.0 supports?
List the editors available in forms 4.0?
What is the main difference between Reports 2.0 & Reports 2.5?
What built-in routines are used to display editor dynamically?
What is the frame & repeating frame?
What is a predefined exception available in forms 4.0?
What are the types of calculated columns available?
What are the two ways to incorporate images into a oracle forms application?
Is the After report trigger fired if the report execution fails?
What is relation between the window and canvas views?
Does a grouping done for objects in the layout editor affect the grouping done in the datamodel editor?
What is a record Group?
Name of the functions used to get/set canvas properties?
What is the difference between setting up of parameters in reports 2.0 reports ?
Give the sequence of execution of the various report triggers?
What are the triggers associated with the image item?
How can a square be drawn in the layout editor of the report writer?
What is the difference when Flex mode is on and when it is off?
Explain about content canvas views?
What is a library in Forms 4.0?
To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?
What is the difference when confine mode is on and when it is off?
What does the term panel refer to with regard to pages?
If two groups are not linked in the data model editor, What is the hierarchy between them?
What are the two repeating frame always associated with matrix object?
What are the two types views available in the object navigator?
What is the built-in used for showing lov at runtime?
What is the use of hidden column?
How do you display console on a window ?
What is the use of break group?
What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?
How can a break order be created on a column in an existing group?
What is the use of place holder column?
Can a formula column be obtained through a select statement?
Can we write select query for binding?
for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
How to use buttons, check boxes in paper layout, paper design and paper parameter form in oracle report developer 10g ?
What is the difference between formula column and place holder?
How to create placeholder columns?
How cost of one Forms created & Report Created?
Table 1: STUDIES PNAME (VARCHAR), SPLACE (VARCHAR), COURSE (VARCHAR), CCOST (NUMBER) Table 2: SOFTWARE PNAME (VARCHAR), TITLE (VARCHAR), DEVIN (VARCHAR), SCOST (NUMBER), DCOST (NUMBER), SOLD (NUMBER) Table 3: PROGRAMMER PNAME (VARCHAR), DOB (DATE), DOJ (DATE), SEX (CHAR), PROF1 (VARCHAR), PROF2 (VARCHAR), SAL (NUMBER) PNAME – Programmer Name, SPLACE – Study Place, CCOST – Course Cost, DEVIN – Language the software or package is developed in, SCOST – Software Cost, DCOST – Development Cost, PROF1 – Proficiency 1 Use the above table definitions to answer the questions that follow. Find out the selling cost average for packages developed in Oracle. Display the names, ages and experiences of all programmers How much revenue has been earned through ?
How to create LOV in Oracle forms?
What is the difference between BPA AND Contract What are documents and test cases u followed ?
In what situation you create the BPA.?
What is responsibility and how you attach How to create user and how u attach with responsibility?
What is 4-way match?
Can you mention lexical parameter in select statement in the data model?
What are the types of trigger actions?
How do you give the list of values in bind parameter?
How you define procure to pay?
What is user exit.?
Where do you define the select statement of the parameter? is it followed by the & variable ?
What is integrity and how many integrity rules are there?
Difference between global and context sensitive segments?
Explain tkprof?
What is the source file of po report?
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
How to solve the error ?Frequency below its group? while running the report. Why it is happened and How to solve that?
What is the usage of the Flex mode in Layout Editor ?
What is the usage of the confine mode in Layout Editor ?
What is the use of Data Link in Reports?
How can you format a character field in a report Layout editor ?
Running a report from Form or other Report , The Parameter Form Page will be Display first . I don’t want to display the screen . What I have to do ?
What are the type of triggers available in Oracle Reports ?
What is the usage of frame ?
What is the use of Page Protect Property?
What is the difference between Anchoring Object and Enclosing Objects ?
What is the use of Printer Definition file (PRT) in Reports ?
What is the use of Validation triggers in Reports?
What is summary column in Oracle Reports ?
How can you create Lexical parameter and Bind parameter in Reports ?
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
Where we can use the placeholder columns?
What is the sequence the Report triggers will fires while running a report ?
What are all the system Parameters available in ORACLE Reports
How can you store a picture file in oracle database? explain the path/command?
What is a package and what are the packages available in report?
What is lexical parameter ?
How we can validate the run-time parameters in reports 6i ?
I don’t want to give the path of .Dat file in .Ctl file dynamically i want to give how ?
How do you run sql loader ?
If some data is not transferred where it will get stored ?
Did you received a single file or multiple files ?
Can i send the control file path as a parameter ?
What you write in Ctl file ?
How to load data into base tables ?
Why the Ctl file you put only in bin folder why not in other folder ?
Can my report have different layouts ?
Can i write commit in Before report trigger ?
Suppose you have seven tables based on that you have to create a report you don’t have access to db. then how do you find the relation between tables ?
i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output ?
Difference between repeating frame and frame ?
Difference between place holder and formula column ?
What is difference between group above and group left report ?
How will the report recognize the parameter ?
Can you call procedure or function is sq l query in reports ?
If you develop report do u ask for anything from u r team leader ?
From where do you receive the information to develop report ?
What is bit map and character mode?
What is procedure like symbols of bind and lexical ?
If u have one group can you create another from that ?
What are the various types of reports ?
Where do you put the report file ?
What exactly you write in when_new_form_instance ?
A text item is there what are the different types of triggers associated with it ?
How do you place it in required folder ?
.fmb will be in which folder ?
If you want to delete all these detail block etc what will happen in form ?
If i want to change the functionality of an item in report during runtime how like what do you write in when_button_pressed ?
How do you compile a form i.e .fmb file in Unix or in dos ?
What is latest version in reports ?
How to call Report from other Report ?
There are Two pl/sql Libraries Lib1,Lib2 are attached to a form and these two libraries contains functions with same name fun1 (i,e lib1 have a function fun1 and lib2 also have a function fun1).how to call these functios from forms?
What built-in is used for showing the alert during run-time?
What is a library in Forms 4.0?
What built-in is used to trapping errors in forms 4?
What is a predefined exception available in forms 4.0?
Is it possible to attach same library to more than one form?
What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?
What is the order of the triggers fired once the form is opened?
Can a single canvas be used by different blocks ?
What is AppCore and AppCore2 ?
Can you truncate a table in a procedure in Oracle Forms?
What is the use of transactional triggers?
What is trigger associated with the timer?
What is a difference between pre-select and pre-query?
What are the differences between post database commit and post-form commit?
What are built-ins associated with timers?
What is a timer?
What are the vbx controls?
What is strip sources generate options?
What is the advantage of the library?
What is a library?
What is new_form built-in?
What is difference between open_form and call_form?
What are display items?
What is a combo box?
What is a text list?
What is pop list?
What are the different display styles of list items?
What are the difference between lov & list item?
What is system.coordination_operation?
What is the difference between $$DATE$$ & $$DBDATE$$
What are the master-detail triggers?
What is WHEN-Database-record trigger?
What is forms_DDL?
What is synchronize?
What is an User_exit?
What is a Text_io Package?
What are the important difference between property clause and visual attributes?
Can a property clause itself be based on a property clause?
What is a property clause?
What are visual attributes?
What are the different styles of activation of ole Objects?
What is the difference between OLE Server & Ole Container?
What is the difference between object embedding & linking in Oracle forms?
What is an OLE?
State any three mouse events system variables?
What are the various sub events a mouse double click event involves?
When a form is invoked with call_form, Does oracle forms issues a save point?
How do you create a new session while open a new form?
What is the use of image_zoom built-in?
What are the trigger associated with image items?
What is the difference between boiler plat images and image items?
What are different types of images?
Can you pass data parameters to forms?
When do you use data parameter type?
What are the different Parameter types?
How do you reference a parameter indirectly?
How do you reference a Parameter?
How do you call other Oracle Products from Oracle Forms?
What is the maximum no of chars the parameter can store?
What are the Built-ins used for sending Parameters to forms?
What are parameters?
Use the Add_group_row procedure to add a row to a static record group 1. true or false?
Use the add_group_column function to add a column to record group that was created at a design time?
What are the built-ins used for finding object ID functions?
What are the built-ins used for processing rows?
What are the built-in used for getting cell values?
What are the built -ins used for Modifying a group’s structure?
What are the built-ins used for Creating and deleting groups?
What is a Static Record Group?
What is a Non Query Record Group?
What is a Query Record Group?
What are the different types of Record Groups?
What is the Maximum allowed length of Record group Column?
How many number of columns a record group can have?
What are the built-ins that are used for setting the LOV properties at runtime?
What is the “LOV of Validation” Property of an item? What is the use of it?
What is the basic data structure that is required for creating an LOV?
What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?
What are the Built-ins to display the user-named editor?
What is the User-Named Editor?
What are the different types of Co-ordinations of the Master with the Detail block?
What are the Coordination Properties in a Master-Detail relationship?
What are the different default triggers created when Master Deletes Property is set to isolated?
What are the different default triggers created when Master Deletes Property is set to Cascade?
What are the different default triggers created when Master Deletes Property is set to Non-isolated?
What are the different types of Delete details we can establish in Master-Details?
What are Most Common types of Complex master-detail relationships?
What are the two phases of block coordination?
What is coordination Event?
What is a master detail relationship?
What are the default extension of the files created by library module?
What are the default extensions of the files created by menu module?
What are the default extensions of the files created by forms modules?
What are different types of modules available in oracle form?
What are the different window events activated at runtimes?
Can you have more than one content canvas view attached with a window?
How many windows in a form can have console?
What is the remove on exit property?
What built-in is used for showing the alert during run-time?
Can you attach an alert to a field?
What are the display styles of an alert?
What is an Alert?
List the built-in routines for the controlling canvas views during run-time?
What is the content view and stacked view?
What are the types of canvas-views?
What is a canvas-view?
What built-in is used for changing the properties of the window dynamically?
List the windows event triggers available in Forms 4.0?
List the built-in routine for controlling window during run-time?
Can a root window be made modal?
What are the different types of windows?
What is a window?
What are the types of visual attribute settings?
What is a visual attribute?
can you change the default value of the radio button group at run time?
What are the display styles of list items?
what is a display item?
What are the three types of user exits available ?
What is an user exit used for?
How can a cross product be created?
What are the two panes that Appear in the design time pl/sql ?
What are the two ways by which data can be generated for a parameter’s Using static values?
How can a button be used in a report to give a drill down facility?
What is the purpose of the product order option in the column property sheet?
With which function of summary item is the compute at options required?
If a break order is set on a column would it effect columns which are under the column?
Is it possible to set a filter condition in a cross product group in matrix reports?
To execute row from being displayed that still use column in the row which property can be used?
What are the sql clauses supported in the link property sheet?
If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?
Is it possible to insert comments into sql statements return in the data model editor?
What is term? What is use of term?
Which parameter can be used to set read level consistency across multiple queries?
What are the default parameter that appear at run time in the parameter screen?
Where is the external query executed at the client or the server?
Where is a procedure return in an external pl/sql library executed at the client or at the server?
What use of command line parameter cmd file?
What is bind reference and how can it be created?
Is it possible to disable the parameter from while running the report?
From which designation is it preferred to send the output to the printed?
What are the different file extensions that are created by oracle reports?
What are the triggers associated with a check box?
What is a Check Box?
Can you change the color of the push button in design time?
What is a Navigable item?
List the Types of Items?
What is a Layout Editor?
What are the design facilities available in forms 4.0?
What are the types of Pop-up window ?
What do you mean by a pop-up window ?
Deleting a page removes information about all the fields in that page ?
What is the significance of PAGE 0 in forms 3.0 ?
Two popup pages can appear on the screen at a time ?
What do you mean by a page ?
What is the difference between system.current_field and system.cursor_field ?
List the system variables related in Block and Field?
When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?
What package procedure used for invoke sql plus from sql forms ?
What package procedure is used for calling another form ?
What the PAUSE package procedure does ?
How does the command POST differs from COMMIT ?
Identify package function from the following ?
What is the difference between NAME_IN and COPY ?
What ERASE package procedure does ?
What Enter package procedure does ?
What are the unrestricted procedures used to change the popup screen position during run time ?
What SYNCHRONIZE procedure does ?
Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?
What is the difference between restricted and unrestricted package procedure ?
What are the different types of Package Procedure ?
What is a Package Procedure ?
What is the difference between keystartup and pre-form ?
What is Post-Block?
When does an on-lock trigger fire ?
How can you execute the user defined triggers in forms 3.0 ?
Is a Keystartup trigger fires as result of a operator pressing a key explicitly ?
Can we use GO-BLOCK package in a pre-field trigger ?
When is PRE-QUERY trigger executed ?
What is the difference between a POST-FIELD trigger and a POST-CHANGE trigger ?
What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?
What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger ?
A query fetched 10 records How many times does a PRE-QUERY Trigger and POST-QUERY Trigger will get executed ?
When will ON-VALIDATE-FIELD trigger executed ?
What is the usuage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ?
State the order in which these triggers are executed ?
How do you trap the error in forms 3.0 ?
What does an on-clear-block Trigger fire?
What is the difference between a Function Key Trigger and Key Function Trigger ?
What are the different types of key triggers ?
what are Navigational Triggers?
What are the types of TRIGGERS ?
What is a Trigger ?
While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False.
Can we create two blocks with the same name in form 3.0 ?
Committed block sometimes refer to a BASE TABLE ? True or False.
How do you control the constraints in forms ?
What is the maximum size of a form ?
What is an SQL FORMS ?
What are the built_in used to trapping errors in forms 4?
Can a formula column referred to columns in higher group?
How can a text file be attached to a report while creating in the report writer?
What is the built_in routine used to count the no of rows in a group?
What is the built-in function used for finding the alert?
What is an anchoring object & what is its use?
Can a repeating frame be created without a data group as a base?
Which of the two views should objects according to possession?
What are modeless windows?
List some built-in routines used to manipulate images in image_item?
What are the triggers available in the reports?
what are the different objects that you cannot copy or reference in object groups?
Explain about stacked canvas views?
What are different types of canvas views?
Can a field be used in a report wihtout it appearing in any data group?
What are the various methods of performing a calculation in a report ?
What is the built-in used to get and set lov properties during run-time?
What is a physical page ? What is a logical page ?
What is an object groups?
List system variables available in forms 4.0, and not available in forms ?
Is it possible to attach same library to more than one form?
At what point of report execution is the before Report trigger fired?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size? If yes,how?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?
Give built-in routine related to a record groups?
What are the ways to monitor the performance of the report?
Can you change the alert messages at run-time?
Is it possible to split the printpreviewer into more than one region?
What are the different modals of windows?
Explain about horizontal, Vertical tool bar canvas views?
Do user parameters appear in the data modal editor in 2.5?
How do you pass the parameters from one form to another form?
The join defined by the default data link is an outer join yes or no?
How is link tool operation different between reports 2 & 2.5?
What are the menu items that oracle forms 4.0 supports?
List the editors available in forms 4.0?
What is the main difference between Reports 2.0 & Reports 2.5?
What built-in routines are used to display editor dynamically?
What is the frame & repeating frame?
What is a predefined exception available in forms 4.0?
What are the types of calculated columns available?
What are the two ways to incorporate images into a oracle forms application?
Is the After report trigger fired if the report execution fails?
What is relation between the window and canvas views?
Does a grouping done for objects in the layout editor affect the grouping done in the datamodel editor?
What is a record Group?
Name of the functions used to get/set canvas properties?
What is the difference between setting up of parameters in reports 2.0 reports ?
Give the sequence of execution of the various report triggers?
What are the triggers associated with the image item?
How can a square be drawn in the layout editor of the report writer?
What is the difference when Flex mode is on and when it is off?
Explain about content canvas views?
What is a library in Forms 4.0?
To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?
What is the difference when confine mode is on and when it is off?
What does the term panel refer to with regard to pages?
If two groups are not linked in the data model editor, What is the hierarchy between them?
What are the two repeating frame always associated with matrix object?
What are the two types views available in the object navigator?
What is the built-in used for showing lov at runtime?
What is the use of hidden column?
How do you display console on a window ?
What is the use of break group?
What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?
How can a break order be created on a column in an existing group?
What is the use of place holder column?
Can a formula column be obtained through a select statement?
how to create title of reports that running from forms?