Question:
Which of the following is not a desirable characteristic of a database system ?
Which of the following is not a desirable characteristic of a database system ?
Show Hint
One of the main goals of database normalization is to *reduce* data redundancy. This prevents inconsistencies and saves valuable storage space.
Updated On: Jul 21, 2026
- Minimum cost
- Maximum redundancy
- Search capability
- Data integrity
Show Solution
Verified By Collegedunia
The Correct Option is B
Solution and Explanation
Step 1: Understanding the Concept:
A Database Management System (DBMS) is designed to store, retrieve, and manage data efficiently, maintaining accuracy and accessibility.
Step 2: Detailed Explanation:
Let us evaluate the listed characteristics of a database system:
- Minimum cost (A): Ensuring high performance at a lower cost of storage and administration is a desirable goal.
- Search capability (C): A database must allow users to query and retrieve data quickly and easily using search indexes. This is essential.
- Data integrity (D): Maintaining data accuracy, consistency, and reliability through constraints and validation rules is critical. This is a primary goal of a database.
- Redundancy: This refers to the duplication of the same data in multiple places.
High redundancy is undesirable because it wastes storage space and can lead to data inconsistency (where the data is updated in one place but remains outdated in another).
One of the main purposes of a database system is to minimize or eliminate redundancy through normalization.
Therefore, "Maximum redundancy" is not a desirable characteristic.
Step 3: Final Answer:
Maximum redundancy is not a desirable characteristic of a database system.
A Database Management System (DBMS) is designed to store, retrieve, and manage data efficiently, maintaining accuracy and accessibility.
Step 2: Detailed Explanation:
Let us evaluate the listed characteristics of a database system:
- Minimum cost (A): Ensuring high performance at a lower cost of storage and administration is a desirable goal.
- Search capability (C): A database must allow users to query and retrieve data quickly and easily using search indexes. This is essential.
- Data integrity (D): Maintaining data accuracy, consistency, and reliability through constraints and validation rules is critical. This is a primary goal of a database.
- Redundancy: This refers to the duplication of the same data in multiple places.
High redundancy is undesirable because it wastes storage space and can lead to data inconsistency (where the data is updated in one place but remains outdated in another).
One of the main purposes of a database system is to minimize or eliminate redundancy through normalization.
Therefore, "Maximum redundancy" is not a desirable characteristic.
Step 3: Final Answer:
Maximum redundancy is not a desirable characteristic of a database system.
Was this answer helpful?
0
0
Top ICAR AIEEA Dairy Technology Questions
- As per legal standards (FSSR, 2011), the acidity (%LA) of chakka should not be more than:
- Which of the following food additive is permitted as preservative in paneer?
- Given below are four statements:
Statement (I) : Homogenisation breaks down fat globules in milk into smaller entities.
Statement (II) : Homogenisation breaks down fat globules and casein micelles in milk into smaller entities.
Statement (III) : Homogenisation slightly increases viscosity of milk.
Statement (IV) : Homogenisation improves the appearance of milk.
In light of the above statements, choose the most appropriate answer from the options given below. - With regard to temperature of operation, place the following unit operations in sequence in an increasing order of temperature:
(i) Sterilisation
(ii) Thermisation
(iii) Homogenisation
(iv) Bactofugation and
(v) HTST pasteurization.
Choose the correct answer from the options given below : - “Narampak” and “karapak” refer to varieties of sandesh with reference to which of the following parameters ?
View More Questions
Top ICAR AIEEA Dairy Product Technology Questions
- Given below are four statements:
Statement (I) : Homogenisation breaks down fat globules in milk into smaller entities.
Statement (II) : Homogenisation breaks down fat globules and casein micelles in milk into smaller entities.
Statement (III) : Homogenisation slightly increases viscosity of milk.
Statement (IV) : Homogenisation improves the appearance of milk.
In light of the above statements, choose the most appropriate answer from the options given below. - “Narampak” and “karapak” refer to varieties of sandesh with reference to which of the following parameters ?
- In sensory evaluation of dairy products, maximum marks are allotted to which of the following attribute ?
- Given below are two statements, one is labelled as Assertion (A) and other one labelled as Reason (R).
Assertion (A) : During paneer manufacture, pressing of coagulum in hot condition is essential.
Reason (R) : Pressing in hot condition can fuse the coagulum into a firm single block.
In light of the above statements, choose the correct answer from the options given below. - Match List-I with List-II
\begin{tabular{ll} List-I (Name of the cheese) & List-II (Country of origin)
(A) Limburger & (I) Portugal
(B) Queso-Blanco & (II) Germany
(C) Requeijao & (III) Peru
(D) Ziger & (IV) Belgium
Match the name of the cheese with its country of origin :
View More Questions
Top ICAR AIEEA Questions
- Which of the following statements is false?
- Which of the following is an example of an inventory?
- According to Adam Smith, productivity gains could be brought about through .
- The supply curve for an artificially scarce good is .
- Which of the following would not be considered an opportunity cost of paid employment?
View More Questions