COMPUTER FUNDAMENTALS

COMPUTER APPLICATIONS

DATABASE MANAGEMENT SYSTEMS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following is the disadvantages of DBMS?
A
Cost of setup of DBMS is relatively cheap
B
Database systems are complex
C
Database will not be corrupted
D
Database systems are fast to be designed
Explanation: 

Detailed explanation-1: -Hardware and Software Costs: It is the main disadvantage of a DBMS system, a database management system database requires processing power which needs high-speed processors and these processors use hardware that is expensive and increases the cost of the overall system.

Detailed explanation-2: -Database Failures If database is corrupted due to power failure or it is corrupted on the storage media, then our valuable data may be lost or the system will stop working. Lower Efficiency A database system is a multi-user software, which is less efficient.

Detailed explanation-3: -Disadvantages of storing multiple relations in a single file: • increases the size and complexity of the DBMS.

There is 1 question to complete.