Quiz on Introduction to Databases for Beginners

📚 Quick Study Guide

• 💾 What is a Database? A database is an organized collection of structured information, or data, typically stored electronically in a computer system.
• 🧮 Database Management System (DBMS): A DBMS is software that allows users to define, create, maintain, and control access to the database. Examples include MySQL, PostgreSQL, and MongoDB.
• 🔑 Key Concepts:
  • 🧱 Tables: Data is organized into tables, which are similar to spreadsheets.
  • 🗂️ Rows (Records): Each row represents a single entry in the table.
  • 📊 Columns (Fields): Each column represents a specific attribute of the data.
  • 🔗 Primary Key: A unique identifier for each row in a table.
  • ↔️ Foreign Key: A field in one table that refers to the primary key of another table, establishing a relationship between them.
• ➕ Basic SQL Commands:
  • `SELECT`: Retrieves data from the database.
  • `INSERT`: Adds new data into the database.
  • `UPDATE`: Modifies existing data in the database.
  • `DELETE`: Removes data from the database.
• 📈 Normalization: The process of organizing data in a database to reduce redundancy and improve data integrity.
• 🛡️ ACID Properties (Atomicity, Consistency, Isolation, Durability): A set of properties that guarantee reliable transaction processing.

🧪 Practice Quiz

1. Which of the following is the best definition of a database?
   1. A collection of disorganized data.
   2. A system for managing files on a computer.
   3. An organized collection of structured information.
   4. A type of computer hardware.
2. What does DBMS stand for?
   1. Data Business Management System
   2. Database Management System
   3. Digital Marketing Business Solution
   4. Data Manipulation and Backup System
3. In a database table, what is a row also known as?
   1. Field
   2. Attribute
   3. Record
   4. Key
4. Which of the following is NOT a basic SQL command?
   1. SELECT
   2. INSERT
   3. UPDATE
   4. CREATE
5. What is the purpose of a primary key?
   1. To establish relationships between tables.
   2. To uniquely identify each row in a table.
   3. To store passwords securely.
   4. To improve database performance.
6. What is normalization in the context of databases?
   1. The process of backing up the database.
   2. The process of converting data into a standard format.
   3. The process of organizing data to reduce redundancy.
   4. The process of encrypting sensitive data.
7. Which ACID property ensures that a transaction is processed in its entirety or not at all?
   1. Atomicity
   2. Consistency
   3. Isolation
   4. Durability