Data redundancy and inconsistency – Redundancy is the concept of repetition of data i.e. each data may have more than a single copy. The file system cannot control redundancy of data as each user defines and maintains the needed files for a specific application to run. There may be a possibility that two users are maintaining same files data for different applications. Hence changes made by one user does not reflect in files used by second users, which leads to inconsistency of data. Whereas DBMS controls redundancy by maintaining a single repository of data that is defined once and is accessed by many users. As there is no or less redundancy, data remains consistent.

Question

Data redundancy and inconsistency – Redundancy is the concept of repetition of data i.e. each data may have more than a single copy. The file system cannot control redundancy of data as each user defines and maintains the needed files for a specific application to run. There may be a possibility that two users are maintaining same files data for different applications. Hence changes made by one user does not reflect in files used by second users, which leads to inconsistency of data. Whereas DBMS controls redundancy by maintaining a single repository of data that is defined once and is accessed by many users. As there is no or less redundancy, data remains consistent.

trilok sharma · Accepted Answer

Data redundancy and inconsistency – Redundancy is the concept of repetition of data i.e. each data may have more than a single copy. The file system cannot control redundancy of data as each user defines and maintains the needed files for a specific application to run. There may be a possibility that two users are maintaining same files data for different applications. Hence changes made by one user does not reflect in files used by second users, which leads to inconsistency of data. Whereas DBMS controls redundancy by maintaining a single repository of data that is defined once and is accessed by many users. As there is no or less redundancy, data remains consistent.

Creation of new database role in the current database is made by :

he database administrator who authorizes all the new users, modifies the database and takes grants privilege is

Which of the following data structure is preferred to have lesser search time when the list size is small?

The supported storage types for data files are :

User datagram protocol is called connectionless because

What is the size of an int data type?

A window into a portion of a database is

The format identifier ‘%i’ is also used for _____ data type.

Which of the following is a User-defined data type?

A window into a portion of a database is

Featured Courses

Popular Pages

SAT (Scholastic Assessment Test)

Reasoning special by Parwez Alam

NET

Study24x7

Defence

Henry Harvin

UPSC & State PSC

CBSE Study Materials

SSC Preparation Strategies & Study Mater...

Banking/IRDA

Get the App

Graph Database

Neo4J

MongoDB

Types of Database and its Uses

Database Management System (DBMS)

Difference Between Data Science and Data Analytics

Creating A Competitive Edge With Talend Data Management

Benefits of Learning DATABASE MANAGEMENT

DATA MINING FOR DATABASE

RELATIONAL DATABASE MANAGEMENT SYSTEM