4 Lecture - Internal or Physical View / Schema

  1. Home
  2. Courses
  3. Database Management System
  4. 4 Lecture

4 Lecture

CS403

Midterm & Final Term Short Notes

Internal or Physical View / Schema

The internal or physical view/schema of a database refers to the way data is physically stored on the storage media. It describes the low-level details of the database, such as the storage format, data structures, indexing methods, and access pa


Important Mcq's
Midterm & Finalterm Prepration
Past papers included

Download PDF

  1. What is the internal or physical view/schema of a database? a) The way data is logically organized within a database b) The way data is physically stored on the storage media c) The way data is presented to end-users Answer: b) The way data is physically stored on the storage media Which of the following describes the internal view of a database? a) A high-level view of the data and its relationships b) A low-level view of the data storage and access methods c) A view of the data as it is presented to end-users Answer: b) A low-level view of the data storage and access methods Which of the following is not a component of the internal view/schema of a database? a) Storage format b) Data structures c) Indexing methods d) User interface design Answer: d) User interface design The internal view/schema of a database is important for: a) End-users b) Database administrators c) Both end-users and database administrators Answer: b) Database administrators Which of the following is an example of a storage format used in the internal view of a database? a) XML b) SQL c) Binary Answer: c) Binary Which of the following is an example of a data structure used in the internal view of a database? a) Linked list b) Array c) Stack Answer: a) Linked list Which of the following is an example of an indexing method used in the internal view of a database? a) Binary search b) Bubble sort c) Quick sort Answer: a) Binary search The internal view/schema of a database is also known as: a) The conceptual view b) The physical view c) The external view Answer: b) The physical view Which of the following best describes the relationship between the internal view and the external view of a database? a) The internal view is a high-level view of the data, while the external view is a low-level view of the data storage and access methods. b) The internal view is a low-level view of the data storage and access methods, while the external view is a high-level view of the data. c) The internal view and the external view are the same thing. Answer: b) The internal view is a low-level view of the data storage and access methods, while the external view is a high-level view of the data. Which of the following is not a reason why the internal view/schema of a database is important? a) To optimize database performance b) To ensure efficient data retrieval c) To present data to end-users Answer: c) To present data to end-users



Subjective Short Notes
Midterm & Finalterm Prepration
Past papers included

Download PDF

  1. What is the internal or physical view/schema of a database? Answer: The internal or physical view/schema of a database refers to the way data is physically stored on the storage media. What does the internal view/schema describe? Answer: The internal view/schema describes the low-level details of the database, such as the storage format, data structures, indexing methods, and access paths. Why is it important for database administrators to understand the internal view of a database? Answer: It is important for database administrators to understand the internal view of a database to optimize its performance and ensure efficient data retrieval. What is an example of a storage format used in the internal view of a database? Answer: An example of a storage format used in the internal view of a database is binary. What is an example of a data structure used in the internal view of a database? Answer: An example of a data structure used in the internal view of a database is a linked list. What is an example of an indexing method used in the internal view of a database? Answer: An example of an indexing method used in the internal view of a database is binary search. What is the internal view/schema of a database also known as? Answer: The internal view/schema of a database is also known as the physical view. How does the internal view/schema of a database differ from the external view/schema? Answer: The internal view/schema of a database describes the low-level details of the database, while the external view/schema describes the high-level view of the data and its relationships. Who benefits the most from understanding the internal view of a database? Answer: Database administrators benefit the most from understanding the internal view of a database. How can the internal view/schema of a database be optimized for better performance? Answer: The internal view/schema of a database can be optimized for better performance by implementing efficient data storage and access methods, using appropriate data structures, and applying indexing techniques.

The internal or physical view/schema of a database refers to the way data is physically stored on the storage media. It describes the low-level details of the database, such as the storage format, data structures, indexing methods, and access paths. This view is essential for database administrators, as it enables them to optimize the performance of the database and ensure efficient data retrieval. The internal view/schema of a database includes the physical organization of data, such as the layout of records and fields, and the way in which data is stored on disk or other storage media. It also includes the various access methods used to retrieve data from the database, such as sequential access, direct access, and indexed access. Data structures used in the internal view/schema of a database include linked lists, arrays, and trees. These data structures are used to organize data within the database and to facilitate efficient retrieval of data. Indexing methods used in the internal view/schema of a database include hash indexes, B-tree indexes, and bitmap indexes. These indexing methods are used to improve query performance by providing fast access to data. Database administrators must understand the internal view/schema of a database to optimize its performance. For example, they may need to choose an appropriate data storage format or data structure, or implement an indexing method that is suitable for the type of data and the way in which it is accessed. The internal view/schema of a database differs from the external view/schema, which describes the high-level view of the data and its relationships. While the external view/schema is concerned with the logical organization of data and the relationships between tables, the internal view/schema is focused on the physical storage of data. In conclusion, the internal or physical view/schema of a database is essential for database administrators to optimize the performance of the database and ensure efficient data retrieval. It describes the low-level details of the database, including storage format, data structures, indexing methods, and access paths. Understanding the internal view/schema enables administrators to make informed decisions about how to organize and access data within the database.

Course Lectures