MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

DATABASE MANAGEMENT SYSTEM

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Why File Based System become unpopular?
A
It causes sync with all the data synchronization
B
It causes data redundancy
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -The data is not very secure in a file based system and may be corrupted or destroyed. The data files in the file based system may be stored across multiple locations. Consequently, it is difficult to share the data easily with multiple users.

Detailed explanation-2: -What is data redundancy, and which characteristics of the file system can lead to it? Data redundancy occurs when the same data are stored in multiple places unnecessarily. The use of spreadsheets and tables in different parts of the organization can cause it.

Detailed explanation-3: -Problems resulting from the traditional file environment include: Data redundancy: duplicate data in multiple files, leading to data inconsistency, different values used for the same attribute. Program-data dependency: Changes in programs requiring changes to the data. Lack of flexibility.

Detailed explanation-4: -This practice can lead to several problems such as: Inconsistency in data format. The same information being kept in several different places (files) Data inconsistency, a situation where various copies of the same data are conflicting, wastes storage space and duplicates effort.

Detailed explanation-5: -The redundancy of data is low in the DBMS system. Data inconsistency is higher in the file system. Data inconsistency is low in a database management system. The file system offers lesser security.

There is 1 question to complete.