221⟩ What is an object group?
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 other modules.
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
222⟩ What is an LOV?
An LOV is a scrollable popup window that provides the operator with either a single or multi column selection list.
223⟩ 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)
224⟩ What are the built-in used for getting cell values?
Get_group_char_cell(function) Get_groupcell(function) Get_group_number_cell(function)
225⟩ What are the built-ins used for Getting cell values?
GET_GROUP_CHAR_CELL (function) GET_GROUPCELL(function) GET_GROUP_NUMBET_CELL(function)
226⟩ Atleast how many set of data must a data model have before a data model can be base on it?
Four
227⟩ To execute row from being displayed that still use column in the row which property can be used?
Format trigger.
228⟩ What is the remove on exit property?
For a modeless window, it determines whether oracle forms hides the window automatically when the operators navigates to an item in the another window.
229⟩ 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 collection of user named procedures, functions and packages that can be called from other modules in the application
230⟩ What are the built-ins used for finding Object ID function?
FIND_GROUP(function) FIND_COLUMN(function)
231⟩ What is a difference between pre-select and pre-query?
Fires during the execute query and count query processing after oracle forms constructs the select statement to be issued, but before the statement is actually issued. The pre-query trigger fires just before oracle forms issues the select statement to the database after the operator as define the example records by entering the query criteria in enter query mode. Pre-query trigger fires before pre-select trigger.
232⟩ Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
False
233⟩ 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 and mouse up events.
234⟩ Use the Add_group_row procedure to add a row to a static record group 1. true or false?
False
235⟩ How can a break order be created on a column in an existing group?
By dragging the column outside the group.
236⟩ What is the use of break group?
A break group is used to display one record for one group ones. While multiple related records in other group can be displayed.
237⟩ What is the use of hidden column?
A hidden column is used to when a column has to embed into boilerplate text.
238⟩ What is an anchoring object and what is its use?
An anchoring object is a print condition object which used to explicitly or implicitly anchor other objects to itself.
239⟩ What is the use of place holder column?
A placeholder column is used to hold calculated values at a specified place rather than allowing is to appear in the actual row where it has to appear.
240⟩ What is WHEN-Database-record trigger?
Fires when oracle forms first marks a record as an insert or an update. The trigger fires as soon as oracle forms determines through validation that the record should be processed by the next post or commit as an insert or update. Generally occurs only when the operators modifies the first item in the record, and after the operator attempts to navigate out of the item.
