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.
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
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
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.
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)
Description : What are the master-detail triggers?\
Last Answer : On Check_delete_masterOn_clear_detailsOn_populate_details
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
Description : Can we create two blocks with the same name in form 3.0 ?
Last Answer : No
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.
Description : Is space acquired in blocks or extents ?
Last Answer : In extents
Description : What are the different types of Delete details we can establish in Master-Details?
Last Answer : Cascade Isolate Non-isolate
Last Answer : Content canvas views Stacked canvas views Horizontal toolbar vertical toolbar.
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
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
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
Description : The join defined by the default data link is an outer join yes or no?
Last Answer : Yes
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.
Description : What is a OUTER JOIN?
Last Answer : Outer Join--Its a join condition used where you can query all the rows of one of the tables in the join condition even though they don’t satisfy the join condition.
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
Description : Spurious tuples may occur due to i. Bad normalization ii. Theta joins iii. Updating tables from join a) i& ii b) ii & iii c) i& iii d) ii & iii
Last Answer : a) i& ii b) ii & iii
Description : Are the resulting relations of PRODUCT and JOIN operation the same?
Last Answer : No. PRODUCT: Concatenation of every row in one relation with every row in another. JOIN: Concatenation of rows from one relation and related rows from another
Description : What is join dependency and inclusion dependency?
Last Answer : Join Dependency: A Join dependency is generalization of Multivalued dependency.A JD {R1, R2, ,Rn} is said to hold over a relation R if R1, R2, R3, , Rn is a lossless-join ... columns of a relation are contained in other columns. A foreign key constraint is an example of inclusion dependency.
Description : What is Lossless join property?
Last Answer : It guarantees that the spurious tuple generation does not occur with respect to relation schemas after decomposition.
Description : Two popup pages can appear on the screen at a time ? Two popup pages can appear on the screen at a time ? a. True. b. False?
Last Answer : a. True.
Description : Use the ADD_GROUP_ROW procedure to add a row to a static record group? I) TRUE II)FALSE
Last Answer : I) 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
Description : System.effective_date system variable is read only True/False?
Last Answer : False
Description : Deleting a page removes information about all the fields in that page ? a. True. b. False?
Description : EXIT_FORM is a restricted package procedure ?a. True b. False
Last Answer : True
Description : Use the Add_group_row procedure to add a row to a static record group 1. true or false?
Description : What kind of argument is the following: "Raising the speed limit is like giving beer to an alcoholic." a) Faulty Cause-Effect Relationship b) False Analogy c) Ad Populum (Join the bandwagon) Argument d) Circular Reasoning e) None of the above
Last Answer : b) False Analogy
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
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
Description : s it possible to set a filter condition in a cross product group in matrix reports?
Description : . An independent relationship must exist between the attribute that can be measured and the external quality attribute. a) True b) False
Last Answer : b) False
Description : An independent relationship must exist between the attribute that can be measured and the external quality attribute. a) True b) False
Description : An independent relationship must exist between the attribute that can be measured and the external quality attribute. (A) True (B)False
Last Answer : (B)False
Description : To determine whether one's leadership style is task- or relationship-oriented, the leader must fill in the Least Coworker Participation (LCP) scale. (a) True ; (b) False
Last Answer : (b) False
Description : Explain the relationship among Database, Tablespace and Data file.?
Last Answer : Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace
Description : Explain the relationship among database, tablespace and data file.
Last Answer : Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace.
Description : A dominant entity is the entity a) on the N side in a 1 : N relationship b) on the 1 side in a 1 : N relationship c) on either side in a 1 : 1 relationship d) nothing to do with 1 : 1 or 1 : N relationship
Last Answer : d) nothing to do with 1 : 1 or 1 : N relationship
Description : What is degree of Relationship type?
Last Answer : It is the number of entity type participating.
Description : What is Relationship type?
Last Answer : Relationship type defines a set of associations or a relationship set among a given set of entity types.
Description : What is Relationship set?
Last Answer : The collection (or set) of similar relationships.
Description : What is Relationship?
Last Answer : It is an association among two or more entities.
Description : While making the payment of amount which is due for civil work to government agencies , the full amount can be paid The above statement is a. True b. False c. Subject condition and considering the circumstance , the advance payment of full amount shall be drawn
Last Answer : c. Subject condition and c
Description : Which algorithm places two actions into a plan without specifying which should come first? a) Full-order planner b) Total-order planner c) Semi-order planner d) Partial-order planner
Last Answer : d) Partial-order planner
Description : Find the false statement: (A) The relationship construct known as the weak relationship type was defined by Dey, Storey & Barron (1999). (B) A weak relationship occurs when two ... Ternary, Quaternary and Quintary relationships are shown through a series of application scenario's and vignette's
Last Answer : (C) Conceptual model is not accurate representation of "Universe of interest".
Description : What’s you horribly misinterpreted plot/story review for a movie, but without specifying the movie?
Last Answer : “Old woman holds a baby she fucked 27 years prior”