Database Management System Quiz

Which of the following is NOT a primary characteristic of the database approach?

• Data redundancy is minimized

• Data independence is achieved

• Data is stored in isolated files

• Data is shared across different applications

In the database approach, what is meant by 'data independence'?

• The ability to separate data from the applications that use it

• The ability to keep data isolated within a single application

• The ability to access data from multiple sources

• The ability to modify the data without affecting the storage medium

Which of the following is a major advantage of the database approach over the filesystem approach?

• Higher redundancy

• Increased data consistency

• Lower security

• Difficulty in managing large datasets

What role does a 'DBMS' (Database Management System) play in the database approach?

• Provides a framework for developing applications

• Acts as an interface between the user and the physical database

• Defines the logical structure of the data

• Stores the data in external files

What does 'concurrency control' in a database system ensure?

• That users can access the database in a sequential manner

• That multiple users can access and modify the database simultaneously without conflicts

• That users are prevented from accessing the database simultaneously

• That the database is backed up regularly

In a database approach, what is a 'schema'?

• A table that holds the data

• The physical storage of data

• A blueprint of the database structure, including the relationships between entities

• A program that processes the database queries

Which of the following is a characteristic of a 'relational database'?

• Data is stored as files

• Data is stored in tables with rows and columns

• Data is stored in a hierarchical tree structure

• Data is stored in unstructured formats

In the context of the database approach, which of the following is true about 'data integrity'?

• It ensures that the data is accurate and consistent across the database

• It ensures that the data can be accessed by unauthorized users

• It ensures that there is no data redundancy

• It ensures that the data is stored in multiple locations

Which of the following is a feature of a 'centralized' database approach?

• The data is distributed across multiple locations

• All data is stored in a single location or server

• Each user has a separate, isolated database

• Data is replicated across many servers for faster access

What does 'normalization' in the database approach aim to achieve?

• Increased data redundancy

• Eliminate data anomalies and reduce redundancy

• Optimize database queries for performance

• Store data in a denormalized form for easier access