Database concepts and architecture: data models, schemas, three-schema architecture and data independence. - One Line Questions

1. Which of the following best describes a 'data model'? — A conceptual framework for organizing data.
2. The Network model was an improvement over the Hierarchical model because it: — Supported complex data structures more easily.
3. Data models provide a way to abstract the __________ complexity of data storage and management. — Physical
4. Physical data independence ensures that changes in the __________ do not require changes in the conceptual or external schemas. — Internal schema
5. A database schema can be thought of as the: — Blueprint of the database
6. The Hierarchical data model organizes data in a structure resembling a: — Tree
7. The three-schema architecture helps in achieving: — System portability and maintainability
8. Data independence is achieved by using: — Mappings between schema levels
9. The three-schema architecture was proposed to address issues related to: — Data independence and abstraction
10. Which of the following is a characteristic of the Network data model? — Allows many-to-many relationships directly.
11. The process of defining the database structure, data types, and constraints is called: — Schema definition
12. A database schema is defined using: — Data Definition Language (DDL)
13. The mapping between the external schema and the conceptual schema is handled by the: — External/Conceptual mapping
14. The external schema, also known as a view, is tailored to the needs of: — End-users or specific applications
15. Which level of abstraction in the three-schema architecture is concerned with the lowest-level details of data storage? — Internal
16. Which schema in the three-schema architecture describes the overall logical structure of the database and is independent of storage details? — Conceptual Schema
17. The schema that describes how data is physically stored on storage devices is called the: — Internal Schema
18. Which layer of the three-schema architecture is closest to the end-user? — External Schema
19. Which schema defines the entire set of entities, attributes, relationships, and constraints of the database? — Conceptual Schema
20. Which schema provides a consistent and unified view of the data for the entire community of users? — Conceptual Schema
21. Logical data independence allows changes to the __________ without requiring changes to application programs. — Conceptual schema
22. Which schema is responsible for representing the data as it is stored on the storage medium? — Internal Schema
23. The mapping between the conceptual schema and the internal schema is handled by the: — Conceptual/Internal mapping
24. The three-schema architecture aims to achieve: — Data independence and abstraction
25. Which of the following is an example of a conceptual data model? — Entity-Relationship Diagram
26. Which of the following is NOT a type of data model? — Procedural Model
27. Which data model represents data as a collection of records connected by links, forming a graph structure? — Network Model
28. Which data model is the most widely used today, organizing data into tables with relationships defined between them? — Relational Model
29. Which of the following describes the internal schema? — How data is actually stored on disk.
30. Modifications to the internal schema (e.g., changing file organization or storage structure) should ideally not affect the conceptual schema. This is an example of: — Physical Data Independence
31. The primary goal of a database system's architecture is to: — Provide a structured and manageable way to handle data.
32. Which type of data independence allows changes to the conceptual schema without affecting the external schemas? — Logical Data Independence
33. The Entity-Relationship model is primarily used for: — Conceptual database design
34. The conceptual schema defines the database in terms of: — Entities, attributes, and relationships relevant to the business.
35. Which of these is a fundamental concept in the Relational Model? — Tuples (Rows) and Attributes (Columns)
36. Data independence is crucial for: — Allowing evolution of the database without breaking applications.
37. What is the main advantage of using a database system over traditional file systems? — Reduced data redundancy and inconsistency
38. The Entity-Relationship (ER) model is often used as a conceptual tool for database design. It represents data in terms of: — Entities, attributes, and relationships
39. What is data independence? — The ability to modify the database schema at one level without affecting the schema at another level.
40. A database schema is a description of: — The database structure
41. An 'instance' of a database refers to: — The data present in the database at a particular moment in time.
42. In the three-schema architecture, the conceptual schema represents: — The overall logical structure of the database.
43. What does a schema represent in a database context? — The logical structure and organization of the database.
44. What is the primary role of the External Schema in the three-schema architecture? — To define user-specific views of the data.
45. What is the primary purpose of a database? — To store and retrieve data efficiently and consistently.
46. In a relational data model, data is organized into: — Tables (relations) consisting of rows and columns
47. A database schema is static and rarely changes. — False
48. A database schema can be considered a static definition, while a database instance is a snapshot of the data at a given point in time. — True
49. The three-schema architecture separates the database into how many levels of abstraction? — Three
50. The internal schema is also referred to as the: — Physical Schema
All One Line Questions
E-Book Database concepts and architecture: data models, schemas, three-schema architecture and data independence. Online Test Database concepts and architecture: data models, schemas, three-schema architecture and data independence. Question Bank Database concepts and architecture: data models, schemas, three-schema architecture and data independence.