4.2: Section 4 Quiz

Section 4 Questions

[1]

Take this quiz online!

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!]

Return