MIS - Database Management Concepts Quiz

What is the main advantage of using a Database Management System (DBMS) over traditional file systems?

• It increases data redundancy

• It makes programs dependent on data

• It allows central management of data and improves security

• It stores data only in text format

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

• Data is stored as documents

• Data is organized in two-dimensional tables

• Data is only accessible through web servers

• Data cannot be linked across different tables

What is the purpose of a primary key in a relational database?

• To store large multimedia files

• To ensure each record is unique

• To connect servers

• To perform backups

What does OLAP stand for?

• Online Logical Accounting Process

• Offline Learning Access Protocol

• Online Analytical Processing

• Organizational Learning and Planning

What is the main role of data mining in business intelligence?

• Backing up databases

• Discovering patterns and relationships in data

• Formatting web pages

• Removing duplicate files

Which tool is used for storing large volumes of unstructured data across distributed machines?

• OLAP

• SQL

• Hadoop

• Access

What is a data mart?

• A temporary database

• A subset of a data warehouse designed for specific users

• A type of NoSQL system

• A hardware device

What is the purpose of data normalization?

• To speed up backups

• To increase redundancy

• To streamline data and reduce redundancy

• To create duplicate data

Which of the following best defines data quality audit?

• Backing up old data

• Verifying data availability

• Structured survey of accuracy and completeness of data

• Formatting data for presentation

What is referential integrity in databases?

• Limiting access to only admin users

• Ensuring consistency of relationships between tables

• Archiving outdated data

• Encrypting table contents