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
Question
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
Solution
The schema that directly interacts with the DBMS in the Three Level Schema Architecture is A) Internal Schema.
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.
What is the primary function of the External Schema in the Three Level Schema Architecture?A) It defines the physical storage structure of data.B) It outlines the logical structure of all data in the database.C) It represents the view of the data as seen by end-users or application programs.D) It specifies how data is actually stored on the disk.
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
In the three-schema architecture, which level deals with the constraints?
In the three-schema architecture, which level deals with the constraints? *1 pointphysical levellogical levelconceptual levelview level
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.