{"id":806,"date":"2017-07-25T21:09:25","date_gmt":"2017-07-25T21:09:25","guid":{"rendered":"http:\/\/localhost\/~tompntn\/AHP\/fresh_wp\/?page_id=806"},"modified":"2017-08-25T17:19:05","modified_gmt":"2017-08-25T17:19:05","slug":"sql","status":"publish","type":"page","link":"https:\/\/www.afterhoursprogramming.com\/tests\/sql\/","title":{"rendered":"SQL Quiz"},"content":{"rendered":"<div id=\"watu_quiz\" class=\"quiz-area \">\n<p><p>The SQL quiz determines whether you understand the fundamentals of this database language. Once you pass the SQL quiz with a high enough score, you should move onto more tutorials to get a more well-rounded knowledge of web development. This test is MySQL syntax, which might change your answers on a few questions.<\/p>\n<\/p><form action=\"\" method=\"post\" class=\"quiz-form \" id=\"quiz-6\" >\n<div class='watu-question' id='question-1'><div class='question-content'><p><span class='watu_num'>1. <\/span>What type of query gets information from a database? <\/p>\n<\/div><input type='hidden' name='question_id[]' value='129' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='507' \/><div class='watu-question-choice'><input type='radio' name='answer-129[]' id='answer-id-507' class='answer answer-1  answerof-129' value='507' \/>&nbsp;<label for='answer-id-507' id='answer-label-507' class=' answer label-1'><span class='answer'>SELECT<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='508' \/><div class='watu-question-choice'><input type='radio' name='answer-129[]' id='answer-id-508' class='answer answer-1  answerof-129' value='508' \/>&nbsp;<label for='answer-id-508' id='answer-label-508' class=' answer label-1'><span class='answer'>UPDATE<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='509' \/><div class='watu-question-choice'><input type='radio' name='answer-129[]' id='answer-id-509' class='answer answer-1  answerof-129' value='509' \/>&nbsp;<label for='answer-id-509' id='answer-label-509' class=' answer label-1'><span class='answer'>GET<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='510' \/><div class='watu-question-choice'><input type='radio' name='answer-129[]' id='answer-id-510' class='answer answer-1  answerof-129' value='510' \/>&nbsp;<label for='answer-id-510' id='answer-label-510' class=' answer label-1'><span class='answer'>RETRIEVE<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType1' value='radio' class='required'><\/div><div class='watu-question' id='question-2'><div class='question-content'><p><span class='watu_num'>2. <\/span>What type of query removes information from a database?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='130' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='511' \/><div class='watu-question-choice'><input type='radio' name='answer-130[]' id='answer-id-511' class='answer answer-2  answerof-130' value='511' \/>&nbsp;<label for='answer-id-511' id='answer-label-511' class=' answer label-2'><span class='answer'>REMOVE<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='512' \/><div class='watu-question-choice'><input type='radio' name='answer-130[]' id='answer-id-512' class='answer answer-2  answerof-130' value='512' \/>&nbsp;<label for='answer-id-512' id='answer-label-512' class=' answer label-2'><span class='answer'>DELETE<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='513' \/><div class='watu-question-choice'><input type='radio' name='answer-130[]' id='answer-id-513' class='answer answer-2  answerof-130' value='513' \/>&nbsp;<label for='answer-id-513' id='answer-label-513' class=' answer label-2'><span class='answer'>SUBTRACT<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='514' \/><div class='watu-question-choice'><input type='radio' name='answer-130[]' id='answer-id-514' class='answer answer-2  answerof-130' value='514' \/>&nbsp;<label for='answer-id-514' id='answer-label-514' class=' answer label-2'><span class='answer'>ELIMINATE<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType2' value='radio' class='required'><\/div><div class='watu-question' id='question-3'><div class='question-content'><p><span class='watu_num'>3. <\/span>What type of query can change content in a database?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='131' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='515' \/><div class='watu-question-choice'><input type='radio' name='answer-131[]' id='answer-id-515' class='answer answer-3  answerof-131' value='515' \/>&nbsp;<label for='answer-id-515' id='answer-label-515' class=' answer label-3'><span class='answer'>REMOVE<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='516' \/><div class='watu-question-choice'><input type='radio' name='answer-131[]' id='answer-id-516' class='answer answer-3  answerof-131' value='516' \/>&nbsp;<label for='answer-id-516' id='answer-label-516' class=' answer label-3'><span class='answer'>MODIFY<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='517' \/><div class='watu-question-choice'><input type='radio' name='answer-131[]' id='answer-id-517' class='answer answer-3  answerof-131' value='517' \/>&nbsp;<label for='answer-id-517' id='answer-label-517' class=' answer label-3'><span class='answer'>ADD<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='518' \/><div class='watu-question-choice'><input type='radio' name='answer-131[]' id='answer-id-518' class='answer answer-3  answerof-131' value='518' \/>&nbsp;<label for='answer-id-518' id='answer-label-518' class=' answer label-3'><span class='answer'>UPDATE<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType3' value='radio' class='required'><\/div><div class='watu-question' id='question-4'><div class='question-content'><p><span class='watu_num'>4. <\/span>What type of query can add new information into the database?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='132' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='519' \/><div class='watu-question-choice'><input type='radio' name='answer-132[]' id='answer-id-519' class='answer answer-4  answerof-132' value='519' \/>&nbsp;<label for='answer-id-519' id='answer-label-519' class=' answer label-4'><span class='answer'>ADD<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='520' \/><div class='watu-question-choice'><input type='radio' name='answer-132[]' id='answer-id-520' class='answer answer-4  answerof-132' value='520' \/>&nbsp;<label for='answer-id-520' id='answer-label-520' class=' answer label-4'><span class='answer'>ADJUST<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='521' \/><div class='watu-question-choice'><input type='radio' name='answer-132[]' id='answer-id-521' class='answer answer-4  answerof-132' value='521' \/>&nbsp;<label for='answer-id-521' id='answer-label-521' class=' answer label-4'><span class='answer'>APPEND<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='522' \/><div class='watu-question-choice'><input type='radio' name='answer-132[]' id='answer-id-522' class='answer answer-4  answerof-132' value='522' \/>&nbsp;<label for='answer-id-522' id='answer-label-522' class=' answer label-4'><span class='answer'>INSERT<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType4' value='radio' class='required'><\/div><div class='watu-question' id='question-5'><div class='question-content'><p><span class='watu_num'>5. <\/span>In the query &#8220;SELECT address FROM users&#8221;, what is the column being selected? <\/p>\n<\/div><input type='hidden' name='question_id[]' value='133' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='523' \/><div class='watu-question-choice'><input type='radio' name='answer-133[]' id='answer-id-523' class='answer answer-5  answerof-133' value='523' \/>&nbsp;<label for='answer-id-523' id='answer-label-523' class=' answer label-5'><span class='answer'>SELECT<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='524' \/><div class='watu-question-choice'><input type='radio' name='answer-133[]' id='answer-id-524' class='answer answer-5  answerof-133' value='524' \/>&nbsp;<label for='answer-id-524' id='answer-label-524' class=' answer label-5'><span class='answer'>address<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='525' \/><div class='watu-question-choice'><input type='radio' name='answer-133[]' id='answer-id-525' class='answer answer-5  answerof-133' value='525' \/>&nbsp;<label for='answer-id-525' id='answer-label-525' class=' answer label-5'><span class='answer'>FROM<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='526' \/><div class='watu-question-choice'><input type='radio' name='answer-133[]' id='answer-id-526' class='answer answer-5  answerof-133' value='526' \/>&nbsp;<label for='answer-id-526' id='answer-label-526' class=' answer label-5'><span class='answer'>users<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType5' value='radio' class='required'><\/div><div class='watu-question' id='question-6'><div class='question-content'><p><span class='watu_num'>6. <\/span>What is the keyword you would use before adding conditions to your query?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='134' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='527' \/><div class='watu-question-choice'><input type='radio' name='answer-134[]' id='answer-id-527' class='answer answer-6  answerof-134' value='527' \/>&nbsp;<label for='answer-id-527' id='answer-label-527' class=' answer label-6'><span class='answer'>WHAT<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='528' \/><div class='watu-question-choice'><input type='radio' name='answer-134[]' id='answer-id-528' class='answer answer-6  answerof-134' value='528' \/>&nbsp;<label for='answer-id-528' id='answer-label-528' class=' answer label-6'><span class='answer'>WHERE<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='529' \/><div class='watu-question-choice'><input type='radio' name='answer-134[]' id='answer-id-529' class='answer answer-6  answerof-134' value='529' \/>&nbsp;<label for='answer-id-529' id='answer-label-529' class=' answer label-6'><span class='answer'>EQUALS<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='530' \/><div class='watu-question-choice'><input type='radio' name='answer-134[]' id='answer-id-530' class='answer answer-6  answerof-134' value='530' \/>&nbsp;<label for='answer-id-530' id='answer-label-530' class=' answer label-6'><span class='answer'>CONDITIONS:<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType6' value='radio' class='required'><\/div><div class='watu-question' id='question-7'><div class='question-content'><p><span class='watu_num'>7. <\/span>What keyword wraps the data that you would like to insert in an INSERT query?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='135' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='531' \/><div class='watu-question-choice'><input type='radio' name='answer-135[]' id='answer-id-531' class='answer answer-7  answerof-135' value='531' \/>&nbsp;<label for='answer-id-531' id='answer-label-531' class=' answer label-7'><span class='answer'>DATA()<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='532' \/><div class='watu-question-choice'><input type='radio' name='answer-135[]' id='answer-id-532' class='answer answer-7  answerof-135' value='532' \/>&nbsp;<label for='answer-id-532' id='answer-label-532' class=' answer label-7'><span class='answer'>RAWDATA()<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='533' \/><div class='watu-question-choice'><input type='radio' name='answer-135[]' id='answer-id-533' class='answer answer-7  answerof-135' value='533' \/>&nbsp;<label for='answer-id-533' id='answer-label-533' class=' answer label-7'><span class='answer'>VALUES()<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='534' \/><div class='watu-question-choice'><input type='radio' name='answer-135[]' id='answer-id-534' class='answer answer-7  answerof-135' value='534' \/>&nbsp;<label for='answer-id-534' id='answer-label-534' class=' answer label-7'><span class='answer'>VALUE()<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType7' value='radio' class='required'><\/div><div class='watu-question' id='question-8'><div class='question-content'><p><span class='watu_num'>8. <\/span>What is the keyword you would use in an UPDATE query to modify the existing value?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='136' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='535' \/><div class='watu-question-choice'><input type='radio' name='answer-136[]' id='answer-id-535' class='answer answer-8  answerof-136' value='535' \/>&nbsp;<label for='answer-id-535' id='answer-label-535' class=' answer label-8'><span class='answer'>EDIT<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='536' \/><div class='watu-question-choice'><input type='radio' name='answer-136[]' id='answer-id-536' class='answer answer-8  answerof-136' value='536' \/>&nbsp;<label for='answer-id-536' id='answer-label-536' class=' answer label-8'><span class='answer'>SET<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='537' \/><div class='watu-question-choice'><input type='radio' name='answer-136[]' id='answer-id-537' class='answer answer-8  answerof-136' value='537' \/>&nbsp;<label for='answer-id-537' id='answer-label-537' class=' answer label-8'><span class='answer'>MAKE<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='538' \/><div class='watu-question-choice'><input type='radio' name='answer-136[]' id='answer-id-538' class='answer answer-8  answerof-136' value='538' \/>&nbsp;<label for='answer-id-538' id='answer-label-538' class=' answer label-8'><span class='answer'>WRITE<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType8' value='radio' class='required'><\/div><div class='watu-question' id='question-9'><div class='question-content'><p><span class='watu_num'>9. <\/span>If you want to apply a second condition to your statement where both statements must be true, what keyword would you use between the conditions?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='137' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='539' \/><div class='watu-question-choice'><input type='radio' name='answer-137[]' id='answer-id-539' class='answer answer-9  answerof-137' value='539' \/>&nbsp;<label for='answer-id-539' id='answer-label-539' class=' answer label-9'><span class='answer'>AND<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='540' \/><div class='watu-question-choice'><input type='radio' name='answer-137[]' id='answer-id-540' class='answer answer-9  answerof-137' value='540' \/>&nbsp;<label for='answer-id-540' id='answer-label-540' class=' answer label-9'><span class='answer'>BOTH<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='541' \/><div class='watu-question-choice'><input type='radio' name='answer-137[]' id='answer-id-541' class='answer answer-9  answerof-137' value='541' \/>&nbsp;<label for='answer-id-541' id='answer-label-541' class=' answer label-9'><span class='answer'>TRUE<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='542' \/><div class='watu-question-choice'><input type='radio' name='answer-137[]' id='answer-id-542' class='answer answer-9  answerof-137' value='542' \/>&nbsp;<label for='answer-id-542' id='answer-label-542' class=' answer label-9'><span class='answer'>WHERE<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType9' value='radio' class='required'><\/div><div class='watu-question' id='question-10'><div class='question-content'><p><span class='watu_num'>10. <\/span>To sort your results by a column name, what keyword would you use before the column name?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='138' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='543' \/><div class='watu-question-choice'><input type='radio' name='answer-138[]' id='answer-id-543' class='answer answer-10  answerof-138' value='543' \/>&nbsp;<label for='answer-id-543' id='answer-label-543' class=' answer label-10'><span class='answer'>ORDER BY<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='544' \/><div class='watu-question-choice'><input type='radio' name='answer-138[]' id='answer-id-544' class='answer answer-10  answerof-138' value='544' \/>&nbsp;<label for='answer-id-544' id='answer-label-544' class=' answer label-10'><span class='answer'>SORT BY<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='545' \/><div class='watu-question-choice'><input type='radio' name='answer-138[]' id='answer-id-545' class='answer answer-10  answerof-138' value='545' \/>&nbsp;<label for='answer-id-545' id='answer-label-545' class=' answer label-10'><span class='answer'>BY<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='546' \/><div class='watu-question-choice'><input type='radio' name='answer-138[]' id='answer-id-546' class='answer answer-10  answerof-138' value='546' \/>&nbsp;<label for='answer-id-546' id='answer-label-546' class=' answer label-10'><span class='answer'>IF<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType10' value='radio' class='required'><\/div><div class='watu-question' id='question-11'><div class='question-content'><p><span class='watu_num'>11. <\/span>What keyword would you use to group your results by a column&#8217;s values?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='139' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='547' \/><div class='watu-question-choice'><input type='radio' name='answer-139[]' id='answer-id-547' class='answer answer-11  answerof-139' value='547' \/>&nbsp;<label for='answer-id-547' id='answer-label-547' class=' answer label-11'><span class='answer'>ORDER BY<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='548' \/><div class='watu-question-choice'><input type='radio' name='answer-139[]' id='answer-id-548' class='answer answer-11  answerof-139' value='548' \/>&nbsp;<label for='answer-id-548' id='answer-label-548' class=' answer label-11'><span class='answer'>GROUP BY<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='549' \/><div class='watu-question-choice'><input type='radio' name='answer-139[]' id='answer-id-549' class='answer answer-11  answerof-139' value='549' \/>&nbsp;<label for='answer-id-549' id='answer-label-549' class=' answer label-11'><span class='answer'>BY<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='550' \/><div class='watu-question-choice'><input type='radio' name='answer-139[]' id='answer-id-550' class='answer answer-11  answerof-139' value='550' \/>&nbsp;<label for='answer-id-550' id='answer-label-550' class=' answer label-11'><span class='answer'>JOIN<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType11' value='radio' class='required'><\/div><div class='watu-question' id='question-12'><div class='question-content'><p><span class='watu_num'>12. <\/span>When sorting your results by a column&#8217;s values that are integers, what keyword would you use to sort from greatest to least?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='140' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='551' \/><div class='watu-question-choice'><input type='radio' name='answer-140[]' id='answer-id-551' class='answer answer-12  answerof-140' value='551' \/>&nbsp;<label for='answer-id-551' id='answer-label-551' class=' answer label-12'><span class='answer'>ASC<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='552' \/><div class='watu-question-choice'><input type='radio' name='answer-140[]' id='answer-id-552' class='answer answer-12  answerof-140' value='552' \/>&nbsp;<label for='answer-id-552' id='answer-label-552' class=' answer label-12'><span class='answer'>DSC<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='553' \/><div class='watu-question-choice'><input type='radio' name='answer-140[]' id='answer-id-553' class='answer answer-12  answerof-140' value='553' \/>&nbsp;<label for='answer-id-553' id='answer-label-553' class=' answer label-12'><span class='answer'>DESC<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='554' \/><div class='watu-question-choice'><input type='radio' name='answer-140[]' id='answer-id-554' class='answer answer-12  answerof-140' value='554' \/>&nbsp;<label for='answer-id-554' id='answer-label-554' class=' answer label-12'><span class='answer'>AESC<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType12' value='radio' class='required'><\/div><div class='watu-question' id='question-13'><div class='question-content'><p><span class='watu_num'>13. <\/span>If you are only retrieving one column&#8217;s values, what keyword can you add before the column name to only return unique values?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='141' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='555' \/><div class='watu-question-choice'><input type='radio' name='answer-141[]' id='answer-id-555' class='answer answer-13  answerof-141' value='555' \/>&nbsp;<label for='answer-id-555' id='answer-label-555' class=' answer label-13'><span class='answer'>UNIQUE<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='556' \/><div class='watu-question-choice'><input type='radio' name='answer-141[]' id='answer-id-556' class='answer answer-13  answerof-141' value='556' \/>&nbsp;<label for='answer-id-556' id='answer-label-556' class=' answer label-13'><span class='answer'>DISTINCT<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='557' \/><div class='watu-question-choice'><input type='radio' name='answer-141[]' id='answer-id-557' class='answer answer-13  answerof-141' value='557' \/>&nbsp;<label for='answer-id-557' id='answer-label-557' class=' answer label-13'><span class='answer'>ONE<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='558' \/><div class='watu-question-choice'><input type='radio' name='answer-141[]' id='answer-id-558' class='answer answer-13  answerof-141' value='558' \/>&nbsp;<label for='answer-id-558' id='answer-label-558' class=' answer label-13'><span class='answer'>SINGLE<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType13' value='radio' class='required'><\/div><div class='watu-question' id='question-14'><div class='question-content'><p><span class='watu_num'>14. <\/span>What keyword can you use to search for a string in a column?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='142' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='559' \/><div class='watu-question-choice'><input type='radio' name='answer-142[]' id='answer-id-559' class='answer answer-14  answerof-142' value='559' \/>&nbsp;<label for='answer-id-559' id='answer-label-559' class=' answer label-14'><span class='answer'>FIND STRING<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='560' \/><div class='watu-question-choice'><input type='radio' name='answer-142[]' id='answer-id-560' class='answer answer-14  answerof-142' value='560' \/>&nbsp;<label for='answer-id-560' id='answer-label-560' class=' answer label-14'><span class='answer'>HAS STRING<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='561' \/><div class='watu-question-choice'><input type='radio' name='answer-142[]' id='answer-id-561' class='answer answer-14  answerof-142' value='561' \/>&nbsp;<label for='answer-id-561' id='answer-label-561' class=' answer label-14'><span class='answer'>CONTAINS STRING<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='562' \/><div class='watu-question-choice'><input type='radio' name='answer-142[]' id='answer-id-562' class='answer answer-14  answerof-142' value='562' \/>&nbsp;<label for='answer-id-562' id='answer-label-562' class=' answer label-14'><span class='answer'>LIKE<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType14' value='radio' class='required'><\/div><div class='watu-question' id='question-15'><div class='question-content'><p><span class='watu_num'>15. <\/span>What keyword can you use to merge two tables based on a matching column?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='143' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='563' \/><div class='watu-question-choice'><input type='radio' name='answer-143[]' id='answer-id-563' class='answer answer-15  answerof-143' value='563' \/>&nbsp;<label for='answer-id-563' id='answer-label-563' class=' answer label-15'><span class='answer'>JOIN<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='564' \/><div class='watu-question-choice'><input type='radio' name='answer-143[]' id='answer-id-564' class='answer answer-15  answerof-143' value='564' \/>&nbsp;<label for='answer-id-564' id='answer-label-564' class=' answer label-15'><span class='answer'>MERGE<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='565' \/><div class='watu-question-choice'><input type='radio' name='answer-143[]' id='answer-id-565' class='answer answer-15  answerof-143' value='565' \/>&nbsp;<label for='answer-id-565' id='answer-label-565' class=' answer label-15'><span class='answer'>ATTACH<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='566' \/><div class='watu-question-choice'><input type='radio' name='answer-143[]' id='answer-id-566' class='answer answer-15  answerof-143' value='566' \/>&nbsp;<label for='answer-id-566' id='answer-label-566' class=' answer label-15'><span class='answer'>AND<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType15' value='radio' class='required'><\/div><div class='watu-question' id='question-16'><div class='question-content'><p><span class='watu_num'>16. <\/span>What function can you use to add all of a column&#8217;s values together?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='144' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='567' \/><div class='watu-question-choice'><input type='radio' name='answer-144[]' id='answer-id-567' class='answer answer-16  answerof-144' value='567' \/>&nbsp;<label for='answer-id-567' id='answer-label-567' class=' answer label-16'><span class='answer'>ADD<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='568' \/><div class='watu-question-choice'><input type='radio' name='answer-144[]' id='answer-id-568' class='answer answer-16  answerof-144' value='568' \/>&nbsp;<label for='answer-id-568' id='answer-label-568' class=' answer label-16'><span class='answer'>EQUALS<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='569' \/><div class='watu-question-choice'><input type='radio' name='answer-144[]' id='answer-id-569' class='answer answer-16  answerof-144' value='569' \/>&nbsp;<label for='answer-id-569' id='answer-label-569' class=' answer label-16'><span class='answer'>SUM<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='570' \/><div class='watu-question-choice'><input type='radio' name='answer-144[]' id='answer-id-570' class='answer answer-16  answerof-144' value='570' \/>&nbsp;<label for='answer-id-570' id='answer-label-570' class=' answer label-16'><span class='answer'>SUMMED<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType16' value='radio' class='required'><\/div><div class='watu-question' id='question-17'><div class='question-content'><p><span class='watu_num'>17. <\/span>What function would you use to return the highest value of a column?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='145' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='571' \/><div class='watu-question-choice'><input type='radio' name='answer-145[]' id='answer-id-571' class='answer answer-17  answerof-145' value='571' \/>&nbsp;<label for='answer-id-571' id='answer-label-571' class=' answer label-17'><span class='answer'>PEAK<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='572' \/><div class='watu-question-choice'><input type='radio' name='answer-145[]' id='answer-id-572' class='answer answer-17  answerof-145' value='572' \/>&nbsp;<label for='answer-id-572' id='answer-label-572' class=' answer label-17'><span class='answer'>HIGH<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='573' \/><div class='watu-question-choice'><input type='radio' name='answer-145[]' id='answer-id-573' class='answer answer-17  answerof-145' value='573' \/>&nbsp;<label for='answer-id-573' id='answer-label-573' class=' answer label-17'><span class='answer'>MAX<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='574' \/><div class='watu-question-choice'><input type='radio' name='answer-145[]' id='answer-id-574' class='answer answer-17  answerof-145' value='574' \/>&nbsp;<label for='answer-id-574' id='answer-label-574' class=' answer label-17'><span class='answer'>TOP<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType17' value='radio' class='required'><\/div><div class='watu-question' id='question-18'><div class='question-content'><p><span class='watu_num'>18. <\/span>What function can you use to compare dates?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='146' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='575' \/><div class='watu-question-choice'><input type='radio' name='answer-146[]' id='answer-id-575' class='answer answer-18  answerof-146' value='575' \/>&nbsp;<label for='answer-id-575' id='answer-label-575' class=' answer label-18'><span class='answer'>DATEDIFF<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='576' \/><div class='watu-question-choice'><input type='radio' name='answer-146[]' id='answer-id-576' class='answer answer-18  answerof-146' value='576' \/>&nbsp;<label for='answer-id-576' id='answer-label-576' class=' answer label-18'><span class='answer'>DATECOMPARE<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='577' \/><div class='watu-question-choice'><input type='radio' name='answer-146[]' id='answer-id-577' class='answer answer-18  answerof-146' value='577' \/>&nbsp;<label for='answer-id-577' id='answer-label-577' class=' answer label-18'><span class='answer'>DATE SUBTRACT<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='578' \/><div class='watu-question-choice'><input type='radio' name='answer-146[]' id='answer-id-578' class='answer answer-18  answerof-146' value='578' \/>&nbsp;<label for='answer-id-578' id='answer-label-578' class=' answer label-18'><span class='answer'>DATE DIFFERENCE<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType18' value='radio' class='required'><\/div><div class='watu-question' id='question-19'><div class='question-content'><p><span class='watu_num'>19. <\/span>What function would you use to round all values up?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='147' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='579' \/><div class='watu-question-choice'><input type='radio' name='answer-147[]' id='answer-id-579' class='answer answer-19  answerof-147' value='579' \/>&nbsp;<label for='answer-id-579' id='answer-label-579' class=' answer label-19'><span class='answer'>ROUND UP<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='580' \/><div class='watu-question-choice'><input type='radio' name='answer-147[]' id='answer-id-580' class='answer answer-19  answerof-147' value='580' \/>&nbsp;<label for='answer-id-580' id='answer-label-580' class=' answer label-19'><span class='answer'>ROUND MAX<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='581' \/><div class='watu-question-choice'><input type='radio' name='answer-147[]' id='answer-id-581' class='answer answer-19  answerof-147' value='581' \/>&nbsp;<label for='answer-id-581' id='answer-label-581' class=' answer label-19'><span class='answer'>MAX<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='582' \/><div class='watu-question-choice'><input type='radio' name='answer-147[]' id='answer-id-582' class='answer answer-19  answerof-147' value='582' \/>&nbsp;<label for='answer-id-582' id='answer-label-582' class=' answer label-19'><span class='answer'>CEILING<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType19' value='radio' class='required'><\/div><div class='watu-question' id='question-20'><div class='question-content'><p><span class='watu_num'>20. <\/span>What function would you use to round all numbers down?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='148' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='583' \/><div class='watu-question-choice'><input type='radio' name='answer-148[]' id='answer-id-583' class='answer answer-20  answerof-148' value='583' \/>&nbsp;<label for='answer-id-583' id='answer-label-583' class=' answer label-20'><span class='answer'>FLOOR<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='584' \/><div class='watu-question-choice'><input type='radio' name='answer-148[]' id='answer-id-584' class='answer answer-20  answerof-148' value='584' \/>&nbsp;<label for='answer-id-584' id='answer-label-584' class=' answer label-20'><span class='answer'>ROUND DOWN<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='585' \/><div class='watu-question-choice'><input type='radio' name='answer-148[]' id='answer-id-585' class='answer answer-20  answerof-148' value='585' \/>&nbsp;<label for='answer-id-585' id='answer-label-585' class=' answer label-20'><span class='answer'>ROUND MIN<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='586' \/><div class='watu-question-choice'><input type='radio' name='answer-148[]' id='answer-id-586' class='answer answer-20  answerof-148' value='586' \/>&nbsp;<label for='answer-id-586' id='answer-label-586' class=' answer label-20'><span class='answer'>MIN<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType20' value='radio' class='required'><\/div><div style='display:none' id='question-21'><br \/><div class='question-content'><img src=\"https:\/\/www.afterhoursprogramming.com\/wp-content\/plugins\/watu\/loading.gif\" width=\"16\" height=\"16\" alt=\"Loading ...\" title=\"Loading ...\" \/>&nbsp;Loading &#8230;<\/div><\/div><br \/>\n\t<p>Question <span id='numQ'>1<\/span> of 20<\/p>\n\t\t<input type=\"button\" id=\"next-question\" value=\"Next &gt;\"  \/>\n<input type=\"button\" name=\"action\" onclick=\"Watu.submitResult()\" id=\"action-button\" value=\"Submit\"  class=\"watu-submit-button\" \/>\n<input type=\"hidden\" name=\"no_ajax\" value=\"0\"><input type=\"hidden\" name=\"quiz_id\" value=\"6\" \/>\n<input type=\"hidden\" id=\"watuStartTime\" name=\"start_time\" value=\"2024-04-27 12:47:48\" \/>\n<\/form>\n<\/div>\n<div id=\"watu-loading-result\" style=\"display:none;\">\n\t<p align=\"center\"><img src=\"https:\/\/www.afterhoursprogramming.com\/wp-content\/plugins\/watu\/loading.gif\" width=\"16\" height=\"16\" alt=\"Loading\" title=\"Loading\" \/><\/p>\n<\/div>\t\n<script type=\"text\/javascript\">\nvar exam_id=0;\nvar question_ids='';\nvar watuURL='';\njQuery(function($){\nquestion_ids = \"129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148\";\nexam_id = 6;\nWatu.exam_id = exam_id;\nWatu.qArr = question_ids.split(',');\nWatu.post_id = 806;\nWatu.singlePage = '0';\nWatu.hAppID = \"0.01719000 1714222068\";\nwatuURL = \"https:\/\/www.afterhoursprogramming.com\/wp-admin\/admin-ajax.php\";\nWatu.noAlertUnanswered = 0;\n});\n<\/script><!--CusAds0-->\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":788,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Quiz - After Hours Programming<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.afterhoursprogramming.com\/tests\/sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Quiz - After Hours Programming\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.afterhoursprogramming.com\/tests\/sql\/\" \/>\n<meta property=\"og:site_name\" content=\"After Hours Programming\" \/>\n<meta property=\"article:modified_time\" content=\"2017-08-25T17:19:05+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.afterhoursprogramming.com\/tests\/sql\/\",\"url\":\"https:\/\/www.afterhoursprogramming.com\/tests\/sql\/\",\"name\":\"SQL Quiz - After Hours Programming\",\"isPartOf\":{\"@id\":\"https:\/\/www.afterhoursprogramming.com\/#website\"},\"datePublished\":\"2017-07-25T21:09:25+00:00\",\"dateModified\":\"2017-08-25T17:19:05+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.afterhoursprogramming.com\/tests\/sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.afterhoursprogramming.com\/tests\/sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.afterhoursprogramming.com\/tests\/sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.afterhoursprogramming.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Web Development Quizzes\",\"item\":\"https:\/\/www.afterhoursprogramming.com\/tests\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SQL Quiz\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.afterhoursprogramming.com\/#website\",\"url\":\"https:\/\/www.afterhoursprogramming.com\/\",\"name\":\"After Hours Programming\",\"description\":\"Web Development Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.afterhoursprogramming.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.afterhoursprogramming.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.afterhoursprogramming.com\/#organization\",\"name\":\"After Hours Programming\",\"url\":\"https:\/\/www.afterhoursprogramming.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.afterhoursprogramming.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.afterhoursprogramming.com\/wp-content\/uploads\/2021\/12\/download.jpeg\",\"contentUrl\":\"https:\/\/www.afterhoursprogramming.com\/wp-content\/uploads\/2021\/12\/download.jpeg\",\"width\":225,\"height\":225,\"caption\":\"After Hours Programming\"},\"image\":{\"@id\":\"https:\/\/www.afterhoursprogramming.com\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Quiz - After Hours Programming","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.afterhoursprogramming.com\/tests\/sql\/","og_locale":"en_US","og_type":"article","og_title":"SQL Quiz - After Hours Programming","og_url":"https:\/\/www.afterhoursprogramming.com\/tests\/sql\/","og_site_name":"After Hours Programming","article_modified_time":"2017-08-25T17:19:05+00:00","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.afterhoursprogramming.com\/tests\/sql\/","url":"https:\/\/www.afterhoursprogramming.com\/tests\/sql\/","name":"SQL Quiz - After Hours Programming","isPartOf":{"@id":"https:\/\/www.afterhoursprogramming.com\/#website"},"datePublished":"2017-07-25T21:09:25+00:00","dateModified":"2017-08-25T17:19:05+00:00","breadcrumb":{"@id":"https:\/\/www.afterhoursprogramming.com\/tests\/sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.afterhoursprogramming.com\/tests\/sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.afterhoursprogramming.com\/tests\/sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.afterhoursprogramming.com\/"},{"@type":"ListItem","position":2,"name":"Web Development Quizzes","item":"https:\/\/www.afterhoursprogramming.com\/tests\/"},{"@type":"ListItem","position":3,"name":"SQL Quiz"}]},{"@type":"WebSite","@id":"https:\/\/www.afterhoursprogramming.com\/#website","url":"https:\/\/www.afterhoursprogramming.com\/","name":"After Hours Programming","description":"Web Development Tutorials","publisher":{"@id":"https:\/\/www.afterhoursprogramming.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.afterhoursprogramming.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.afterhoursprogramming.com\/#organization","name":"After Hours Programming","url":"https:\/\/www.afterhoursprogramming.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.afterhoursprogramming.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.afterhoursprogramming.com\/wp-content\/uploads\/2021\/12\/download.jpeg","contentUrl":"https:\/\/www.afterhoursprogramming.com\/wp-content\/uploads\/2021\/12\/download.jpeg","width":225,"height":225,"caption":"After Hours Programming"},"image":{"@id":"https:\/\/www.afterhoursprogramming.com\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.afterhoursprogramming.com\/wp-json\/wp\/v2\/pages\/806"}],"collection":[{"href":"https:\/\/www.afterhoursprogramming.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.afterhoursprogramming.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.afterhoursprogramming.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.afterhoursprogramming.com\/wp-json\/wp\/v2\/comments?post=806"}],"version-history":[{"count":0,"href":"https:\/\/www.afterhoursprogramming.com\/wp-json\/wp\/v2\/pages\/806\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.afterhoursprogramming.com\/wp-json\/wp\/v2\/pages\/788"}],"wp:attachment":[{"href":"https:\/\/www.afterhoursprogramming.com\/wp-json\/wp\/v2\/media?parent=806"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}