Database concepts and architecture: data models, schemas, three-schema architecture and data independence. - Question Bank

1. Which schema is responsible for representing the data as it is stored on the storage medium?
A) External Schema
B) Conceptual Schema
C) Internal Schema
D) Application Schema
2. 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.
A) True
B) False
C) It depends on the DBMS
D) Only the external schema is static
3. Data independence is achieved by using:
A) Data encryption
B) Database normalization
C) Mappings between schema levels
D) Data compression algorithms
4. The conceptual schema defines the database in terms of:
A) Physical storage structures like blocks and pages.
B) Entities, attributes, and relationships relevant to the business.
C) Specific views tailored for individual users.
D) The operating system's file management.
5. Which of the following is an example of a conceptual data model?
A) File system structure
B) Database tables and columns
C) Entity-Relationship Diagram
D) Binary tree structure
6. The three-schema architecture helps in achieving:
A) Data duplication
B) Reduced flexibility
C) System portability and maintainability
D) Increased complexity for users
7. The Network model was an improvement over the Hierarchical model because it:
A) Allowed only one-to-many relationships.
B) Supported complex data structures more easily.
C) Was easier to implement.
D) Eliminated all data redundancy.
8. A database schema is defined using:
A) Data Manipulation Language (DML)
B) Data Query Language (DQL)
C) Data Definition Language (DDL)
D) Transaction Control Language (TCL)
9. Data models provide a way to abstract the __________ complexity of data storage and management.
A) Application
B) Logical
C) Physical
D) User
10. Which level of abstraction in the three-schema architecture is concerned with the lowest-level details of data storage?
A) External
B) Conceptual
C) Internal
D) Physical
11. The Entity-Relationship model is primarily used for:
A) Physical database design
B) Conceptual database design
C) Database transaction management
D) Database security implementation
12. Logical data independence allows changes to the __________ without requiring changes to application programs.
A) External schema
B) Conceptual schema
C) Internal schema
D) Database instance
13. Which of the following describes the internal schema?
A) How users perceive the data.
B) The logical relationships between data items.
C) How data is actually stored on disk.
D) The overall structure of the database.
14. The primary goal of a database system's architecture is to:
A) Maximize data redundancy.
B) Minimize data access speed.
C) Provide a structured and manageable way to handle data.
D) Eliminate the need for database administrators.
15. A database schema is static and rarely changes.
A) True
B) False
C) It depends on the database type
D) Only the physical schema changes
16. Which of these is a fundamental concept in the Relational Model?
A) Pointers
B) Tuples (Rows) and Attributes (Columns)
C) Parent-child relationships
D) Graph structures
17. The mapping between the conceptual schema and the internal schema is handled by the:
A) External/Conceptual mapping
B) Conceptual/Internal mapping
C) Data dictionary
D) Query processor
18. The mapping between the external schema and the conceptual schema is handled by the:
A) Database Administrator
B) Data Definition Language (DDL)
C) External/Conceptual mapping
D) Data Manipulation Language (DML)
19. Which schema provides a consistent and unified view of the data for the entire community of users?
A) External Schema
B) Conceptual Schema
C) Internal Schema
D) Physical Schema
20. An 'instance' of a database refers to:
A) The database schema definition.
B) The data present in the database at a particular moment in time.
C) The database management system software.
D) The physical storage structure.
21. The three-schema architecture was proposed to address issues related to:
A) Data encryption and decryption
B) Data independence and abstraction
C) Data replication and distribution
D) Data mining and warehousing
22. A database schema is a description of:
A) The data itself
B) The database structure
C) The database users
D) The database hardware
23. Which of the following best describes a 'data model'?
A) A set of predefined database queries.
B) A conceptual framework for organizing data.
C) The physical storage media for the database.
D) The software used to manage the database.
24. The Entity-Relationship (ER) model is often used as a conceptual tool for database design. It represents data in terms of:
A) Tables and columns
B) Entities, attributes, and relationships
C) Records and pointers
D) Objects and methods
25. What is the primary role of the External Schema in the three-schema architecture?
A) To define the physical storage structures.
B) To define the global logical structure.
C) To define user-specific views of the data.
D) To manage database security.
26. Physical data independence ensures that changes in the __________ do not require changes in the conceptual or external schemas.
A) Application programs
B) External schema
C) Internal schema
D) User interface
27. Which schema defines the entire set of entities, attributes, relationships, and constraints of the database?
A) External Schema
B) Conceptual Schema
C) Internal Schema
D) Physical Schema
28. The three-schema architecture separates the database into how many levels of abstraction?
A) Two
B) Three
C) Four
D) Five
29. A database schema can be thought of as the:
A) Blueprint of the database
B) Actual data records
C) Set of database queries
D) User interface design
30. Which of the following is a characteristic of the Network data model?
A) Data is stored in flat files.
B) Data is represented as a collection of tables.
C) Allows many-to-many relationships directly.
D) Emphasizes data independence above all else.
31. The internal schema is also referred to as the:
A) View Schema
B) Logical Schema
C) Physical Schema
D) Database Schema
32. Data independence is crucial for:
A) Preventing unauthorized access to data.
B) Allowing evolution of the database without breaking applications.
C) Compressing data for efficient storage.
D) Ensuring data backup and recovery.
33. Which data model is the most widely used today, organizing data into tables with relationships defined between them?
A) Hierarchical Model
B) Network Model
C) Relational Model
D) Entity-Relationship Model
34. The process of defining the database structure, data types, and constraints is called:
A) Data manipulation
B) Data normalization
C) Schema definition
D) Data recovery
35. Which layer of the three-schema architecture is closest to the end-user?
A) External Schema
B) Conceptual Schema
C) Internal Schema
D) Physical Schema
36. What is the main advantage of using a database system over traditional file systems?
A) Simpler file management
B) Reduced data redundancy and inconsistency
C) Faster individual file access
D) No need for specialized software
37. In the three-schema architecture, the conceptual schema represents:
A) The entire database from the user's perspective.
B) The overall logical structure of the database.
C) The physical storage details.
D) The database's interaction with external applications.
38. The Hierarchical data model organizes data in a structure resembling a:
A) Circle
B) Square
C) Tree
D) Star
39. Which data model represents data as a collection of records connected by links, forming a graph structure?
A) Hierarchical Model
B) Network Model
C) Relational Model
D) Object-Oriented Model
40. The external schema, also known as a view, is tailored to the needs of:
A) Database administrators
B) Application programmers
C) End-users or specific applications
D) Hardware vendors
41. 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:
A) Logical Data Independence
B) Physical Data Independence
C) Schema Independence
D) Data Abstraction
42. Which type of data independence allows changes to the conceptual schema without affecting the external schemas?
A) Physical Data Independence
B) Logical Data Independence
C) External Data Independence
D) Internal Data Independence
43. What is data independence?
A) The ability to access data from multiple databases simultaneously.
B) The ability to modify the database schema at one level without affecting the schema at another level.
C) The ability to encrypt data for secure transmission.
D) The ability to recover data after a system failure.
44. The schema that describes how data is physically stored on storage devices is called the:
A) External Schema
B) Conceptual Schema
C) Internal Schema
D) Logical Schema
45. Which schema in the three-schema architecture describes the overall logical structure of the database and is independent of storage details?
A) External Schema
B) Conceptual Schema
C) Internal Schema
D) Physical Schema
46. The three-schema architecture aims to achieve:
A) Faster data processing
B) Data independence and abstraction
C) Reduced storage space
D) Enhanced data security
47. What does a schema represent in a database context?
A) The physical storage structure of the data.
B) The logical structure and organization of the database.
C) The actual data values stored in the database.
D) The user interface for interacting with the database.
48. In a relational data model, data is organized into:
A) Trees and branches
B) Tables (relations) consisting of rows and columns
C) Records and pointers
D) Objects with attributes and methods
49. Which of the following is NOT a type of data model?
A) Hierarchical Model
B) Network Model
C) Relational Model
D) Procedural Model
50. What is the primary purpose of a database?
A) To store and retrieve data efficiently and consistently.
B) To run complex mathematical calculations.
C) To design user interfaces for applications.
D) To manage network security protocols.
All Question Banks
E-Book Database concepts and architecture: data models, schemas, three-schema architecture and data independence. One Line Questions 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.