What are the different types of Record Groups?

What are the different types of Record Groups?
by

1 Answer

Answer :

Query Record Groups
NonQuery Record Groups
State Record Groups
by

Related questions

What are record groups ? * Can record groups created at run-time?

Description : What are record groups ? * Can record groups created at run-time?

Last Answer : A record group is an internal Oracle Forms data structure that has a column/row framework similar to a database table. However, unlike database tables, record groups are separate objects that belong to ... you define its structure and row values at design time, and they remain fixed at runtime.

Give built-in routine related to a record groups?

Description : Give built-in routine related to a record groups?

Last Answer : Create_group (Function) Create_group_from_query(Function) Delete_group(Procedure) 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)

What are the different type of a record group?

Description : What are the different type of a record group?

Last Answer : Query record group Static record group Non query record group

What are the different objects that you cannot copy or reference in object groups?

Description : What are the different objects that you cannot copy or reference in object groups?

Last Answer : Objects of different modules Another object groups Individual block dependent items Program units.

If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

Description : If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

Last Answer : Only for 10 records.

Use the add_group_column function to add a column to record group that was created at a design time?

Description : Use the add_group_column function to add a column to record group that was created at a design time?

Last Answer : False

What is a Query Record Group?

Description : What is a Query Record Group?

Last Answer : 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 ... rows retrieved by the query associated with that record group. What is a Non Query Record Group?

How many number of columns a record group can have?

Description : How many number of columns a record group can have?

Last Answer : 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.

What is Current record attribute property?

Description : What is Current record attribute property?

Last Answer : Specifies the named visual attribute used when an item is part of the current record. Current Record Attribute is frequently used at the block level to display the current row in a multi-record ... current record, but you cannot dynamically highlight the current item, as the input focus changes.

Use the ADD_GROUP_ROW procedure to add a row to a static record group? I) TRUE II)FALSE

Description : Use the ADD_GROUP_ROW procedure to add a row to a static record group? I) TRUE II)FALSE

Last Answer : I) FALSE

Use the ADD_GROUP_COLUMN function to add a column to a record group that was created at design time? I) TRUE II)FALSE

Description : Use the ADD_GROUP_COLUMN function to add a column to a record group that was created at design time? I) TRUE II)FALSE

Last Answer : II) FALSE

What is difference between % ROWTYPE and TYPE RECORD ?

Description : What is difference between % ROWTYPE and TYPE RECORD ?

Last Answer : % ROWTYPE is to be used whenever query returns a entire row of a table or view. TYPE rec RECORD is to be used whenever query returns columns of different table or views and variables. E.g. ... emp ename %type ); e_rec emp% ROWTYPE cursor c1 is select empno,deptno from emp; e_rec c1 %ROWTYPE.

What is a record Group?

Description : What is a record Group?

Last Answer : A record group is an internal oracle forms data structure that has a similar column/row frame work to a database table

What is a record Group?

Description : What is a record Group?

Last Answer : A record group is an internal oracle forms data structure that has a similar column/row frame work to a database table

What is the use of RECORD option in EXP command?

Description : What is the use of RECORD option in EXP command?

Last Answer : For Incremental exports, the flag indirects whether a record will be stores data dictionary tables recording the export.

What is the use of RECORD LENGTH option in EXP command ?

Description : What is the use of RECORD LENGTH option in EXP command ?

Last Answer : Record length in bytes.

What is a record group?

Description : What is a record group?

Last Answer : A record group is an internal Oracle Forms that structure that has 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.

What is a Static Record Group?

Description : What is a Static Record Group?

Last Answer : 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.

Use the Add_group_row procedure to add a row to a static record group 1. true or false?

Description : Use the Add_group_row procedure to add a row to a static record group 1. true or false?

Last Answer : False

What is WHEN-Database-record trigger?

Description : What is WHEN-Database-record trigger?

Last Answer : 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 ... the first item in the record, and after the operator attempts to navigate out of the item.

What is the Maximum allowed length of Record group Column?

Description : What is the Maximum allowed length of Record group Column?

Last Answer : Record group column names cannot exceed 30 characters.

If you update an assignment record multiple times in a single day, can you still track the record, if yes how?

Description : If you update an assignment record multiple times in a single day, can you still track the record, if yes how?

Last Answer : For some objects, such as assignments, more than one update per day is maintained by creating a physical record for each update. Such objects include an effective sequence number in each physical record to show the order in which updates made to an object on a single day were applied.

What are the primitive operations common to all record management systems?

Description : What are the primitive operations common to all record management systems?s?

Last Answer : Addition, deletion and modification.

What is Record-at-a-time?

Description : What is Record-at-a-time?

Last Answer : The Low level or Procedural DML can specify and retrieve each record from a set of records. This retrieve of a record is said to be Record-at-a-time.

How many minimum groups are required for a matrix report

Description : How many minimum groups are required for a matrix report

Last Answer : The minimum number of groups in matrix report are 4

What are the minimum number of groups required for a matrix report

Description : What are the minimum number of groups required for a matrix report

Last Answer : The minimum of groups required for a matrix report are 4 e

What are the built -ins used for Modifying a groups structure?

Description : What are the built -ins used for Modifying a groups structure?

Last Answer : ADD-GROUP_COLUMN (function) ADD_GROUP_ROW (procedure) DELETE_GROUP_ROW(procedure)

What are the built-ins used for Creating and deleting groups?

Description : What are the built-ins used for Creating and deleting groups?

Last Answer : CREATE-GROUP (function) CREATE_GROUP_FROM_QUERY(function) DELETE_GROUP(procedure)

Is it possible to link two groups inside a cross products after the cross products group has been created?

Description : Is it possible to link two groups inside a cross products after the cross products group has been created?

Last Answer : no

If two groups are not linked in the data model editor, What is the hierarchy between them?

Description : If two groups are not linked in the data model editor, What is the hierarchy between them?

Last Answer : Two group that is above are the left most rank higher than the group that is to right or below it.

What are the different types of segments?

Description : What are the different types of segments?

Last Answer : Data segment, index segment, rollback segment and temporary segment.

What are the different types of Coordinations of the Master with the Detail block?

Description : What are the different types of Coordinations of the Master with the Detail block?

Last Answer : POPULATE_GROUP(function) POPULATE_GROUP_WITH_QUERY(function) SET_GROUP_CHAR_CELL(procedure) SET_GROUPCELL(procedure) SET_GROUP_NUMBER_CELL(procedure)

What is a join ? Explain the different types of joins ?

Description : What is a join ? Explain the different types of joins ?

Last Answer : Join is a query which retrieves related columns or rows from multiple tables.Self Join - Joining the table with itself.Equi Join - Joining two tables by equating two common columns.Non-Equi Join - ... that query can also retrieve rows that do not have corresponding join value in the other table.

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Description : What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Last Answer : Procedures and Functions,Packages and Database Triggers.

What are the different types of windows?

Description : What are the different types of windows?

Last Answer : Root window, secondary window.

What are the different types of Package Procedure ?

Description : What are the different types of Package Procedure ?

Last Answer : 1. Restricted package procedure. 2. Unrestricted package procedure.

What are the different types of key triggers ?

Description : What are the different types of key triggers ?

Last Answer : Function Key Key-function Key-others Key-startup

What are different types of images?

Description : What are different types of images?

Last Answer : Boiler plate imagesImage Items

What are the different types of Delete details we can establish in Master-Details?

Description : What are the different types of Delete details we can establish in Master-Details?

Last Answer : Cascade Isolate Non-isolate

What are the different types of Delete details we can establish in Master-Details?

Description : What are the different types of Delete details we can establish in Master-Details?

Last Answer : Content canvas views Stacked canvas views Horizontal toolbar vertical toolbar.

What are different types of modules available in oracle form?

Description : What are different types of modules available in oracle form?

Last Answer : 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

What are the different Parameter types?

Description : What are the different Parameter types?

Last Answer : Text ParametersData Parameters

What are the different plan types available in Fusion Absence Management? Accrual

Description : What are the different plan types available in Fusion Absence Management?

Last Answer : There are three different plan types available in Fusion Absence Management, which are given below: Accrual Use this type to create absence plans that enable workers to accrue time for the ... plan to pay workers if they are not eligible for a standard maternity absence qualification plan.

What are the different types of JOIN operations?

Description : What are the different types of JOIN operations?

Last Answer : Equi Join: This is the most common type of join which involves only equality comparisions. The disadvantage in this type of join is that there

What are the types of visual attribute settings?

Description : What are the types of visual attribute settings?

Last Answer : Custom Visual attributes Default visual attributes Named Visual attributes. Window

What are the types of SQL Statement ?

Description : What are the types of SQL Statement ?

Last Answer : Data Definition Language : CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT.

How many types of Exceptions are there

Description : How many types of Exceptions are there

Last Answer : There are 2 types of exceptions. They are a) System Exceptions e.g. When no_data_found, When too_many_rows b) User Defined Exceptions e.g. My_exception exception When My_exception then

Give the two types of tables involved in producing a star schema and the type of data they hold.

Description : Give the two types of tables involved in producing a star schema and the type of data they hold.

Last Answer : Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.

What are the types of database links?

Description : What are the types of database links?

Last Answer : Private database link, public database link & network database link.

How many types of columns are there and what are they

Description : How many types of columns are there and what are they

Last Answer : Formula columns :: For doing mathematical calculations and returning one value Summary Columns :: For doing summary calculations such as summations etc. Place holder Columns :: These columns are useful for storing the value in a variable