CS Professional · Artificial Intelligence, Data Analytics and Cyber Security - Laws and Practice · Database Management
In the three-schema architecture of a DBMS, which level describes how data is physically stored on disk, including file organisation and indexing structures?
The internal schema describes physical storage of data, including file organisation and indexes. The conceptual schema gives the logical structure of the whole database, while external schemas present user-specific views. Hence the internal level is the one concerned with how data is physically stored.
- AExternal schema
- BConceptual schema
- CInternal schemaCorrect
- DView schema
Explanation
The internal (physical) schema deals with storage structures, file organisation and access paths such as indexes. The conceptual schema describes the logical structure of the entire database, and the external schema describes user-specific views. A 'view schema' is not a separate level of the architecture.
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 bank encrypts the customer table in its database so that data files stolen from the server cannot be read without a key. This control main…
- 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?