Welcome to www.programmer2programmer.net tips for IT Interview Questions of Oracle Forms 4.5

programmer2programmer.net

 Tips
 Microsoft Certification
 Final Year Project Idea
 Connection Strings
 Password Recovery
 SQL Injection
 Encryption & Decryption
  
 LIVE Academic Project
 Project #1 - VB6, Access
  Project #2 - VB.Net, SQL
 Project #3 - ASP, Access
 Project #4 - ASP.NET, C#
 Project #5 - VB6, SQL
 Project #6 - Stegano
 Project #7 - C
 Project #8 - C++
 Project #9 - JAVA, MySQL
 Project #10- PHP, MySQL
 Project #11- JSP, Oracle
 Project #12- C# Face Exp
 Project #13- Mobile Bank
 Download MBA Project
 MBA Project Topic
 Project Viva Question
  2017 New Projects
 Project Synopsis Download
  
 University Question Paper, Assignment and Projects
 SMU - Question Paper
 SMU - Assignment
 SMU - Synopsis Projects
 SCDL - Assignment
 IGNOU - Synopsis Projects
 Welingkar - Projects
 Project Report Formats
  
 Interview Question Answer
 General & HR Round
 Visual Basic 6
 VB.Net & C#
 ASP.Net
 SQL Server
  Oracle and DBA
 My SQL
  

100% Tested
Ready Academic IT Projects

BE, ME, BTech, BCA, MCA, MBA, Bsc-IT, MS, BIT, ADIT, DOEACC, IGNOU, SMU
readymadeproject.com

 Interview questions and Answers for Oracle D2k Forms 4.5

Home Personal Member Forum Source Project Tips Contact
 

Interview Question > Oracle

Oracle Forms 4.5  Interview Questions and Answers

Interview questions and answers for Oracle Forms 4.5  Interview Questions and Answers

Oracle Forms 4.5 Interview Questions and Answers includes, object groups, canvas views, canvas properties, different modals of windows, display console on a window, remove on exit property, different types of modules available in oracle form, master detail relationship, coordination types of Complex master-detail relationships, User-Named Editor, Built-ins, LOV of Validation, record group, Record group Column, Query Record Group, Non Query Record Group, Static Record Group, parameters,

Interview Question, Answer
1.  Programming General
2.  Web General
3.  Database General
4.  Visual Basic 6
5.  ASP
6.  Visual Basic .NET and C#
7.  ASP .NET
8.  ORACLE
9.  MS SqlServer
10. MySql
11. COM, DCOM
1. What is an object groups?
An object group is a container for a group of objects, you define an object group when you want to package related objects. so that you copy or reference them in another modules.
 
2. What are the different objects that you cannot copy or reference in object groups?
objects of differnt modules
another object groups
individual block dependent items
program units.
 
3. What are different types of canvas views?
Content canvas views
Stacked canvas views
horizontal toolbar
Vertical toolbar.
 
4. Explain about content canvas views?
Most Canvas views are content canvas views a content canvas view is the "base" view that occupies the entire content pane of the window in which it is displayed.
 
5. Explain about stacked canvas views?
Stacked canvas view is displayed in a window on top of, or "stacked" on the content canvas view assigned to that same window. Stacked canvas views obscure some part of the underlying content canvas view, and or often shown and hidden programmatically.
 
6. Explain about horizontal, vertical tool bar canvas views?
Tool bar canvas views are used to create tool bars for individual windows
Horizontal tool bars are display at the top of a window, just under its menu bar.
Vertical Tool bars are displayed along the left side of a window
 
7. Name of the functions used to get/set canvas properties?
Get_view_property, Set_view_property
 
8. What is relation between the window and canvas views?
Canvas views are the back ground objects on which you place the interface items (Text items), check boxes, radio groups etc.,) and boilerplate objects (boxes, lines, images etc.,) that operators interact with us they run your form. Each canvas views displayed in a window.
 
9. What are the different modals of windows?
Modalless windows
Modal windows
 
10. What are modalless windows?
  More than one modelless window can be displayed at the same time, and operators can navigate among them if your application allows them to do so . On most GUI platforms, modelless windows can also be layered to appear either in front of or behind other windows.
 
11. What are modal windows?
  Modal windows are usually used as dialogs, and have restricted functionality compared to modelless windows. On some platforms for example operators cannot resize, scroll or iconify a modal window.
 
12. How do you display console on a window?
  The console includes the status line and message line, and is displayed at the bottom of the window to which it is assigned.
To specify that the console should be displayed, set the console window form property to the name of any window in the form. To include the console, set console window to Null.
 
13. What is the remove on exit property?
  For a modelless window, it determines whether oracle forms hides the window automatically when the operators navigates to an item in the another window.
 
14. How many windows in a form can have console?
  Only one window in a form can display the console, and you cannot chage the console assignment at runtime.
15. Can you have more than one content canvas view attached with a window?
Yes.
Each window you create must have atleast one content canvas view assigned to it. You can also create a window that has manipulate contant canvas view. At run time only one of the content canvas views assign to a window is displayed at a time.
 
16. What is the different window events activated at runtimes?
When_window_activated
When_window_closed
When_window_deactivated
When_window_resized
Within this triggers, you can examine the built in system variable system.event_window to determine the name of the window for which the trigger fired.
 
17. What are different types of modules available in oracle form?
Form module - a collection of objects and code routines
Menu modules - a collection of menus and menu item commands that together make up an application menu
Library module - a collectio of user named procedures, functions and packages that can be called from other modules in the application
 
18. What are the default extensions of the files careated by forms modules?
.fmb - form module binary
.fmx - form module executable
 
19. What are the default extentions of the files created by menu module?
  .mmb, .mmx
 
20. What is the default extension of the files created by library module?
The default file extensions indicate the library module type and storage format
.pll - pl/sql library module binary
 
21. What is a master detail relationship?
A master detail relationship is an association between two base table blocks- a master block and a detail block. The relationship between the blocks reflects a primary key to foreign key relationship between the tables on which the blocks are based.
 
22. What is coordination Event?
Any event that makes a different record in the master block the current record is a coordination causing event.
 
23. What are the two phases of block coordination?
  There are two phases of block coordination: the clear phase and the population phase. During, the clear phase, Oracle Forms navigates internally to the detail block and flushes the obsolete detail records. During the population phase, Oracle Forms issues a SELECT statement to repopulate the detail block with detail records associated witjh the new master record. These operations are accomplished through the execution of triggers.
 
24. What are Most Common types of Complex master-detail relationships?
  There are three most common types of complex master-detail relationships:
Master with dependent details
master with independent details
Detail with two masters
 
25. What are the different types of Delete details we can establish in Master-Details?
Cascade
Isolate
Non-isolote
 
26. What are the different defaust triggers created when Master Deletes Property is set to Non-isolated?
Master Delets Property Resulting Triggers
----------------------------------------------------
Non-Isolated (the default) On-Check-Delete-Master
On-Clear-Details
On-Populate-Details

What is the different default triggers created when Master Deletes Property is set to Cascade?
Ans: Master Deletes Property Resulting Triggers
---------------------------------------------------
Cascading On-Clear-Details
On-Populate-Details
Pre-delete

What is the different default triggers created when Master Deletes Property is set to isolated?

Master Deletes Property Resulting Triggers
--------------------------------------------------- Isolated On-Clear-Details
On-Populate-Details
 
27. What are the Coordination Properties in a Master-Detail relationship?
The coordination properties are
Deferred
Auto-Query
These Properties determine when the population phase of block coordination should occur.
 
28. What is the User-Named Editor?
A user named editor has the same text editing functionality as the default editor, but, becaue it is a named object, you can specify editor attributes such as windows display size, position, and title.
 
29. What are the Built-ins to display the user-named editor?
  A user named editor can be displayed programmatically with the built in procedure SHOW-EDITOR, EDIT_TETITEM independent of any particular text item.
30. What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?
  Show editor is the generic built_in which accepts any editor name and takes some input string and returns modified output string. Whereas the edit_textitem built_in needs the input focus to be in the text item before the built_in is excuted.
 
31. What is an LOV?
  An LOV is a scrollable popup window that provides the operator with either a single or multi column selection list.
 
32. What is the basic data structure that is required for creating an LOV?
Record Group.
 
33. What is the "LOV of Validation" Property of an item? What is the use of it?
  When LOV for Validation is set to True, Oracle Forms compares the current value of the text item to the values in the first column displayed in the LOV.
Whenever the validation event occurs.
If the value in the text item matches one of the values in the first column of the LOV, validation succeeds, the LOV is not displayed, and processing continues normally.
If the value in the text item does not match one of the values in the first column of the LOV, Oracle Forms displays the LOV and uses the text item value as the search criteria to automatically reduce the list.
 
34. What are the built_ins used the display the LOV?
  Show_lov
List_values
 
35. What are the built-ins that are used to Attach an LOV programatically to an item?
  set_item_property
get_item_property
(by setting the LOV_NAME property)
 
36. What are the built-ins that are used for setting the LOV properties at runtime?
  get_lov_property
set_lov_property
 
37. What is a record group?
  A record group is an internal Oracle Forms that structure that hs a column/row framework similar to a database table. However, unlike database tables, record groups are separate objects that belong to the form module which they are defined.
 
38. How many numbers of columns a record group can have?
  A record group can have an unlimited number of columns of type CHAR, LONG, NUMBER, or DATE provided that the total number of column does not exceed 64K.
 
39. What is the Maximum allowed length of Record group Column?
Record group column names cannot exceed 30 characters.
 
40. What are the different types of Record Groups?
  Query Record Groups
NonQuery Record Groups
State Record Groups
 
41. What is a Query Record Group?
  A query record group is a record group that has an associated SELECT statement. The columns in a query record group derive their default names, data types, had lengths from the database columns referenced in the SELECT statement. The records in query record group are the rows retrieved by the query associated with that record group.
 
42. What is a Non Query Record Group?
  A non-query record group is a group that does not have an associated query, but whose structure and values can be modified programmatically at runtime.
 
43. What is a Static Record Group?
  A static record group is not associated with a query, rather, you define its structure and row values at design time, and they remain fixed at runtime.
 
44. What are the built-ins used for Creating and deleting groups?
  CREATE-GROUP (function)
CREATE_GROUP_FROM_QUERY (function)
DELETE_GROUP (procedure)
 
45. What are the built -ins used for Modifying a group's structure?
  ADD-GROUP_COLUMN (function)
ADD_GROUP_ROW (procedure)
DELETE_GROUP_ROW (procedure)
POPULATE_GROUP (function)
POPULATE_GROUP_WITH_QUERY (function)
SET_GROUP_CHAR_CELL (procedure)
SET_GROUP_DATE_CELL (procedure)
SET_GROUP_NUMBER_CELL (procedure)
 
46. What are the built-ins used for getting cell values?
  GET_GROUP_CHAR_CELL (function)
GET_GROUP_DATE_CELL (function)
GET_GROUP_NUMBET_CELL (function)
 
47. What are built-ins used for processing rows?
   GET_GROUP_ROW_COUNT (function)
GET_GROUP_SELECTION_COUNT (function)
GET_GROUP_SELECTION (function)
RESET_GROUP_SELECTION (procedure)
SET_GROUP_SELECTION (procedure)
UNSET_GROUP_SELECTION (procedure)
 
48. What are the built-ins used for finding Object ID function?
  FIND_GROUP (function)
FIND_COLUMN (function)
 
49. Use the ADD_GROUP_COLUMN function to add a column to a record group that was created at design time.
I) TRUE II)FALSE
FALSE
 
50. Use the ADD_GROUP_ROW procedure to add a row to a static record group

I) TRUE II)FALSE
FALSE
 
51. What are the built-in used for getting cell values?
  Get_group_char_cell(function)
Get_group_date_cell(function)
Get_group_number_cell(function)
 
52. What are the built-ins used for processing rows?
  Get_group_row_count(function)
Get_group_selection_count(function)
Get_group_selection(function)
Reset_group_selection(procedure)
Set_group_selection(procedure)
Unset_group_selection(procedure)
 
53. What are the built-ins used for finding object ID functions?
  Find_group(function)
Find_column(function)
 
54. Use the add_group_column function to add a column to record group that was created at a design time?
False.
 
55. Use the Add_group_row procedure to add a row to a static record group 1. true or false?
False.
 
56. What are parameters?
  Parameters provide a simple mechanism for defining and setting the values of inputs that are required by a form at startup. Form parameters are variables of type char,number,date that you define at design time.
 
57. What are the Built-ins used for sending Parameters to forms?
  You can pass parameter values to a form when an application executes the call_form, New_form, Open_form or Run_product.
 
58. What is the maximum no of chars the parameter can store?
  The maximum no of chars the parameter can store is only valid for char parameters, which can be upto 64K. No parameters default to 23Bytes and Date parameter default to 7Bytes.
 
59. How do you call other Oracle Products from Oracle Forms?
  Run_product is a built-in, Used to invoke one of the supported oracle tools products and specifies the name of the document or module to be run. If the called product is unavailable at the time of the call, Oracle Forms returns a message to the opertor.
 
60. How do you reference a Parameter?
  In Pl/Sql, You can reference and set the values of form parameters using bind variables syntax. Ex. PARAMETER name = '' or: block.item = PARAMETER Parameter name
 
61. How do you reference a parameter indirectly?
  To indirectly reference a parameter use the NAME IN, COPY 'built-ins to indirectly set and reference the parameters value' Example name_in ('capital parameter my param'), Copy ('SURESH','Parameter my_param')
 
62. What are the different Parameter types?
  Text Parameters
Data Parameters
 
63. When do you use data parameter type?
  When the value of a data parameter being passed to a called product is always the name of the record group defined in the current form. Data parameters are used to pass data to produts invoked with the run_product built-in subprogram.
 
64. Can you pass data parametrs to forms?
No.
 
65. What are different types of images?
  Boiler plate images
Image Items
 
66. What is the difference between boiler plat images and image items?
  Boiler plate Images are static images (Either vector or bit map) that you import from the file system or database to use a grapical elements in your form, such as company logos and maps Image items are special types of interface controls that store and display either vector or bitmap images. Llike other items that store values, image items can be either base table items(items that relate directly to database columns) or control items. The definition of an image item is stored as part of the form module FMB and FMX files, but no image file is actualy associated with an image item until the item is populate at run time.
 
67. What are the trigger associated with image items?
  When-image-activated fires when the operators double clicks on an image item when-image-pressed fires when an operator clicks or double clicks on an image item
 
68. What is the use of image_zoom built-in?
To manipulate images in image items.
 
69. How do you create a new session while open a new form?
  Using open_form built-in setting the session option Ex. Open_form('Stocks ',active,session). when invoke the mulitiple forms with open form and call_form in the same application, state whether the following are true/False
 
70. Any attempt to navigate programatically to disabled form in a call_form stack is allowed?
False
 
71. An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?
True
 
72. When a form is invoked with call_form, Does oracle forms issues a save point?
True
 
73. What are the various sub events a mouse double click event involves?
  Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.
 
74. State any three mouse events system variables?
  System.mouse_button_pressed
System.mouse_button_shift_state
system.mouse_item
system.mouse_canvas
system.mouse_record
 
75. What is an OLE?
  Object Linking & Embadding provides you with the capability to integrate objects from many Ms-Windows applications into a single compound document creating integrated applications enables you to use the features form .
 
76. What is the difference between object embedding & linking in Oracle forms?
  In Oracle forms, Embedded objects become part of the form module, and linked objects are references from a form module to a linked source file.
 
77. What is the difference between OLE Server & Ole Container?
  An Ole server application creates ole Objects that are embedded or linked in ole Containers ex. Ole servers are ms_word & ms_excell. OLE containers provide a place to store, display and manipulate objects that are created by ole server applications. Ex. oracle forms are an example of an ole Container.
 
78. What are the different styles of actvation of ole Objects?
  In place activation
External activation

Next  MS SqlServer      Go back to Interview Question Main

(C) Atanu Maity, 2006-2017