{"id":173,"date":"2017-04-21T19:15:09","date_gmt":"2017-04-21T19:15:09","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/back-matter\/section-4-answer-key\/"},"modified":"2017-04-27T18:52:20","modified_gmt":"2017-04-27T18:52:20","slug":"section-4-answer-key","status":"publish","type":"back-matter","link":"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/back-matter\/section-4-answer-key\/","title":{"raw":"Section 4 Answer Key","rendered":"Section 4 Answer Key"},"content":{"raw":"
\r\n

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

                                  Return<\/a><\/h1>\r\n<\/div>","rendered":"
                                  \n

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

                                                                  Return<\/a><\/h1>\n<\/div>\n\n\t\t\t
                                                                  \n\t\t\t

                                                                  Candela Citations<\/h3>\n\t\t\t\t\t
                                                                  \n\t\t\t\t\t\t
                                                                  \n\t\t\t\t\t\t\t
                                                                  CC licensed content, Shared previously<\/div>