Computer Science · Database Management Systems
Consider the following statements regarding the types of decomposition in a relational database: Statement 1: A lossless join decomposition perfectly reconstructs the original relation without any data loss or augmentation. Statement 2: A lossy join incorrectly produces a superset of the original relation by generating phantom or spurious tuples. Choose the most appropriate answer from the options given below:
- 1Statement 1 is true, but Statement 2 is false.
- 2Both statements are false.
- 3Both statements are true.✓
- 4Statement 1 is false, but Statement 2 is true.
Correct answer
Both statements are true.
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Preparing for Computer Science?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Want more practice questions on Database Management Systems?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · Database Management Systems