CLOUD COMPUTING

CLOUD COMPUTING

DATABASE MANAGEMENT

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
File structure is changed without affecting the application’s ability to access the data
A
Structural dependence
B
Structural independence
C
Data dependence
D
Data independence
Explanation: 

Detailed explanation-1: -It means we change the physical storage/level without affecting the conceptual or external view of the data. The new changes are absorbed by mapping techniques. Logical data independence is the ability to modify the logical schema without causing application programs to be rewritten.

Detailed explanation-2: -Data independence allows changing the schema at one level without the need to change the schema at another level. It helps to improve the data security of the database. With the help of physical data independence, we can change the storage and file structure of the database without affecting the application program.

Detailed explanation-3: -Structural independence exists when changes in the database structure do not affect DBMS ability to access data. Structural dependence exists when changes in the database structure do not affect DBMS ability to access data.

Detailed explanation-4: -Structural dependence exists when it is possible to make changes in the file structure without affecting the application program’s ability to access the data. Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions.

There is 1 question to complete.