What are the Various Master and Detail Relation ships.

What are the Various Master and Detail Relation ships.
by

1 Answer

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.
by

Related questions

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 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)

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 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 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

What is relation between the window and canvas views?

Description : What is relation between the window and canvas views?

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

What is system catalog or catalog relation? How is better known as?

Description : What is system catalog or catalog relation? How is better known as?

Last Answer : A RDBMS maintains a description of all the data that it contains, information about every relation and index that it contains. This information is stored in a collection of relations maintained by the system called metadata. It is also called data dictionary.

What is degree of a Relation?

Description : What is degree of a Relation?

Last Answer : It is the number of attribute of its relation schema.

What is a Relation Schema and a Relation?

Description : What is a Relation Schema and a Relation?

Last Answer : A relation Schema denoted by R(A1, A2, …, An) is made up of the relation name R and the list of attributes Ai that it contains. A relation is defined as a set of tuples. Let r be the relation which contains set tuples (t1, t2, t3, …,tn). Each tuple is an ordered list of n-values t=(v1,v2, …, vn).

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

What is the use of break group? What are the various sub events a mouse double click event involves?

Description : What is the use of break group? What are the various sub events a mouse double click event involves?

Last Answer : A break group is used to display one record for one group ones. While multiple related records in other group can be displayed.

What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?

Description : What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?

Last Answer : Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.

What is an anchoring object & what is its use? What are the various sub events a mouse double click event involves?

Description : What is an anchoring object & what is its use? What are the various sub events a mouse double click event involves?

Last Answer : An anchoring object is a print condition object which used to explicitly or implicitly anchor other objects to itself.

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 various constraints used in SQL?

Description : What are various constraints used in SQL?

Last Answer : NULL -NOT NULL -CHECK -DEFAULT

What are various privileges that a user can grant to another user?

Description : What are various privileges that a user can grant to another user?

Last Answer : SELECT -CONNECT -RESOURCES

What are various joins used while writing SUBQUERIES?

Description : What are various joins used while writing SUBQUERIES?

Last Answer : Self join-Its a join foreign key of a table references the same table. Outer Join--Its a join condition used where One can query all the rows of one of the tables in the join condition even though ... in which one or more columns in one table are equal to one or more columns in the second table.

What are the various methods of performing a calculation in a report ?

Description : What are the various methods of performing a calculation in a report ?

Last Answer : 1. Perform the calculation in the SQL statements itself. 2. Use a calculated / summary column in the data model.

Give the sequence of execution of the various report triggers?

Description : Give the sequence of execution of the various report triggers?

Last Answer : Before form , After form , Before report, Between page, After report.

What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves?

Description : What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves?

Last Answer : Destype and Desname.

What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?

Description : What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?

Last Answer : Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.

What is the use of hidden column? What are the various sub events a mouse double click event involves?

Description : What is the use of hidden column? What are the various sub events a mouse double click event involves?

Last Answer : A hidden column is used to when a column has to embed into boilerplate text.

What is the use of place holder column? What are the various sub events a mouse double click event involves?

Description : What is the use of place holder column? What are the various sub events a mouse double click event involves?

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

How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?

Description : How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?

Last Answer : By dragging the column outside the group.

What are the various type of snapshots?

Description : What are the various type of snapshots?

Last Answer : Simple and Complex.

What do you call the measurement of various framework parts of the ships structure?

Description : What do you call the measurement of various framework parts of the ships structure?

Last Answer : Ano nga ba?

What do you understand by the term DOS: a) Downloading the system program from the Internet b) Downloading operating system c) The master control program of the computer which helps the computer to manage the files d) The programs which helps computer to check the various peripheral devices e) None of The Above

Description : What do you understand by the term DOS: a) Downloading the system program from the Internet b) Downloading operating system c) The master control program of the computer which helps the computer to ... d) The programs which helps computer to check the various peripheral devices e) None of The Above

Last Answer : e) None of The Above

…………………… is a schedule of various applications to be computerized. A) Materials planning B) Master development Plan C) Manufacturing organization D) None of the above

Description : …………………… is a schedule of various applications to be computerized. A) Materials planning B) Master development Plan C) Manufacturing organization D) None of the above

Last Answer : B) Master development Plan

State True or False. i) Master Development Plan basically is a schedule of various applications to be comprised. ii) It consists of start and finish dates of a system analysis, design implementation and maintenance activities. A) i-True, ii-True B) i-False, ii-True C) i-True, ii-False D) i-False, ii-False

Description : State True or False. i) Master Development Plan basically is a schedule of various applications to be comprised. ii) It consists of start and finish dates of a system analysis, design implementation and maintenance activities. ... B) i-False, ii-True C) i-True, ii-False D) i-False, ii-False

Last Answer : A) i-True, ii-True

A poll of students appearing for masters in engineering indicating that 60% of the students believed that mechanical engineering is a profession unsuitable for women. A research study on women with master or higher degrees in mechanical engineering found that 90% of such women were successful in their professions. Which of the following can be logically inferred from the above paragraph? (A) Many students have misconceptions regarding various engineering disciplines. (B) Men with advanced degrees in mechanical engineering believe women are well suited to be mechanical engineers. (C) Mechanical engineering is a profession well suited for women with masters or higher degrees in mechanical engineering. (D) The number of women pursing higher degrees in mechanical engineering is small.

Description : A poll of students appearing for masters in engineering indicating that 60% of the students believed that mechanical engineering is a profession unsuitable for women. A research study on women with ... engineering. (D) The number of women pursing higher degrees in mechanical engineering is small.

Last Answer : Correct option is (C). A poll says that women with masters or higher degrees in mechanical engineers are successful in their professions. This statement leads to the option (C) which is the best inference

1. What were the various reasons for hunter-gatherers to move from place to place? Mention in detail -History

Description : 1. What were the various reasons for hunter-gatherers to move from place to place? Mention in detail -History

Last Answer : Hunter-gatherers kept on moving from one place to another for the following reasons: (i) Staying at one place for a long time would have ended up the availability of plant and animal resources. (ii) ... in search of grass and leaves. That is why those who hunted them had to follow their movements.

Describe in detail various oral cavity tablet.

Description : Describe in detail various oral cavity tablet.

Last Answer : Oral cavity tablet:  i. Buccal Tablet. ii. Sublingual Tablet. iii. Lozenge tablet and tracheas. iv. Dental cones. 1] Buccal Tablet's - a. These tablets are to be placed in buccal pouch or ... Chloride or it may be amines acid. f. These cones generally get dissolved in 20 to 40 min time.

Explain various functions of PPC. in detail.

Description : Explain various functions of PPC. in detail.

Last Answer : Various functions of PPC Production Planning: This is the preliminary function of PPC in which planning of production activity is determined considering forecasting, market research, ... involves four stages namely observation, analysis, corrective action and post operation evaluation.

Name the various tools used in CNC turning centre. Explain any one in detail.

Description : Name the various tools used in CNC turning centre. Explain any one in detail.

Last Answer : Tools used on Turning Centre: 1. External Turning Tools: 2. Boring Bars:   3. Drills:   4. Threading Tools:   5. Parting Tools:   A. On the Basis of Cutting Tool Construction: ( ... (HCS). (c) Cast alloy. (d) Cemented carbide. (e) Ceramics. (f) Boron Nitride. (g) Diamond. 

List out various position sensors. Explain any one in detail.

Description : List out various position sensors. Explain any one in detail.

Last Answer : List : 1)Potentiometer 2) Eddy current sensorproximity sensor 3)Capacitive sensor 4)Hall effect sensor 5)Optical sensor/photo electric sensor 6)Inductive sensor Example :  Capacitive sensor: ... voltage which can be consider as error and actuator will move according to correct position. 

The relation among various mass transfer co-efficients (M.T.C) for ideal gases is given by (where, Kc & Km are M.T.C. for equimolar counter diffusion with concentration & mole fraction respectively as the driving force. and, Kp= M.T.C. for diffusion of a gas through a stagnant inert gas with pressure as driving force.) (A) Kc = Kp = Km (B) Kc = Kp /RT = Km . RT/P (C) Kc = Kp . RT = Km . RT/p (D) None of these

Description : The relation among various mass transfer co-efficients (M.T.C) for ideal gases is given by (where, Kc & Km are M.T.C. for equimolar counter diffusion with concentration & mole fraction respectively as the driving ... (C) Kc = Kp . RT = Km . RT/p (D) None of these

Last Answer : (C) Kc = Kp . RT = Km . RT/p

The relation connecting the fugacities of various components in a solution with one another and to composition at constant temperature and pressure is called the __________ equation. (A) Gibbs-Duhem (B) Van Laar (C) Gibbs-Helmholtz (D) Margules

Description : The relation connecting the fugacities of various components in a solution with one another and to composition at constant temperature and pressure is called the __________ equation. (A) Gibbs-Duhem (B) Van Laar (C) Gibbs-Helmholtz (D) Margules

Last Answer : (A) Gibbs-Duhem

What does "jumps off the screen" mean?

Description : What does "jumps off the screen" mean?

Last Answer : answer:AMD is a relatively small manufacturer but well established in the industry. In this context, AMD jumps off the screen at the guy doing the research into acquiring companies for ... chip manufacturing division, but AMD is the one that really stands out from an acquisition perspective.

How to add conditions in select statement in oracle?

Description : How to add conditions in select statement in oracle?

Last Answer : Just add the decode

How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Description : How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Last Answer : By connecting and spooling are you excluding the exp/imp commands (or expdb/impdb in 10g)?

What are the two ways to incorporate images into a oracle forms application?

Description : What are the two ways to incorporate images into a oracle forms application?

Last Answer : Boilerplate Images Image_items

Can one export a subset of a table? (for DBA

Description : Can one export a subset of a table? (for DBA

Last Answer : From Oracle8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table. Look at this example: exp scott/tiger tables=emp query=\"where deptno=10\"