SQL Basics With AI

End-of-lesson check

15 questions · take it digitally for instant feedback at tendril.neural-forge.io/learn/quiz/end-progx-sql-basics-builders

1. Which SQL keyword is used to filter rows based on specific conditions?

   1. ORDER BY
   2. WHERE
   3. GROUP BY
   4. JOIN

2. What does a Seq Scan (sequential scan) in EXPLAIN output typically indicate?

   1. The database is combining two tables incorrectly
   2. The query failed due to a syntax error
   3. The database is using an index to quickly locate rows
   4. The database is reading every row in the table to find matches

3. Why is concatenating user input directly into SQL queries dangerous?

   1. It causes the database to run out of memory
   2. It can allow attackers to inject malicious SQL code
   3. It slows down the query significantly
   4. It automatically creates duplicate records

4. Which SQL keyword is used to combine rows from two or more tables based on a related column?

   1. JOIN
   2. GROUP BY
   3. WHERE
   4. SELECT

5. What does the GROUP BY clause do in a SQL query?

   1. It sorts results in alphabetical order
   2. It groups rows that have the same values into summary rows
   3. It removes all duplicate rows from results
   4. It limits the number of rows returned

6. When you run EXPLAIN ANALYZE on a slow query, what should you look for first?

   1. The exact number of rows in the database
   2. The names of all columns in the table
   3. The password used to connect to the database
   4. Whether a Seq Scan is occurring on a large table

7. What is a parameterized query?

   1. A query that uses placeholders for user input, treated as data not code
   2. A query that returns results in random order
   3. A query that automatically groups results together
   4. A query that runs faster on all databases

8. The lesson describes SQL queries having a 'shape.' What does this shape represent?

   1. The physical storage format of data on disk
   2. The color scheme of the database interface
   3. The logical structure: which tables, how filtered, how grouped, how sorted, how limited
   4. The number of developers who wrote the query

9. Why is AI considered particularly good at writing SQL?

   1. AI has analyzed millions of examples and solutions
   2. AI runs SQL faster than databases
   3. AI can physically access the database
   4. AI automatically creates indexes

10. What does the LIMIT clause control in a SQL query?

    1. The number of tables that can be joined
    2. The number of columns that can be selected
    3. The maximum size of each cell
    4. The maximum number of rows returned

11. Which of the following is a security best practice when building SQL queries with user input?

    1. Add more indexes to every column
    2. Always use SELECT * for faster results
    3. Use parameterized queries instead of string concatenation
    4. Remove all WHERE clauses for security

12. You notice a query scanning 50 million rows with a Seq Scan. What should you do?

    1. Switch to a different database system
    2. Write the query in a different programming language
    3. Delete half the rows to make the table smaller
    4. Add an index on the columns being filtered or joined

13. What must be true about the 'shape' of every SELECT query?

    1. It must use all five keywords: SELECT, FROM, WHERE, GROUP BY, ORDER BY
    2. It must include at least one JOIN
    3. It must include a FROM clause specifying the source table
    4. It must return results in descending order

14. Your AI-generated SQL query works but runs slowly on a large table. What should you verify?

    1. Ask the AI to rewrite it in Python instead
    2. Delete the database and start over
    3. Use more WHERE conditions to filter results
    4. Run EXPLAIN ANALYZE to check for inefficient table scans

15. Which four SQL keywords does the lesson identify as fundamental to data queries?

    1. INSERT, UPDATE, DELETE, CREATE
    2. SELECT, WHERE, JOIN, GROUP BY
    3. ALTER, DROP, TRUNCATE, MERGE
    4. BEGIN, COMMIT, ROLLBACK, SAVEPOINT