0 / 20 answered

1. 1. What is a database?

   What is a database?

   An organized collection of data An HTTP method A PHP comment A CSS layout
   Hint

   Identify what the command or language feature is responsible for.

2. 2. What characterizes a relational database?

   What characterizes a relational database?

   It contains only images It has no schema Data is organized into related tables All data is stored in one text file
   Hint

   Identify what the command or language feature is responsible for.

3. 3. What does a database table represent?

   What does a database table represent?

   A collection of related rows with defined columns A PHP function A WordPress theme A browser tab
   Hint

   Identify what the command or language feature is responsible for.

4. 4. What is a row in a relational table?

   What is a row in a relational table?

   The table definition A CSS selector One record A database server
   Hint

   Identify what the command or language feature is responsible for.

5. 5. What does a column define?

   What does a column define?

   A complete website A user session A named field and its kind of data A PHP namespace
   Hint

   Identify what the command or language feature is responsible for.

6. 6. What is the purpose of a primary key?

   What is the purpose of a primary key?

   Encrypt every value Uniquely identify each row Sort every query automatically Store HTML templates
   Hint

   Identify what the command or language feature is responsible for.

7. 7. What does a foreign key express?

   What does a foreign key express?

   A relationship to a key in another table A translated column A database password A temporary query
   Hint

   Identify what the command or language feature is responsible for.

8. 8. Which SQL command retrieves data?

   Which SQL command retrieves data?

   DELETE SELECT INSERT UPDATE
   Hint

   Identify what the command or language feature is responsible for.

9. 9. Which SQL command adds a new row?

   Which SQL command adds a new row?

   INSERT SELECT DROP ORDER BY
   Hint

   Identify what the command or language feature is responsible for.

10. 10. Which SQL command changes existing rows?

    Which SQL command changes existing rows?

    UPDATE JOIN CREATE SELECT
    Hint

    Identify what the command or language feature is responsible for.

11. 11. Which SQL command removes matching rows?

    Which SQL command removes matching rows?

    ALTER GROUP BY DELETE SELECT
    Hint

    Identify what the command or language feature is responsible for.

12. 12. What is a WHERE clause used for?

    What is a WHERE clause used for?

    Restricting which rows a statement affects Renaming the database server Defining PHP variables Formatting HTML
    Hint

    Identify what the command or language feature is responsible for.

13. 13. What does ORDER BY control?

    What does ORDER BY control?

    The order of query results User permissions Table encryption PHP execution order
    Hint

    Identify what the command or language feature is responsible for.

14. 14. What does LIMIT commonly control?

    What does LIMIT commonly control?

    The number of table columns The database password length The maximum number of rows returned or affected in a result window The PHP memory limit
    Hint

    Identify what the command or language feature is responsible for.

15. 15. What does an INNER JOIN return?

    What does an INNER JOIN return?

    Every row from both tables regardless of matches Rows with matching join conditions in both joined sources Only table definitions Only deleted rows
    Hint

    Identify what the command or language feature is responsible for.

16. 16. What does a LEFT JOIN preserve?

    What does a LEFT JOIN preserve?

    No null values Only rows with matches on both sides Only the right table Every selected row from the left table, even without a right-side match
    Hint

    Identify what the command or language feature is responsible for.

17. 17. What does NULL represent in SQL?

    What does NULL represent in SQL?

    An empty string in every case The number zero A missing or unknown value A deleted table
    Hint

    Identify what the command or language feature is responsible for.

18. 18. What is a database index primarily used for?

    What is a database index primarily used for?

    Storing PHP functions Speeding up supported lookups and ordering at a storage cost Replacing primary data Rendering HTML
    Hint

    Identify what the command or language feature is responsible for.

19. 19. What is SQL injection?

    What is SQL injection?

    A database backup A slow SELECT query Untrusted input changing the intended structure of a query A CSS attack
    Hint

    Identify what the command or language feature is responsible for.

20. 20. Why use parameterized or prepared queries?

    Why use parameterized or prepared queries?

    They automatically grant database access They keep data values separate from SQL structure They create indexes for each value They remove every need for validation
    Hint

    Identify what the command or language feature is responsible for.