Y13 Quick Quiz - Understanding Database Management Systems

What is the primary purpose of a Database Management System (DBMS)?

• To create graphical user interfaces

• To store, retrieve, and manage data efficiently

• To compile programming code

• To design network protocols

Which of the following is an example of a relational database management system?

• MongoDB

• Oracle

• Redis

• Neo4j

In a relational database, what is a primary key?

• A field that uniquely identifies each record in a table

• A field that can have duplicate values

• A field used to store large binary objects

• A field that is used to index data for faster retrieval

What does SQL stand for?

• Structured Query Language

• Simple Query Language

• Standard Query Language

• Systematic Query Language

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

• It uses tables to store data

• It is designed for structured data only

• It is schema-less

• It requires SQL for data manipulation

What is the function of a foreign key in a database?

• To ensure data integrity by linking tables

• To store encrypted data

• To increase the speed of data retrieval

• To define the structure of a database

Which of the following operations is not a part of the CRUD operations in a DBMS?

• Create

• Read

• Update

• Delete

• Analyse

What is normalisation in the context of databases?

• The process of backing up data

• The process of organising data to reduce redundancy

• The process of encrypting data

• The process of indexing data for faster retrieval

Which SQL command is used to remove a table from a database?

• DELETE

• DROP

• REMOVE

• TRUNCATE

In a database transaction, what does the acronym ACID stand for?

• Atomicity, Consistency, Isolation, Durability

• Accuracy, Consistency, Integrity, Durability

• Atomicity, Concurrency, Isolation, Dependability

• Accuracy, Concurrency, Integrity, Dependability