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

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

1 Answer

Answer :

POPULATE_GROUP(function)
POPULATE_GROUP_WITH_QUERY(function)
SET_GROUP_CHAR_CELL(procedure)
SET_GROUPCELL(procedure)
SET_GROUP_NUMBER_CELL(procedure)
by

Related questions

What are Most Common types of Complex master-detail relationships?

Description : What are Most Common types of Complex master-detail relationships?

Last Answer : There are three most common types of complex master-detail relationships: master with dependent details master with independent details detail with two masters

What is a master detail relationship?

Description : What is a master detail relationship?

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

Which trigger are created when master -detail rela?

Description : Which trigger are created when master -detail rela?

Last Answer : master delete property * NON-ISOLATED (default) a) on check delete master b) on clear details c) on populate details * ISOLATED a) on clear details b) on populate details * CASCADE a) per-delete b) on clear details c) on populate details

What are the Various Master and Detail Relation ships.

Description : What are the Various Master and Detail Relation ships.

Last Answer : The various Master and Detail Relationship are a) NonIsolated :: The Master cannot be deleted when a child is exisiting b) Isolated :: The Master can be deleted when the child is exisiting c) Cascading :: The child gets deleted when the Master is deleted.

While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False. ?

Description : While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False. ?

Last Answer : True

What are the master-detail triggers?\

Description : What are the master-detail triggers?\

Last Answer : On Check_delete_masterOn_clear_detailsOn_populate_details

What are the Coordination Properties in a Master-Detail relationship?

Description : What are the Coordination Properties in a Master-Detail relationship?

Last Answer : The coordination properties are Deferred Auto-Query These Properties determine when the population phase of block coordination should occur

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 the different default triggers created when Master Deletes Property is set to Cascade?

Description : What are the different default triggers created when Master Deletes Property is set to Cascade?

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Cascading On-Clear-Details On-Populate-Details Pre-delete

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

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

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Isolated On-Clear-Details On-Populate-Details

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

Description : What are the different default triggers created when Master Deletes Property is set to Non-isolated?

Last Answer : Master Deletes Property Resulting Triggers ---------------------------------------------------- Non-Isolated(the default) On-Check-Delete-Master On-Clear-Details On-Populate-Details

Explain types of Block in forms4.0?

Description : Explain types of Block in forms4.0?

Last Answer : Base table Blocks. Control Blocks. 1. A base table block is one that is associated with a specific database table or view. 2. A control block is a block that is not associated with a database table. ITEMS

Mail agency master related to CRC means a) The mail agent of the mail office b) The mail guard of the agency branch c) It contains agencies detail of MMS & Sections for carrying bags closed in the CRC to other offices d) None of these

Description : Mail agency master related to CRC means a) The mail agent of the mail office b) The mail guard of the agency branch c) It contains agencies detail of MMS & Sections for carrying bags closed in the CRC to other offices d) None of these

Last Answer : c) It contains agencies detail of MMS & Sections for carrying bags closed in the CRC to other offices

A budgeting process which demands each manager to justify his entire budget in detail from beginning is A. Functional budget B. Master budget C. Zero base budgeting D. None of the above

Description : A budgeting process which demands each manager to justify his entire budget in detail from beginning is A. Functional budget B. Master budget C. Zero base budgeting D. None of the above

Last Answer : C. Zero base budgeting

Explain the difference between a data block, an extent and a segment.

Description : Explain the difference between a data block, an extent and a segment.

Last Answer : A data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks. These groupings ... that an object takes when grouped together are considered the segment of the database object.

How to define data block size?

Description : How to define data block size?

Last Answer : A data block size is specified for each Oracle database when the database is created. A database users and allocated free database space in Oracle data blocks. Block size is specified in init.ora file and cannot be changed latter.

What is data block?

Description : What is data block?

Last Answer : Oracle database's data is stored in data blocks. One data block corresponds to a specific number of bytes of physical database space on disk.

Can object group have a block?

Description : Can object group have a block?

Last Answer : Yes , object group can have block as well as program units.

What are the Various Block Coordination Properties

Description : What are the Various Block Coordination Properties

Last Answer : The various Block Coordination Properties are a) Immediate Default Setting. The Detail records are shown when the Master Record are shown. b) Deffered with Auto Query Oracle Forms defer fetching the ... No Auto Query The operator must navigate to the detail block and explicitly execute a query

What are the components of a PL/SQL block ?

Description : What are the components of a PL/SQL block ?

Last Answer : A set of related declarations and procedural statements is called block.

What are the components of a PL/SQL Block ?

Description : What are the components of a PL/SQL Block ?

Last Answer : Declarative part, Executable part and Exception part.Datatypes PL/SQL

Explain how procedures and functions are called in a PL/SQL block ?

Description : Explain how procedures and functions are called in a PL/SQL block ?

Last Answer : Function is called as part of an expression. sal := calculate_sal ('a822'); procedure is called as a PL/SQL statement calculate_bonus ('A822');

List the system variables related in Block and Field?

Description : List the system variables related in Block and Field?

Last Answer : 1. System.block_status 2. System.current_block 3. System.current_field 4. System.current_value 5. System.cursor_block 6. System.cursor_field 7. System.field_status.

Committed block sometimes refer to a BASE TABLE ?

Description : Committed block sometimes refer to a BASE TABLE ?

Last Answer : False

What does an on-clear-block Trigger fire?

Description : What does an on-clear-block Trigger fire?

Last Answer : It fires just before SQL * forms the current block.

What is Post-Block is a. ???

Description : What is Post-Block is a. ???

Last Answer : a. Navigational Trigger. b. Key trigger c. Transaction Trigger.

Can we use GO-BLOCK package in a pre-field trigger ?

Description : Can we use GO-BLOCK package in a pre-field trigger ?

Last Answer : No

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

Description : Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

Last Answer : a. ON-INSERT b. POST-INSERT c. PRE-INSERT

How does Space allocation table place within a block ?

Description : How does Space allocation table place within a block ?

Last Answer : Each block contains entries as follows Fixed block header Variable block header Row Header,row date (multiple rows may exists) PCTEREE (% of free space for row updation in future)

Which parameter in Storage clause will reduce no. of rows per block?

Description : Which parameter in Storage clause will reduce no. of rows per block?

Last Answer : PCTFREE parameter Row size also reduces no of rows per block.

What are the two phases of block coordination?

Description : What are the two phases of block coordination?

Last Answer : 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 ... with the new master record. These operations are accomplished through the execution of triggers.

What database block size should I use? (for DBA)

Description : What database block size should I use? (for DBA)

Last Answer : Oracle recommends that your database block size match, or be multiples of your operating system block size. One can use smaller block sizes, but the performance cost is significant. Your choice should ... 8K. This is because volume manager products use 8K blocks (and this is not configurable).

How to define Data Block size ?

Description : How to define Data Block size ?

Last Answer : A data block size is specified for each ORACLE database when the database is created. A database users and allocated free database space in ORACLE datablocks. Block size is specified in INIT.ORA file and can’t be changed latter.

What is Oracle Block? Can two Oracle Blocks have the same address?

Description : What is Oracle Block? Can two Oracle Blocks have the same address?

Last Answer : Oracle formats the database files into a number of Oracle blocks when they are first created-making it easier for the RDBMS software to manage the files and easier to read data into the memory areas ... at 1. Two blocks can have the same block address if they are in different database files.

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 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 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 types of Record Groups?

Description : What are the different types of Record Groups?

Last Answer : Query Record Groups NonQuery Record Groups State Record Groups

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

A partial denture that seats on the master cast but fails to seat correctly in the mouth is a result of, A. Contraction of the metal framework during casting B. Insufficient expansion of the investment material C. Distortion of impression D. Failure to block out unwanted undercuts

Description : A partial denture that seats on the master cast but fails to seat correctly in the mouth is a result of, A. Contraction of the metal framework during casting B. Insufficient expansion of the investment material C. Distortion of impression D. Failure to block out unwanted undercuts

Last Answer : C. Distortion of impression

Draw the block diagram of DM transmitter.Explain each block in detail.

Description : Draw the block diagram of DM transmitter.Explain each block in detail.

Last Answer : Block diagram of DM transmitter:-  Explanation:-  Sample and Hold:- The input analog is sampled and converted to PAM signal, which is compared with the output of the DAC. The output of the DAC ... counter is decremented, alogic 0 is transmitted.  (Waveform is optional):- OR

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