What is Lossless join property?

What is Lossless join property?
by

1 Answer

Answer :

It guarantees that the spurious tuple generation does not occur with respect to relation  schemas after decomposition.
by

Related questions

The relation schemas R1 and R2 form a Lossless join decomposition of R if and only if: (a) R1⋂R2→(R1-R2) (b) R1→R2 (c) R1⋂R2→(R2-R1) (d) R2→R1⋂R2 (A) (a) and (b) happens (B) (a) and (d) happens (C) (a) and (c) happens (D) (b) and (c) happens

Description : The relation schemas R1 and R2 form a Lossless join decomposition of R if and only if: (a) R1⋂R2→(R1-R2) (b) R1→R2 (c) R1⋂R2→(R2-R1) (d) R2→R1⋂R2 (A) (a) and (b) happens (B) (a) and (d) happens (C) (a) and (c) happens (D) (b) and (c) happens

Last Answer : (C) (a) and (c) happens 

Consider a schema R(MNPQ) and functional dependencies M→N, P→Q. Then the decomposition of R into R1(MN) and R2(PQ) is ............. (1) Dependency preserving but not lossless join. (2) Dependency preserving and lossless join (3) Lossless join but not dependency preserving (4) Neither dependency preserving nor lossless join.

Description : Consider a schema R(MNPQ) and functional dependencies M→N, P→Q. Then the decomposition of R into R1(MN) and R2(PQ) is ............. (1) Dependency preserving but not lossless ... and lossless join (3) Lossless join but not dependency preserving (4) Neither dependency preserving nor lossless join. 

Last Answer : Answer: 1

The join defined by the default data link is an outer join yes or no?

Description : The join defined by the default data link is an outer join yes or no?

Last Answer : Yes

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 is a OUTER JOIN?

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.

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

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

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

Are the resulting relations of PRODUCT and JOIN operation the same?

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

What is join dependency and inclusion dependency?

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.

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.

What is OLE Activation style property?

Description : What is OLE Activation style property?

Last Answer : Specifies the event that will activate the OLE containing item.

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.

Diff. between VAT and Property Class? imp

Description : Diff. between VAT and Property Class? imp

Last Answer : Named visual attributes define only font, color, and pattern attributes; property classes can contain these and any other properties. You can change the appearance of objects at runtime by ... visual attribute settings take precedence, and any visual attribute properties in the class are ignored.

What is transactional trigger property?

Description : What is transactional trigger property?

Last Answer : Identifies a block as transactional control block. i.e. non - database block that oracle forms should manage as transactional block.(NON- ORACLE datasource) default - FALSE.

What is mouse navigate property of button?

Description : What is mouse navigate property of button?

Last Answer : When Mouse Navigate is True (the default), Oracle Forms performs standard navigation to move the focus to the item when the operator activates the item with the mouse. When Mouse Navigate is set ... the resulting validation) to move to the item when an operator activates the item with the mouse.

If you have property class attached to an item and you have same trigger written for the item . Which will fire first?

Description : If you have property class attached to an item and you have same trigger written for the item . Which will fire first?

Last Answer : Item level trigger fires , If item level trigger fires, property level trigger won't fire. Triggers at the lowest level are always given the first preference. The item level trigger fires first and then the block and then the Form level trigger.

What are property classes ? Can property classes have trigger?

Description : What are property classes ? Can property classes have trigger?

Last Answer : Property class inheritance is a powerful feature that allows you to quickly define objects that conform to your own interface and functionality standards. Property classes also allow you to make global ... all objects that inherit properties from that class. Yes . All type of triggers .

What is SECURE property?

Description : What is SECURE property?

Last Answer : Hides characters that the operator types into the text item. This setting is typically used for password protection.

What is a property clause?

Description : What is a property clause?

Last Answer : A property clause is a named object that contains a list of properties and their settings. Once you create a property clause you can base other object on it. An object based on a property can inherit the setting of any property in the clause that makes sense for that object.

How is it possible to select generate a select set for the query in the query property sheet?

Description : How is it possible to select generate a select set for the query in the query property sheet?

Last Answer : By using the tables/columns button and then specifying the table and the column names.

What is the remove on exit property?

Description : What is the remove on exit property?

Last Answer : For a modelless window, it determines whether oracle forms hides the window automatically when the operators navigates to an item in the another window.

To execute row from being displayed that still use column in the row which property can be used?

Description : To execute row from being displayed that still use column in the row which property can be used?

Last Answer : Format trigger.

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 the purpose of the product order option in the column property sheet?

Description : What is the purpose of the product order option in the column property sheet?

Last Answer : To specify the order of individual group evaluation in a cross products.

What is the "LOV of Validation" Property of an item? What is the use of it?

Description : What is the "LOV of Validation" Property of an item? What is the use of it?

Last Answer : When LOV for Validation is set to True, Oracle Forms compares the current value of the text item to the values in the first column displayed in the LOV. Whenever the validation event occurs. If ... the LOV and uses the text item value as the search criteria to automatically reduce the list.

What are the sql clauses supported in the link property sheet?

Description : What are the sql clauses supported in the link property sheet?

Last Answer : Where start with having.

Can a property clause itself be based on a property clause?

Description : Can a property clause itself be based on a property clause?

Last Answer : Yes

From a technical point of view, which is the better movie release in terms of lossless audio/video quality between YIFY and AAC-RARBG?

Description : From a technical point of view, which is the better movie release in terms of lossless audio/video quality between YIFY and AAC-RARBG?

Last Answer : Both are kinda shit to be honest. But if I had to pick I would go with RARBG. Both are nowhere close to lossless.

What is the "best" lossless compression format for compression+archive formats?

Description : What is the "best" lossless compression format for compression+archive formats?

Last Answer : That's a tough question to answer. Different compression schemes are better at compressing different kinds of data. I generally use BZ2 and I've been seeing it steadily increase in usage. BZ2 ... to be compression) so you could always do some benchmarking yourself to answer the question precisely.

What is the difference between a lossy and a lossless file extension?

Description : What is the difference between a lossy and a lossless file extension?

Last Answer : In a general sense, the lossy will loose something each time you save it wheras the lossless will not. This might clear it up

Can you get an MP3 player that can play lossless formats like FLAC?

Description : Can you get an MP3 player that can play lossless formats like FLAC?

Last Answer : Yes, there are several players that handle lossless formats without a problem. Apple's players accept Apple's own lossless codec, and the Cowon D2, SanDisk Sansa Fuze and Clip all support FLAC as well.

Can you get a portable media player that will use lossless music formats like flac,shn and ogg?

Description : Can you get a portable media player that will use lossless music formats like flac,shn and ogg?

Last Answer : I could not find a portable media player that would use those formats.

The attenuation constant in lossless dielectrics will be a) 0 b) 1 c) -1 d) ∞

Description : The attenuation constant in lossless dielectrics will be a) 0 b) 1 c) -1 d) ∞

Last Answer : a) 0

An example for lossless propagation is a) Dielectric waveguide propagation b) Conductor propagation c) Cavity resonator propagation d) It is not possible

Description : An example for lossless propagation is a) Dielectric waveguide propagation b) Conductor propagation c) Cavity resonator propagation d) It is not possible

Last Answer : d) It is not possible

For a lossless dielectric, the attenuation will be a) 1 b) 0 c) -1 d) Infinity

Description : For a lossless dielectric, the attenuation will be a) 1 b) 0 c) -1 d) Infinity

Last Answer : b) 0

If the loss tangent is very less, then the material will be a a) Conductor b) Lossless dielectric c) Lossy dielectric d) Insulator

Description : If the loss tangent is very less, then the material will be a a) Conductor b) Lossless dielectric c) Lossy dielectric d) Insulator

Last Answer : b) Lossless dielectric

Data compression which guarantees that all original data can be restored exactly A. Lossless compression B. Lossy compression C. File compression D. Raster compression

Description : Data compression which guarantees that all original data can be restored exactly A. Lossless compression B. Lossy compression C. File compression D. Raster compression

Last Answer : B. Lossy compression

Which of the following is a benefit of lossy compression over lossless? A. File sizes will always be reduced, even when compressed multiple times. B. File quality is not harmed, e.g. images will look exactly the same. C. Files can be decompressed back to their original uncompressed form. D. File sizes are usually significantly smaller.

Description : Which of the following is a benefit of lossy compression over lossless? A. File sizes will always be reduced, even when compressed multiple times. B. File quality is not harmed, e.g. ... can be decompressed back to their original uncompressed form. D. File sizes are usually significantly smaller.

Last Answer : C. Files can be decompressed back to their original uncompressed form.

What type of compression actually deletes data and cannot be decompressed? A. File Compression B. Lossless Compression C. Lossy Compression D. Archive Compression

Description : What type of compression actually deletes data and cannot be decompressed? A. File Compression B. Lossless Compression C. Lossy Compression D. Archive Compression

Last Answer : D. Archive Compression

Represents one dot that is illuminated on a computer screen, many of which make up images A. Graphics B. Lossless C. Lossy D. Pixels

Description : Represents one dot that is illuminated on a computer screen, many of which make up images A. Graphics B. Lossless C. Lossy D. Pixels

Last Answer : D. Pixels

Anything on a page that is not actual text, from simple line drawings to fully active images found on the World Wide Web. A. Graphics B. Lossless C. Lossy D. Pixels

Description : Anything on a page that is not actual text, from simple line drawings to fully active images found on the World Wide Web. A. Graphics B. Lossless C. Lossy D. Pixels

Last Answer : A. Graphics

Dennis has saved a photograph and has lost data during compression. What type of compression has occurred? A. LOSSY B. LOSSLESS C. RESOLUTION D. COLOR MODE

Description : Dennis has saved a photograph and has lost data during compression. What type of compression has occurred? A. LOSSY B. LOSSLESS C. RESOLUTION D. COLOR MODE

Last Answer : A. LOSSY

Performance measure for Lossless Compression is __________: A. Distortion B. Fidelity C. Quality D. Rate

Description : Performance measure for Lossless Compression is __________: A. Distortion B. Fidelity C. Quality D. Rate

Last Answer : D. Rate

Which best describes Lossless Compression? A. No information is lost but file size is increased B. There is no loss in information at all after compression C. Files which have the exact same data after compression D. Compression that involves an algorithm

Description : Which best describes Lossless Compression? A. No information is lost but file size is increased B. There is no loss in information at all after compression C. Files which have the exact same data after compression D. Compression that involves an algorithm

Last Answer : B. There is no loss in information at all after compression

Lossy or lossless? This type of compression makes the file smaller A. Lossy B. Lossless

Description : Lossy or lossless? This type of compression makes the file smaller A. Lossy B. Lossless

Last Answer : A. Lossy