Understanding Databases and DBMS

What is a database?

• A software that manages and manipulates data

• An organised collection of data

• A programming language for data analysis

• A type of computer hardware

Which of the following is an example of a DBMS?

• Microsoft Excel

• MySQL

• Google Chrome

• Adobe Photoshop

What does DDL stand for in the context of a DBMS?

• Data Description Language

• Data Definition Language

• Data Development Language

• Data Deployment Language

Which feature of a DBMS allows users to add, modify, delete, and query data?

• Data Definition Language (DDL)

• Data Manipulation Language (DML)

• Data Control Language (DCL)

• Data Query Language (DQL)

What is the primary purpose of access control in a DBMS?

• To enhance the speed of data retrieval

• To provide user authentication and permissions

• To increase the storage capacity of the database

• To improve the graphical interface of the database

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

• Accessible through the internet

• Requires robust security measures

• Stored on a single system or network

• Allows remote access from anywhere

What is the main difference between a database and a DBMS?

• A database is software, while a DBMS is hardware

• A database is a collection of data, while a DBMS is software to manage it

• A database is used for data analysis, while a DBMS is used for data storage

• A database is a type of programming language, while a DBMS is a type of software

Which of the following is NOT a feature of a DBMS?

• Data storage

• Data retrieval

• Data visualisation

• Data security

What type of database is accessible through the internet?

• Local database

• Online database

• Distributed database

• Centralised database

Which of the following is an example of data that might be stored in a business database?

• User profiles and posts

• Customer names and purchase histories

• Weather forecasts and climate data

• Scientific research articles