Database System Concepts and Architecture - data models, schemas and instances, three-schema architecture, data independence, database languages and interfaces, centralized and client-server architectures - One Line Questions

1. Which of the following is a typical component of a client-server database architecture? — A client machine that sends requests to a database server.
2. A database schema is defined as: — The logical structure or blueprint of the entire database.
3. A database schema can be thought of as: — A blueprint or template for the database.
4. What is a key characteristic of a distributed database architecture? — Data is spread across multiple interconnected computers.
5. Which of the following represents physical data independence? — Changing the file organization or storage structures without affecting applications.
6. Which schema in the three-schema architecture is closest to the end-user? — External Schema
7. In the three-schema architecture, the 'view level' corresponds to which schema? — External Schema
8. Which of the following is an example of a DML statement in SQL? — DELETE FROM Products WHERE ProductID = 5;
9. Which of the following is a characteristic of the Relational Model? — Data is represented in tables (relations).
10. Which of the following is an example of a database language used for defining the database structure? — Data Definition Language (DDL)
11. The three-schema architecture aims to achieve: — Data independence and flexibility.
12. In a client-server database system, the client typically handles: — User interface and presentation logic.
13. The Entity-Relationship (ER) model is primarily used for: — Database design and conceptualization.
14. Which type of database language is used to manage user access and permissions? — DCL
15. Which of the following is a type of database language used for transaction management? — TCL (Transaction Control Language)
16. Which database language is used to retrieve data from the database? — DML (Data Manipulation Language)
17. Data Manipulation Language (DML) commands are used for: — Inserting, deleting, and modifying data.
18. A database schema defines the relationships between: — Entities, attributes, and relationships.
19. In a client-server architecture, the server is responsible for: — Managing the database and responding to client requests.
20. Which schema in the three-schema architecture deals with how data is actually stored on disk? — Internal Schema
21. Which layer of the three-schema architecture provides a customized view of the database for a specific user or application? — External Schema
22. Which schema is defined by the database administrator and represents the entire logical content of the database? — Conceptual Schema
23. In the three-schema architecture, which schema describes the overall logical structure of the database, independent of physical storage details? — Conceptual Schema (Logical Level)
24. The Network Model allows a record to have multiple parent records, forming a graph-like structure. This is also known as: — Codasyl Model
25. SQL (Structured Query Language) is primarily associated with which data model? — Relational Model
26. Which data model uses tables, rows, and columns to represent data? — Relational Model
27. What is a disadvantage of a centralized database architecture? — Single point of failure.
28. What is the primary benefit of the three-schema architecture? — Enhanced data independence and flexibility.
29. The internal schema is also referred to as the: — Physical Schema
30. Which type of data model organizes data in a tree-like structure with a single root element? — Hierarchical Model
31. In a centralized database architecture, where is the database typically located? — On a single mainframe or server machine.
32. Which of the following is an interface for a database system? — SQL Query Language
33. Which type of data independence allows changes in the conceptual schema without requiring changes to the external schemas? — Logical Data Independence
34. What kind of independence allows changes to the conceptual schema without affecting external schemas? — Logical Data Independence
35. Which of the following is a conceptual data model that represents data as entities and the relationships between them? — Entity-Relationship (ER) Model
36. Which data model is known for its flexibility in representing complex relationships using pointers? — Network Model
37. Which of the following is NOT a data model? — Client-Server Model
38. The Object-Oriented Data Model treats data as: — Objects with attributes and methods.
39. Which of the following is an example of a DDL statement in SQL? — CREATE TABLE Departments (DeptID INT, DeptName VARCHAR(50));
40. What does data independence refer to in a database system? — The separation of the physical storage structure from the logical data structure.
41. In the context of the three-schema architecture, what is 'data independence'? — The ability to modify the schema at one level without affecting other levels.
42. Which component of the client-server architecture is responsible for executing database queries and managing data storage? — The Server (Database Management System)
43. A database schema defines: — The structure and constraints of the database.
44. Which of the following is an example of a database instance? — The actual data records in the database at 10:00 AM today.
45. What is a database instance? — The actual data stored in the database at a given time.
46. The internal schema is concerned with: — The physical storage details, like file organization and indexing.
47. Which of the following best describes a database schema instance? — The actual data content of the database at a specific point in time.
48. The 'instance' of a database refers to: — The actual data content at a particular moment.
49. What is the primary purpose of the Conceptual Schema in the three-schema architecture? — To describe the entire database's logical structure, including entities, attributes, and relationships.
50. What is the role of the database administrator (DBA) in relation to the database schema? — To design and maintain the database schema.
All One Line Questions
E-Book Database System Concepts and Architecture - data models, schemas and instances, three-schema architecture, data independence, database languages and interfaces, centralized and client-server architectures Online Test Database System Concepts and Architecture - data models, schemas and instances, three-schema architecture, data independence, database languages and interfaces, centralized and client-server architectures Question Bank Database System Concepts and Architecture - data models, schemas and instances, three-schema architecture, data independence, database languages and interfaces, centralized and client-server architectures