CCS QUIZ BEE - DBMS Quiz

What is a database management system (DBMS)?

• A system that does not support multi-user environment

• A system that manages data in a way that makes it easier to retrieve, manipulate, and produce information

• A system that only stores data in file formats

• A system that does not have query language

What is the main characteristic of a modern DBMS?

• Real-world entity

• Data redundancy

• Lack of query language

• Inconsistency

What does the term 'ACID Properties' refer to in DBMS?

• Atomicity, Consistency, Isolation, Durability

• Data redundancy, Inconsistency, Consistency, Isolation

• Atomicity, Data redundancy, Isolation, Durability

• Consistency, Isolation, Durability, Atomicity

What is the purpose of a primary key in a database?

• Uniquely identify an entity in an entity set

• Store metadata about the database

• Define the logical constraints of the database

• Provide security features to restrict user access

What is the significance of Generalization and Specialization in the ER Model?

• Generalization and Specialization are used for physical data independence

• Generalization and Specialization have no impact on the ER Model

• Generalization adds redundancy to the database, while Specialization removes redundancy

• Generalization groups entities based on similar characteristics, while Specialization divides entities into sub-groups

What is the primary data model used widely around the world for data storage and processing?

• Hierarchical data model

• Object-oriented data model

• Network data model

• Relational data model

Which type of join combines tuples from different relations based on a given condition?

• Theta Join

• Outer Join

• Equijoin

• Natural Join

What is the purpose of RAID 1 in Redundant Array of Independent Disks (RAID)?

• Byte-level striping

• Striped array of disks

• Mirroring technique

• Error Correction Code

Which file organization does not support any ordering, sequencing, or indexing on its own?

• Hash File Organization

• Clustered File Organization

• Sequential File Organization

• Heap File Organization

What is the main purpose of normalization in a database?

• To store data in an inconsistent state

• To introduce anomalies

• To remove anomalies and bring the database to a consistent state

• To increase the complexity of the database