Database Management Systems Quiz

What is a file-based data management system?

• A type of software that allows users to access and organize small groups of data.

• A software application through which a user interacts with a database.

• A collection of data related in a logical manner.

• A system which allows users to have complete control over the DB.

What is a database management system (DBMS)?

• Software that helps users create, manage, and access data in a database.

• A type of software that maintains whole files in a storage medium.

• A collection of data related in a logical manner.

• A system which allows users to have complete control over the DB.

What are the limitations of a file-based approach?

• No recovery, inefficient, no simultaneous access, separation and isolation, duplication, data dependence, fixed queries.

• Allows for efficient retrieval, insertion, update, and management of data.

• Provides information necessary for managing organisations effectively.

• Handles the daily transactions of an organisation.

What is the role of a database in modern computing?

• To manage data efficiently and ensure integrity.

• To provide a paper-based filing system.

• To store data in text files.

• To create redundancy in data storage.

What is the importance of data in computing?

• Data serves as input that is processed by a computer to generate output.

• Data is irrelevant in programming.

• Data is only useful when stored in text files.

• Data does not influence decision-making processes.

What is the transformation process of data into information?

• Contextualisation, categorisation, calculation, correction, and condensation.

• Storing data in text files.

• Creating redundancy in data storage.

• Using paper-based filing systems.

What are the types of information systems?

• Transaction Processing Systems, Management Information Systems, Decision Support Systems.

• File-based systems, paper-based systems.

• Data storage systems, text file systems.

• None of the above.

What is the significance of databases in big data and analytics?

• Databases handle large volumes of data with speed and efficiency.

• Databases are not useful for analytics.

• Databases only store data in text files.

• Databases do not support real-time operations.

Describe the use of transactions, states and updates to maintain data consistency (and integrity).

Define the term database transaction.