181⟩ Can a repeating frame be created without a data group as a base?
A repeating frame ca not be created without a data group as a base
Database Administrator (DBA)
Home Databases Programming Database Administrator (DBA)
“If you a Database Administrator and need to update DBA technical knowledge or need to prepare for a job interview? Then you are at eht right place explore this collection of DATABASE Administrator (DBA) Interview Questions and Answers here. This DBA Interview Questions and Answers are basic and advance level so every one who is DBA can get more help with these database interview questions and answers tutorial and guide.”
253 Database Administrator (DBA) Questions And Answers
182⟩ What are the two repeating frame always associated with matrix object?
One down repeating frame below one across repeating frame.
183⟩ Is it possible to link two groups inside a cross products after the cross products group has been created?
Not possible.
184⟩ What are the difference between lov & list item?
Lov is a property where as list item is an item. A list item can have only one column, lov can have one or more columns.
185⟩ What is the advantage of the library?
Libraries provide a convenient means of storing client-side program units and sharing them among multiple applications. Once you create a library, you can attach it to any other form, menu, or library modules. When you can call library program units from triggers menu items commands and user named routine, you write in the modules to which you have attach the library. When a library attaches another library, program units in the first library can reference program units in the attached library. Library support dynamic loading-that is library program units are loaded into an application only when needed. This can significantly reduce the run-time memory requirements of applications.
186⟩ What is lexical reference?
How can it be created? - Lexical reference is place_holder for text that can be embedded in a SQL statements. A lexical reference can be created using & before the column or parameter name.
187⟩ What is the diff. bet. setting up of parameters in reports 2.0 reports2.5?
LOVs can be attached to parameters in the reports 2.5 parameter form.
188⟩ What is system.coordination_operation?
It represents the coordination causing event that occur on the master block in master-detail relation.
189⟩ What is synchronize?
It is a terminal screen with the internal state of the form. It updates the screen display to reflect the information that oracle forms has in its internal representation of the screen.
190⟩ What is a Text_io Package?
It allows you to read and write information to a file in the file system.
191⟩ What use of command line parameter cmd file?
It is a command line argument that allows you to specify a file that contain a set of arguments for r20run.
192⟩ How is link tool operation different bet. reports 2 & 2.5?
In Reports 2.0 the link tool has to be selected and then two fields to be linked are selected and the link is automatically created. In 2.5 the first field is selected and the link tool is then used to link the first field to the second field.
193⟩ What are the different styles of activation of ole Objects?
In place activation, External activation
194⟩ What is forms_DDL?
Issues dynamic Sql statements at run time, including server side pl/SQl and DDL
195⟩ 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
196⟩ What are the different modals of windows?
Modeless windows Modal windows
197⟩ What is the difference between object embedding and 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.
198⟩ Name of the functions used to get/set canvas properties?
Get_view_property, Set_view_property
199⟩ What are the built-ins that are used for setting the LOV properties at runtime?
get_lov_property set_lov_property
200⟩ 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)
