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
31. Which of the following is a characteristic of the data in a database?
- shared
- secure
- independent
- all of these
32. Which of the following is the database management activity of coordinating the actions of database manipulation processes that operate concurrently, acess shared and can potentially interfere with each other?
- concurrency management
- database management
- transaction management
- information management.
33. An object-oriented DBMS is cabpable of holding:
- data and text
- pictures and images
- voice and video
- all of the above
34. Which of the following is an object-oriented feature?
- inheritance
- abstraction
- polymorphism
- all of these
35. Immunity of the conceptual (or external)schemas to changes in the internal schema is referred to as
- Physical data independence
- locigal data independence
- both (a) and (b)
- None of these
36. A physical data models are used to:
- spicify overall logical structure of the database
- describe data and its relationships
- higher-level description of storage structure and access mechanism
- all of these
37. Immunity of the external schemas (or application programs) to changes in the conceptual schema is referred to as:
- physical data independence
- logical data independence
- both (a) and (b)
- none of these
38. A record-based data models are used to:
- specify overall logical structure of the database
- describe data and its relationships
- higher-level description of storage structure and access mechanism
- all of these
39. An object-oriented data model are used to:
- specify overall logical structure of the database
- describe data and its relationships
- higher-level description of storage structure and access mechanism
- all of these.
40. The relational data model was first introduced by:
- SPARC
- E.F. Cord
- ANSI
- Chem.