Section 4 Answer Key

  1. What does SQL stand for?
    1. Standard Query Linguistics [Incorrect]
    2. Structured Query Language [Correct!]
    3. Strict Query Language [Incorrect]
    4. None of the above [Incorrect]
  2. Which of these is used to retrieve information from a database?
    1. Get [Incorrect]
    2. Fetch [Incorrect]
    3. Select [Correct!]
    4. Find [Incorrect]
  3. Which of these commands would get the name column from a Persons table?
    1. Select name from Persons; [Correct!]
    2. Get persons.name [Incorrect]
    3. Select persons.name [Incorrect]
    4. Get name from Persons [Incorrect]
  4. Which of the following select records where the name fields starts with an A?
    1. Select * from Persons where name=’a’ [This will get names that are only a]
    2. Select * from Persons where name like “a%” [Correct!]
    3. Select * from Persons where name like “%a” [This will select things that end in a]
    4. None of these [Incorrect]
  5. Which of the following is the keyword used to sort results?
    1. Order By [Correct!]
    2. Sort By [Incorrect]
    3. Filter By [Incorrect]
    4. Ascending [Incorrect]
  6. Which of the following is used to find the number of records?
    1. Total() [Incorrect]
    2. Count() [Correct!]
    3. Sum() [Incorrect]
    4. None of these [Incorrect]
  7. Eliminating multiple identical columns from a table is which normalization?
    1. First [Correct!]
    2. Second [Incorrect]
    3. Third [Incorrect]
    4. Fourth [Incorrect]
  8. Eliminating repeated values from a table is which normalization?
    1. First [Incorrect]
    2. Second [Correct!]
    3. Third [Incorrect]
    4. Fourth [Incorrect]
  9. Ensuring no values are repeated in a database is which of the following?
    1. First [Incorrect]
    2. Second [Incorrect]
    3. Third [Correct!]
    4. Fourth [Incorrect]
  10. Ensuring all fields relate directly to the table they are in is which normalization?
    1. First [Incorrect]
    2. Second [Incorrect]
    3. Third [Correct!]
    4. Fourth [Incorrect]
  11. The CRUD actions are:
    1. Compose, Read, Update, Delete [Incorrect]
    2. Create, Read, Update, Destroy [Incorrect]
    3. Create, Read, Update, Delete [Correct!]
    4. Copy, Read, Update, Drop [Incorrect]
  12. Including all of the records in the first table of a join is done using:
    1. Join all [Incorrect]
    2. Left join [Correct!]
    3. Right join [Incorrect]
    4. None of these [Incorrect]
  13. Queries can be placed inside of other queries.
    1. True [Correct!]
    2. False [Incorrect]
  14. Which of the following is used to remove a record from a table?
    1. Delete from [Correct!]
    2. Drop from [Incorrect]
    3. Destroy [Incorrect]
  15. MySQL requires which of the following to run?
    1. Windows [Incorrect]
    2. Linux [Incorrect]
    3. Apple [Incorrect]
    4. Any of these [Correct!]