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
21. Object-oriented data model is a logical data model that captures the semantics of objects supported in object oriented programming.
- TRUE
- FALSE
22. Centralised database system is physically confned to a single location.
- TRUE
- FALSE
23. Parallel database systems architecture consists of one central processing unit(CPU) and data storage disks in parallel.
- TRUE
- FALSE
24. Distributed database systems are similar to client/server architecture.
- TRUE
- FALSE
25. Which of the following is database element?
- data
- constraints and schema
- relationships
- all of these.
26. What separates the physical aspects of data storage from the logical aspects of data representation?
- data
- schema
- constraints
- relationships
27. What schema defines how and where the data are organised in a physical data storage?
- external
- internal
- conceptual
- nNone of these
28. Which of the following schemas defines the stored data structures in terms of the database model used?
- external
- internal
- conceptual
- none of these
29. Which of the following schemas defines the stored data structures in terms of the database model used?
- external
- conceptual
- internal
- none of these
30. A collection of data designed to be used by different people is called:
- Database
- RDBMS
- DBMS
- none of these.