UGC NET Questions (Paper – 1)

Statements A, B, C and D accurately describe storage options and redundancy. Hard disks and SSDs provide secondary storage, DVDs can distribute data, cloud storage keeps data on remote servers and redundancy improves availability. Statement E is false because local backups remain advisable even with cloud services, and F is false since cloud storage is inherently network-based. Therefore the correct set of statements is A, B, C and D only.

Option A:
Option A is correct because it includes all true statements about physical and cloud storage while rejecting the idea that backups are unnecessary or that cloud access is offline. It aligns with robust data protection strategies.

Option B:
Option B is incomplete because it omits C and does not mention cloud storage, which is a major modern storage option. A, B and D are true but do not cover all correct statements.

Option C:
Option C is incorrect because it includes E, which discourages local backups, contrary to good practice. Mixing a false statement with true ones makes the combination invalid.

Option D:
Option D is incomplete because it omits B and therefore does not acknowledge optical media as a distribution medium. A, C and D are correct but do not represent the full set of correct statements given.

Statements A, B and D correctly describe the functions and benefits of a DBMS, while C is incorrect. A DBMS is designed to minimise unnecessary redundancy, provide powerful query capabilities and enforce integrity and security rules. Maximising redundancy would waste storage and lead to inconsistency, which is contrary to database design principles. Therefore, the combination A, B and D only is the correct set of statements.

Option A:
Option A is incomplete because it includes A and B but omits D. While defining and querying data are important, recognising the integrity and security roles of a DBMS is also essential for a complete understanding.

Option B:
Option B is incomplete because it lists only B and D and leaves out A. Without acknowledging that a DBMS defines and maintains databases, the foundational purpose of such systems is not fully captured.

Option C:
Option C is correct because it gathers A, B and D, the three true statements, and rejects C, which misunderstands the goal of controlling redundancy. It presents a coherent picture of how DBMS technology supports reliable data management.

Option D:
Option D is incorrect because it considers all four statements as correct and hence accepts C. Since C conflicts with the aim of reducing redundant data, any option that includes it cannot be correct.