Database Design and Development

What is the key difference between data and information?

• Data is processed information

• Information is raw, unprocessed facts

• Data is unprocessed, while information is processed and meaningful

• Both terms mean the same

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

• To store raw data only

• To process and manipulate data efficiently

• To replace spreadsheets completely

• To ensure a database is never modified

Which of the following is NOT an advantage of using a DBMS?

• Improved data security

• Increased data redundancy

• Efficient data retrieval

• Multi-user access control

What type of database stores data in interrelated tables?

• NoSQL database

• Relational database

• Network database

• Hierarchical database

What language is commonly used to interact with relational databases?

• Python

• Java

• SQL

• HTML

Which of the following is an example of a NoSQL database?

• MySQL

• PostgreSQL

• MongoDB

• Microsoft SQL Server

What type of database supports multiple users accessing data simultaneously?

• Single-user database

• Multi-user database

• Centralized database

• None of the above

What is the purpose of a Data Dictionary in a DBMS?

• It stores definitions of data elements and relationships

• It contains raw data records

• It replaces a relational schema

• It executes SQL queries

Which of the following best defines data redundancy?

• The process of normalizing a database

• Storing the same data multiple times unnecessarily

• Efficient data management practice

• Data being stored in a single location

What is an entity in a database?

• A database table

• An object about which data is collected

• A function in a DBMS

• A type of data redundancy