What is Lossless join property?
It guarantees that the spurious tuple generation does not occur with respect to relation schemas after decomposition.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What is implied Join. Where do we find it ? 03.11.08
Join between two Tables. Join Object defines The Relationship Between a Bc and atable.Join allows Bc to get Column from table rather then basetable. I...What difference between join specification , join definition, join criteria and link specification? 26.09.08
Let us write SQL query to understand this: select s.name,a.name (1) from s_evt_act a,...Cascade Delete Property for Link ? 26.09.08
This property is to clear the relation or unmapped child date to be removed from the DB. Cascade Delete has 3 types of values. 1) None 2) Clear 3) Delete 1)...Compare a subselect to a join ? 03.04.08
Any subselect can be rewritten as a join, but not vice versa. Joins are usually more efficient as join rows can be returned immediately, subselects require a...DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences? 03.04.08
A merge join requires that the tables being joined be in a sequence; the rows are retrieved with a high cluster ratio index or are sorted by DB2. A nested joi...What is an inner join, and an outer join ? 20.03.08
Inner Join: combine information from two or more tables by comparing all values that meet the search criteria in the designated column or columns of one table w...What are the different types of joins? 16.11.06
Different Types of Joins- Inner Join Outer Join - Right Outer Join & Left Outer Join Cross Join...What is a self join? 06.08.06
Self join is just like any other join, except that two instances of the same table will be joined in the query....What is a OUTER JOIN ? 16.03.06
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 cond...What is join dependency and inclusion dependency? 08.03.06
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...