Database Management Systems Quiz

What is a Database Management System (DBMS)?

• A software for managing databases

• A network protocol

• A type of hardware

• A programming language

Which of the following is NOT a characteristic of a database?

• Data Redundancy Control

• Data Integrity

• Data Fragmentation

• Data Security

What does SQL stand for?

• Sequential Query Language

• Structured Query Language

• Simple Query Language

• Standard Query Language

Which of the following is an example of a Relational DBMS?

• Neo4j

• MySQL

• MongoDB

• Cassandra

What is the primary purpose of metadata?

• To store data

• To visualize data

• To encrypt data

• To describe data properties

Which of the following describes a one-to-many relationship?

• Each entity is associated with exactly one other entity

• Multiple entities are associated with one entity

• No entities are associated

• One entity is associated with multiple entities

What is the main advantage of using a DBMS?

• Centralized data management

• Higher costs

• Manual data processing

• Increased data redundancy

Which of the following is a disadvantage of DBMS?

• High overhead costs

• Improved data security

• Increased data integrity

• Simplified data access

What does the term 'data independence' refer to?

• The ability to change data without affecting applications

• The ability to secure data from unauthorized access

• The ability to store data in different formats

• The ability to access data from multiple sources

Which of the following is a type of database model?

• Static Model

• Hierarchical Model

• Linear Model

• Circular Model