DBMS: Computer Awareness MCQ Practice Questions

• Topic: DBMS
• Number of Questions: 10
• Target: SBI PO, SBI Clerk, RBI Assistant, IBPS PO, IBPS Clerk, SSC CGL, SSC GD, SSC CPO, SSC MTS, SSC CHSL, Railways, etc.

Let’s Start

1. ________ is a piece of software used to store, manage, and extract data from a database..

1. Data dictionary
2. Database management system (DBMS)
3. Decision support system
4. Relational Database

2. In the client/server architecture, the database ………………

1. is downloaded to the client upon request
2. is shared by both client & server
3. resides on the client-side
4. resides on the server-side

3. Hierarchical Database’s major drawback is

1. Limited capacity (unable to hold much data)
2. Limited flexibility in accessing data
3. Overhead associated with maintaining indexes
4. The performance of the database is poor

4. Which component of the database management system has the most impact on the ability to handle massive issues? (scalability)?

1. Data storage subsystem
2. database engine
3. query processor
4. security subsystem

5. ________________ is/are the benefits of a database management system

1. Improved ability to enforce standards
2. improved data consistency
3. local control over the data
4. all of the above

6. _____________ defines the database’s business requirements

1. Association (or relationship)
2. Attributes
3. properties
4. secondary keys

7. The database’s consistency is maintained by ________________

1. commit
2. atomic
3. flashback
4. retain

8. ________________ isn’t really a stage in the development of a database.

1. physical database design
2. conceptual data modelling
3. logical database design
4. DBMS selection

9. _____________ phase is a development input for ER modelling..

1. physical database design
2. conceptual data modelling
3. logical database design
4. distributed database design

10. During the ___________ development phase, logical database design occurs..

1. systems implementation
2. systems design
3. systems design & system implementation
4. systems analysis