Database Management Systems Quiz

What is a Database Management System (DBMS)?

• A type of hardware

• A network protocol

• A software for managing databases

• A programming language

Which of the following is a characteristic of a database?

• Data redundancy

• Data inconsistency

• Data integrity

• Data isolation

What does SQL stand for?

• Structured Query Language

• Simple Query Language

• Standard Query Language

• Sequential Query Language

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

• MongoDB

• MySQL

• Cassandra

• Neo4j

What is the primary purpose of metadata?

• To store user data

• To perform data analysis

• To describe data properties

• To manage database security

Which architecture separates the user interface from the database?

• 2-tier architecture

• 4-tier architecture

• 1-tier architecture

• 3-tier architecture

What is the main advantage of using a DBMS?

• Increased data redundancy

• Centralized data management

• Manual data processing

• Limited user access

What type of relationship is represented by a diamond shape in an ER diagram?

• Attribute

• Entity

• Weak entity

• Relationship

Which of the following is NOT a type of database model?

• Linear Model

• Hierarchical Model

• Relational Model

• Object-oriented Model

What does data independence refer to?

• Data redundancy

• Data stored in multiple locations

• Data security measures

• Separation of data from applications