CS Professional · Artificial Intelligence, Data Analytics and Cyber Security - Laws and Practice · Database Management
A DBA ensures that changing the way data files are stored on disk does not require rewriting the application programs that use the data. This property is known as:
Physical data independence. It means the storage structure or file organisation can be changed without altering the conceptual schema or the application programs. Logical data independence is different, as it concerns changes to the logical schema rather than physical storage.
- APhysical data independenceCorrect
- BLogical data independence
- CReferential integrity
- DData redundancy
Explanation
Physical data independence means changes to the internal storage structure do not affect the conceptual schema or applications. Logical data independence is about changing the conceptual schema without affecting external views or programs, which is not what is described here.
Did you get it right without looking?
One question tells you little. A timed set on Database Management shows your real accuracy, how long you take and where you lose marks.
More Database Management questions
- An e-commerce firm analyses its past transaction records and finds that customers who buy a mobile phone very often buy a screen guard in th…
- A DBA at an Indian e-commerce company grants a junior clerk only SELECT permission on the orders table and no rights to modify or delete row…
- A student and course database records that many students enrol in many courses, with each enrolment also storing the date of enrolment. How …
- A company changes the physical storage of its employee records by adding an index and moving files to a new disk, and no application program…
- Which of the following is a characteristic traditionally used to define big data, along with volume and variety?
- A fintech firm's DBMS lets the marketing team see only customer names and cities, while hiding PAN and Aadhaar columns stored in the same ba…