Database Dynamo Quiz: Test Your Data Skills! Quiz

1. Question 1

   What Python library is commonly used for connecting to and interacting with relational databases like MySQL and PostgreSQL?

   1. Requests
   2. Pandas
   3. SQLAlchemy
   4. NumPy
   5. Soupify

2. Question 2

   Which SQL command is used to retrieve data from one or more tables in a database?

   1. UPDATE
   2. SELECT
   3. INSERT
   4. DELETE
   5. CREATE

3. Question 3

   What does the acronym ORM stand for in the context of database interactions?

   1. Object Relational Mapping
   2. Object Rendering Model
   3. Ordered Resource Management
   4. Object Request Manager
   5. Operational Routing Mechanism

4. Question 4

   Which of the following is a common data serialization format often used for transmitting data between a server and a web application?

   1. YAML
   2. CSV
   3. XML
   4. JSON
   5. pickle

5. Question 5

   What is the purpose of a 'WHERE' clause in an SQL query?

   1. To specify the columns to retrieve
   2. To sort the results
   3. To filter the results based on a condition
   4. To group the results
   5. To join tables

6. Question 6

   Which SQL keyword is used to sort the result-set of a query?

   1. GROUP BY
   2. SORT
   3. FILTER
   4. ORDER BY
   5. ARRANGE

7. Question 7

   In database terms, what does 'CRUD' stand for?

   1. Create, Read, Update, Delete
   2. Calculate, Render, Update, Display
   3. Connect, Request, Upgrade, Disconnect
   4. Copy, Rename, Upload, Download
   5. Compile, Run, Utilize, Debug

8. Question 8

   Which method is commonly used in Python's SQLAlchemy to execute a raw SQL query?

   1. .execute()
   2. .query()
   3. .commit()
   4. .connect()
   5. .fetch()

9. Question 9

   What is the primary key in a database table?

   1. A foreign key's alternate name.
   2. A unique identifier for each record.
   3. An index on a frequently used column.
   4. A column used for sorting data.
   5. The largest value in a column.

10. Question 10

    What is a common vulnerability that can occur when building SQL queries by directly concatenating user input without proper sanitization?

    1. Cross-Site Scripting
    2. Buffer Overflow
    3. SQL Injection
    4. Denial of Service
    5. Session Hijacking