- How to create LOV in Oracle forms
- In what situation you create the BPA
- What is 4-way match
- How you define procure to pay
- What is user exit
- How do you give the list of values in bind parameter
- How to create placeholder columns
- What are the types of trigger actions
- How cost of one Form created & Report Created
- What is the difference between formula column and place holder
- What is integrity and how many integrity rules are there
- What are differences between global and context sensitive segments
- 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
- What is the usage of frame
- What is the use of Page Protect Property
- What is the type of triggers available in Oracle Reports
- 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
- Where we can use the placeholder columns
- What is the sequence the Report triggers will fires while running a report
- What is all the system Parameters available in ORACLE Reports
- 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
- How do you run SQL loader
- How can you store a picture file in oracle database? Explain the path/command
- Can you convert a bit-mapped report to ASCII Report? How
- Where do you define the select statement of the parameter
- Can you mention lexical parameter in select statement in the data model
- Can we send the control file path as a parameter
- What you write in Ctl file
- How to load data into base tables
- Can we write commit in before report trigger
- Can my report have different layouts
- What are difference between repeating frame and frame
- What are 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 SQL query in reports
- If you develop report do u ask for anything from u r team leader
- What is bit map and character mode
- What is procedure like symbols of bind and lexical
- If you have one group can you create another from that
- What are the various types of reports
- 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
- What is the use of break group
- How do you display console on a window
- What is the use of hidden column
- What are the two types views available in the object navigator
- What are the two repeating frame always associated with matrix object
- Where do you put the report file
- What exactly you write in when_new_form_instance
- If you want to delete all these detail block etc what will happen in form
- 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
- What is AppCore and AppCore2
- Can a single canvas be used by different blocks
- What is the order of the triggers fired once the form is opened
- Is it possible to attach same library to more than one form
- 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
- What built-in is used for showing the alert during run-time
- What are the built-in routines is available in forms 4.0 to create and manipulate
- 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 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 master-detail triggers
- What is WHEN-Database-record trigger
- What is the difference between lov & list item
- What is system.coordination_operation
- What is the difference between $$DATE$$ & $$DBDATE$$
- What is forms_DDL
- What is synchronizing
- 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
- Can you pass data parameters to forms
- What are different types of images
- When do you use data parameter type
- What are the different Parameter types
- How do you reference a parameter indirectly
- 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 finding object ID functions
- What are the Built-ins used for sending Parameters to forms
- 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 is the Maximum allowed length of Record group Column
- What are the different types of Record Groups
- How many number of columns a record group can have
- What are the default extensions 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
- What is a master detail relationship
- What is coordination Event
- What are Most Common types of Complex master-detail relationships
- What are the two phases of block coordination
- What are the different types of Delete details we can establish in Master-Details
- What are the different default triggers created when Master Deletes Property is set
- What are the different default triggers created when Master Deletes Property is set
- What are the Coordination Properties in a Master-Detail relationship
- What are the different types of Co-ordinations of the Master with the Detail block
- What is the User-Named Editor
- What are the Built-ins to display the user-named editor
- What is the difference between SHOW_EDITOR and EDIT_TEXTITEM
- What is the basic data structure that is required for creating an LOV
- What is the "LOV of Validation" Property of an item? What is the use of it
- What are the built-ins that are used for setting the LOV properties at runtime
- Use the Add_group_row procedure to add a row to a static record group
- What are the display styles of an alert
- Can you attach an alert to a field
- What is the remove on exit property
- What is the content view and stacked view
- What are the types of canvas-views
- How many windows in a form can have console
- List the built-in routines for the controlling canvas views during run-time
- 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 is the purpose of the product order option in the column property sheet
- How can a button be used in a report to give a drill down facility
- Where is the external query executed at the client or the server
- What are the default parameter that appear at run time in the parameter screen
- Which parameter can be used to set read level consistency across multiple queries
- What use of command line parameter cmd file
- Where is a procedure return in an external PL/SQL library executed at the client
- What is term? What is use of term
- What are the two ways by which data can be generated for a parameter's Using static
- Which function of summary item is the compute at options required
- What is bind reference and how can it be created
- Is it possible to disable the parameter from while running the report
- 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
- Can Two popup pages can appear on the screen at a time
- What is the difference between system.current_field and system.cursor_field
- List the system variables related in Block and Field
- What is the difference between NAME_IN and COPY
- What SYNCHRONIZE procedure does
- What are the different types of Package Procedure
- What ERASE package procedure does
- How the command POST does differ from COMMIT
- What the PAUSE package procedure does
- What package procedure is used for calling another form
- What package procedure used for invokes sql plus from SQL forms
- Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger
- What is the difference between restricted and unrestricted package procedure
- What is a Package Procedure
- What is Post-Block
- What is the difference between key startup and pre-form
- What Enter package procedure does
- When does an on-lock trigger fire
- How can you execute the user defined triggers in forms 3.0
- Is a Key startup 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 are the unrestricted procedures used to change the popup screen position during
- 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
- When will ON-VALIDATE-FIELD trigger executed
- What is the usage 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
- Can we create two blocks with the same name in form 3.0
- What is an SQL FORMS
- What is the maximum size of a form
- How do you control the constraints in 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
- Which of the two views should objects according to possession
- What are modeless windows