Database Basics Quiz SJ

What is the difference between data and information?

• Data is used for decision making, while information is not

• Data depends on information, while information depends on data

• Data is raw material, while information carries meaning

• Data is structured, while information is unstructured

What is structured data?

• Data that lacks a predefined structure

• Data organized in a predefined structure like databases

• Data that can take any value within a range

• Data available in numerical form

What is the difference between quantitative and qualitative data?

• Quantitative data represents categories, while qualitative data represents numerical values

• Quantitative data is difficult to analyze, while qualitative data is easy to analyze

• Quantitative data includes numbers, while qualitative data includes categories

• Quantitative data is descriptive, while qualitative data is numerical

What is a database?

• A tool for generating reports

• A structured collection of data stored electronically

• A system for managing files

• A collection of unstructured information

What is a relational database?

• A database with no relationships between tables

• A database organized into tables of rows and columns

• A database with only one table

• A database without a management system

What are the drawbacks of using file systems to store data?

• Data redundancy and inconsistency, difficulty in accessing data, integrity problems

• Structured data, unstructured data, quantitative data

• Atomicity of updates, security problems, concurrent access by multiple users

• Physical level, logical level, view level

What is the physical level in database design?

• Describes the relationships among the data

• Describes how a record is stored

• Describes the overall logical structure of a database

• Describes data stored in the database

What is the purpose of an ER diagram?

• To represent the overall logical structure of a database graphically

• To analyze data using SQL

• To create reports from database queries

• To store data in a structured manner

What is the use of aggregation in database design?

• To represent relationships as higher-level entity sets

• To create relationships between entities

• To store data in a tabular form

• To manage data redundancy

Why is Excel commonly used?

• For creating ER diagrams and database designs

• For managing file systems and storing data

• For physical design and logical design in databases

• For data analysis, data entry, and data management