DBMS-Database System Architecture Questions and Answers
DBMS – Database System Architecture Questions with Answers focus on how data is stored, processed, and managed in layered database systems. Understanding concepts like three-tier architecture, data abstraction, and schema mapping is vital for software developers and IT aspirants. These programming questions and answers provide in-depth coverage for DBMS interview preparation and placement tests conducted by companies like TCS, Infosys, and Cognizant.
DBMS-Database System Architecture
Showing 10 of
41 questions
11. The primary difference between the different data models lies in the methods of expressing relationships and constraints among the data elements.
- TRUE
- FALSE
12. In a database, the data are stored in such a fashion that they are independent of the program of users using the data.
- TRUE
- FALSE
13. The plan (or formulation of scheme) of the database is known as schema.
- TRUE
- FALSE
14. The physical schema is concerned with exploiting the data structure offered by a DBMS in order to make the scheme understandable to the computer
- TRUE
- FALSE
15. The logical schema, deals with the manner in which the conceptual database shall get represented in the computer as a stored database.
- TRUE
- FALSE
16. Subschemas act as a unit for enforcing controlled access to the database.
- TRUE
- FALSE
17. The process of transforming requests and results between three levels are called mappings.
- TRUE
- FALSE
18. The conceptual/internal mapping defines the correspondence between the conceptual view and the stored database.
- TRUE
- FALSE
19. The external/conceptual mapping defines the correspondence between a particular external view and organisation
- TRUE
- FALSE
20. A data model is an abstraction process that concentrates essential and inherent aspects of the organization's application while ignores supefluous or accidental details.
- TRUE
- FALSE