Database Management Systems Quiz

What is a Database Management System (DBMS)?

• A software for managing databases

• A type of hardware

• A programming language

• A network protocol

Which of the following is a characteristic of a database?

• Data redundancy

• Data inconsistency

• Data integrity

• Data isolation

What does SQL stand for?

• Standard Query Language

• Sequential Query Language

• Structured Query Language

• Simple 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 describe data properties

• To store data

• To encrypt data

• To delete data

Which architecture separates the user interface from the database

• All of the above

• Single-tier architecture

• Two-tier architecture

• Three-tier architecture

What is the main advantage of using a DBMS?

• Increased data redundancy

• Limited data access

• Centralized data management

• Manual data processing

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

• Entity

• Attribute

• Relationship

• Weak entity

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

• Hierarchical Model

• Linear Model

• Relational Model

• Object-oriented Model

What does data independence refer to?

• Separation of data from applications

• Data being stored in multiple locations

• Data being encrypted

• Data being unstructured