Q136
A logical schema
A.
is the entire database
B.
is a standard way of organizing information into accessible parts
AnswerC.
describes how data is actually stored on disk
D.
All of the above
E.
None of the above
Answer: Option B
Solution
Answer: Option B
Solution:
A logical schema is a representation of the structure of a database in terms of how data is organized and related. It focuses on the design and organization of data elements and their relationships, abstracted from the physical storage. Logical Schema Definition:
The logical schema defines how data is organized into tables, their attributes, and the relationships among them. It is concerned with the design and structure of the database as seen by users and applications, without regard to how the data is physically stored.
Option A: Entire Database
This describes the physical schema or the entire database, not the logical schema.
Option C: Describes How Data is Actually Stored
This refers to the physical schema, which deals with the actual storage of data on disk.
Option D: All of the Above
Since options A and C describe different aspects (physical schema) and are not part of the logical schema, this option is incorrect.
Option E: None of the Above
Since option B correctly describes the logical schema, this option is not applicable.
Therefore, the correct answer is Option B: is a standard way of organizing information into accessible parts.