What is Lossless join property?



What is Lossless join property?..

Answer / Ziyaul Rehman

Lossless join property refers to the ability of a join operation to preserve all original values from both input relations, without losing any data. It ensures that if there are duplicate values in either relation before the join, they will also appear as duplicates in the result.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Architecture Interview Questions

What are the three levels of database architecture?

1 Answers  


What is DML (Data Manipulation Language)?

1 Answers  


What is difference between 2 tier and 3 tier architecture?

1 Answers  


What is Set-at-a-time or Set-oriented?

1 Answers  


Name the buffer in which all the commands that are typed in are stored

1 Answers  


What are the three tiers in a 3 tier architecture?

1 Answers  


What is the difference between stored procedures and stored functions in oracle?

1 Answers  


Define the "integrity rules"?

1 Answers  


What is Fully Functional dependency?

1 Answers  


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

1 Answers  


What is Domain-Key Normal Form?

1 Answers  


What do data architects do?

1 Answers  


Categories