Which of these statements is/are correct?A Physical Schema is also called as low level schemaB Logical Schema is also called as conceptual schemaC View level schema is called as high level schemaD The database schema is the structure of a database described in a formal language
Question
Which of these statements is/are correct?A Physical Schema is also called as low level schemaB Logical Schema is also called as conceptual schemaC View level schema is called as high level schemaD The database schema is the structure of a database described in a formal language
Solution
All of the statements A, B, C, and D are correct.
A. A Physical Schema is also known as a low-level schema. It describes how data is stored physically on a storage medium.
B. A Logical Schema is also referred to as a conceptual schema. It describes the database design at a logical level, without going into physical storage details.
C. A View level schema, also known as a high-level schema, describes how the data is presented to the end users.
D. The database schema is indeed the structure of a database described in a formal language. It defines the tables, fields, relationships, indexes, functions, and other elements.
Similar Questions
Considering the Three-Schema Architecture, which of the following is correct?A. The conceptual level describes the physical storage structure of the database.B. Logical data independence provides the ability to move the physical location of where data is stored without making changes to the applications.C. Physical data independence provides the ability to modify physical schema without making changes to the logical schema.D. The external level provides access to changing the schema of the relations in a database.
Data schemas represent the skeleton structure of a database. They represent the ___ of the database as a whole.a.Physical Viewb.Semantic Viewc.Logical Viewd.Analytical View
Which of the following database languages is primarily used for defining the low level schema?*1 pointA. Data Manipulation Language (DML)B. Data Definition Language (DDL)C. Data Control Language (DCL)D. Query Language
In the Three Level Schema Architecture, which of the following schemas directly interacts with the DBMS?A) Internal SchemaB) External SchemaC) Conceptual SchemaD) Physical Schema
Which of the following statements is TRUE about the schemas? (Choose all correct answer) A. A schema is a collection of database objects that belong to the same tablespace. B. A schema is a collection of database objects that are owned by a particular user. C. A role is a schema object. D. An index is a schema object.
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.