{"id":4407,"date":"2024-02-14T12:40:14","date_gmt":"2024-02-14T07:10:14","guid":{"rendered":"https:\/\/cbsepython.in\/structured-query-language-quiz-class-12\/"},"modified":"2024-02-19T22:50:04","modified_gmt":"2024-02-19T17:20:04","slug":"structured-query-language-quiz-class-12","status":"publish","type":"post","link":"https:\/\/cbsepython.in\/structured-query-language-quiz-class-12\/","title":{"rendered":"Structured Query Language Quiz Class 12"},"content":{"rendered":"<p>Here&#8217;s a 15-question <strong>&#8220;Structured Query Language Quiz Class 12&#8221;<\/strong> based on the topics &#8220;Structured Query Language (SQL): Introduction, Data Definition Language (DDL), Data Manipulation Language (DML), Data Types (CHAR(n), VARCHAR(n), INT, FLOAT, DATE), Constraints (NOT NULL, UNIQUE, PRIMARY KEY), Create Database, Use Database, Show Databases, Drop Database, Show Tables, Create Table, Describe Table, Alter Table (Add and Remove an Attribute, Add and Remove Primary Key), Drop Table, Insert, Delete, Select, Operators (Mathematical, Relational, and Logical), Aliasing, Distinct Clause, Where Clause, In, Between, Order By, Meaning of Null, Is Null, Is Not Null, Like, Update Command, Delete Command, Aggregate Functions (MAX, MIN, AVG, SUM, COUNT), Group By, Having Clause, Joins (Cartesian Product on Two Tables, Equi-Join, and Natural Join)&#8221;<\/p>\n<div id=\"watu_quiz\" class=\"quiz-area single-page-quiz\">\n<form action=\"\" method=\"post\" class=\"quiz-form \" id=\"quiz-31\" >\n<div class='watu-question' id='question-1'><div class='question-content'><p><span class='watu_num'>1. <\/span>What does SQL stand for?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='464' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2219' \/><div class='watu-question-choice'><input type='radio' name='answer-464[]' id='answer-id-2219' class='answer answer-1  answerof-464' value='2219' \/>&nbsp;<label for='answer-id-2219' id='answer-label-2219' class=' answer label-1'><span class='answer'>Standard Query Language<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2220' \/><div class='watu-question-choice'><input type='radio' name='answer-464[]' id='answer-id-2220' class='answer answer-1  answerof-464' value='2220' \/>&nbsp;<label for='answer-id-2220' id='answer-label-2220' class=' answer label-1'><span class='answer'>Simple Query Language<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2221' \/><div class='watu-question-choice'><input type='radio' name='answer-464[]' id='answer-id-2221' class='answer answer-1  answerof-464' value='2221' \/>&nbsp;<label for='answer-id-2221' id='answer-label-2221' class=' answer label-1'><span class='answer'>Structured Query Language<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2222' \/><div class='watu-question-choice'><input type='radio' name='answer-464[]' id='answer-id-2222' class='answer answer-1  answerof-464' value='2222' \/>&nbsp;<label for='answer-id-2222' id='answer-label-2222' class=' answer label-1'><span class='answer'>Structured Query Logic<\/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 is the purpose of Data Definition Language (DDL) in SQL?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='465' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2223' \/><div class='watu-question-choice'><input type='radio' name='answer-465[]' id='answer-id-2223' class='answer answer-2  answerof-465' value='2223' \/>&nbsp;<label for='answer-id-2223' id='answer-label-2223' class=' answer label-2'><span class='answer'>To manipulate data<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2224' \/><div class='watu-question-choice'><input type='radio' name='answer-465[]' id='answer-id-2224' class='answer answer-2  answerof-465' value='2224' \/>&nbsp;<label for='answer-id-2224' id='answer-label-2224' class=' answer label-2'><span class='answer'>To retrieve data from the database<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2225' \/><div class='watu-question-choice'><input type='radio' name='answer-465[]' id='answer-id-2225' class='answer answer-2  answerof-465' value='2225' \/>&nbsp;<label for='answer-id-2225' id='answer-label-2225' class=' answer label-2'><span class='answer'>To define and manage the structure of a database<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2226' \/><div class='watu-question-choice'><input type='radio' name='answer-465[]' id='answer-id-2226' class='answer answer-2  answerof-465' value='2226' \/>&nbsp;<label for='answer-id-2226' id='answer-label-2226' class=' answer label-2'><span class='answer'>To perform mathematical operations<\/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>Which data type is used for storing variable-length character strings in SQL?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='466' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2227' \/><div class='watu-question-choice'><input type='radio' name='answer-466[]' id='answer-id-2227' class='answer answer-3  answerof-466' value='2227' \/>&nbsp;<label for='answer-id-2227' id='answer-label-2227' class=' answer label-3'><span class='answer'>CHAR(n)<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2228' \/><div class='watu-question-choice'><input type='radio' name='answer-466[]' id='answer-id-2228' class='answer answer-3  answerof-466' value='2228' \/>&nbsp;<label for='answer-id-2228' id='answer-label-2228' class=' answer label-3'><span class='answer'>INT<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2229' \/><div class='watu-question-choice'><input type='radio' name='answer-466[]' id='answer-id-2229' class='answer answer-3  answerof-466' value='2229' \/>&nbsp;<label for='answer-id-2229' id='answer-label-2229' class=' answer label-3'><span class='answer'>VARCHAR(n)<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2230' \/><div class='watu-question-choice'><input type='radio' name='answer-466[]' id='answer-id-2230' class='answer answer-3  answerof-466' value='2230' \/>&nbsp;<label for='answer-id-2230' id='answer-label-2230' class=' answer label-3'><span class='answer'>FLOAT<\/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 does the NOT NULL constraint specify in SQL?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='467' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2231' \/><div class='watu-question-choice'><input type='radio' name='answer-467[]' id='answer-id-2231' class='answer answer-4  answerof-467' value='2231' \/>&nbsp;<label for='answer-id-2231' id='answer-label-2231' class=' answer label-4'><span class='answer'>Allows NULL values in the column<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2232' \/><div class='watu-question-choice'><input type='radio' name='answer-467[]' id='answer-id-2232' class='answer answer-4  answerof-467' value='2232' \/>&nbsp;<label for='answer-id-2232' id='answer-label-2232' class=' answer label-4'><span class='answer'>Disallows NULL values in the column<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2233' \/><div class='watu-question-choice'><input type='radio' name='answer-467[]' id='answer-id-2233' class='answer answer-4  answerof-467' value='2233' \/>&nbsp;<label for='answer-id-2233' id='answer-label-2233' class=' answer label-4'><span class='answer'>Enforces unique values in the column<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2234' \/><div class='watu-question-choice'><input type='radio' name='answer-467[]' id='answer-id-2234' class='answer answer-4  answerof-467' value='2234' \/>&nbsp;<label for='answer-id-2234' id='answer-label-2234' class=' answer label-4'><span class='answer'>Creates a primary key<\/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>How can you create a new database in SQL?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='468' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2235' \/><div class='watu-question-choice'><input type='radio' name='answer-468[]' id='answer-id-2235' class='answer answer-5  answerof-468' value='2235' \/>&nbsp;<label for='answer-id-2235' id='answer-label-2235' class=' answer label-5'><span class='answer'>CREATE DATABASE database_name;<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2236' \/><div class='watu-question-choice'><input type='radio' name='answer-468[]' id='answer-id-2236' class='answer answer-5  answerof-468' value='2236' \/>&nbsp;<label for='answer-id-2236' id='answer-label-2236' class=' answer label-5'><span class='answer'>USE DATABASE database_name;<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2237' \/><div class='watu-question-choice'><input type='radio' name='answer-468[]' id='answer-id-2237' class='answer answer-5  answerof-468' value='2237' \/>&nbsp;<label for='answer-id-2237' id='answer-label-2237' class=' answer label-5'><span class='answer'>SHOW DATABASES;<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2238' \/><div class='watu-question-choice'><input type='radio' name='answer-468[]' id='answer-id-2238' class='answer answer-5  answerof-468' value='2238' \/>&nbsp;<label for='answer-id-2238' id='answer-label-2238' class=' answer label-5'><span class='answer'>DROP DATABASE database_name;<\/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 purpose of the SELECT statement in SQL?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='469' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2239' \/><div class='watu-question-choice'><input type='radio' name='answer-469[]' id='answer-id-2239' class='answer answer-6  answerof-469' value='2239' \/>&nbsp;<label for='answer-id-2239' id='answer-label-2239' class=' answer label-6'><span class='answer'>To insert data into a table<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2240' \/><div class='watu-question-choice'><input type='radio' name='answer-469[]' id='answer-id-2240' class='answer answer-6  answerof-469' value='2240' \/>&nbsp;<label for='answer-id-2240' id='answer-label-2240' class=' answer label-6'><span class='answer'>To update data in a table<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2241' \/><div class='watu-question-choice'><input type='radio' name='answer-469[]' id='answer-id-2241' class='answer answer-6  answerof-469' value='2241' \/>&nbsp;<label for='answer-id-2241' id='answer-label-2241' class=' answer label-6'><span class='answer'>To retrieve data from a table<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2242' \/><div class='watu-question-choice'><input type='radio' name='answer-469[]' id='answer-id-2242' class='answer answer-6  answerof-469' value='2242' \/>&nbsp;<label for='answer-id-2242' id='answer-label-2242' class=' answer label-6'><span class='answer'>To delete data from a table<\/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 is the meaning of the DISTINCT clause in SQL?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='470' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2243' \/><div class='watu-question-choice'><input type='radio' name='answer-470[]' id='answer-id-2243' class='answer answer-7  answerof-470' value='2243' \/>&nbsp;<label for='answer-id-2243' id='answer-label-2243' class=' answer label-7'><span class='answer'>Retrieves all records from a table<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2244' \/><div class='watu-question-choice'><input type='radio' name='answer-470[]' id='answer-id-2244' class='answer answer-7  answerof-470' value='2244' \/>&nbsp;<label for='answer-id-2244' id='answer-label-2244' class=' answer label-7'><span class='answer'>Retrieves unique values from a specified column<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2245' \/><div class='watu-question-choice'><input type='radio' name='answer-470[]' id='answer-id-2245' class='answer answer-7  answerof-470' value='2245' \/>&nbsp;<label for='answer-id-2245' id='answer-label-2245' class=' answer label-7'><span class='answer'>Deletes duplicate records from a table<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2246' \/><div class='watu-question-choice'><input type='radio' name='answer-470[]' id='answer-id-2246' class='answer answer-7  answerof-470' value='2246' \/>&nbsp;<label for='answer-id-2246' id='answer-label-2246' class=' answer label-7'><span class='answer'>Updates existing records in a table<\/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>How can you filter data using the WHERE clause in SQL?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='471' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2247' \/><div class='watu-question-choice'><input type='radio' name='answer-471[]' id='answer-id-2247' class='answer answer-8  answerof-471' value='2247' \/>&nbsp;<label for='answer-id-2247' id='answer-label-2247' class=' answer label-8'><span class='answer'>SELECT DISTINCT column_name FROM table_name WHERE condition;<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2248' \/><div class='watu-question-choice'><input type='radio' name='answer-471[]' id='answer-id-2248' class='answer answer-8  answerof-471' value='2248' \/>&nbsp;<label for='answer-id-2248' id='answer-label-2248' class=' answer label-8'><span class='answer'>SELECT * FROM table_name WHERE condition;<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2249' \/><div class='watu-question-choice'><input type='radio' name='answer-471[]' id='answer-id-2249' class='answer answer-8  answerof-471' value='2249' \/>&nbsp;<label for='answer-id-2249' id='answer-label-2249' class=' answer label-8'><span class='answer'>DELETE FROM table_name WHERE condition;<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2250' \/><div class='watu-question-choice'><input type='radio' name='answer-471[]' id='answer-id-2250' class='answer answer-8  answerof-471' value='2250' \/>&nbsp;<label for='answer-id-2250' id='answer-label-2250' class=' answer label-8'><span class='answer'>UPDATE table_name SET column_name = value WHERE condition;<\/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>What is the purpose of the GROUP BY clause in SQL?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='472' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2251' \/><div class='watu-question-choice'><input type='radio' name='answer-472[]' id='answer-id-2251' class='answer answer-9  answerof-472' value='2251' \/>&nbsp;<label for='answer-id-2251' id='answer-label-2251' class=' answer label-9'><span class='answer'>To sort data in ascending order<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2252' \/><div class='watu-question-choice'><input type='radio' name='answer-472[]' id='answer-id-2252' class='answer answer-9  answerof-472' value='2252' \/>&nbsp;<label for='answer-id-2252' id='answer-label-2252' class=' answer label-9'><span class='answer'>To group rows that have the same values in specified columns<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2253' \/><div class='watu-question-choice'><input type='radio' name='answer-472[]' id='answer-id-2253' class='answer answer-9  answerof-472' value='2253' \/>&nbsp;<label for='answer-id-2253' id='answer-label-2253' class=' answer label-9'><span class='answer'>To join two tables<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2254' \/><div class='watu-question-choice'><input type='radio' name='answer-472[]' id='answer-id-2254' class='answer answer-9  answerof-472' value='2254' \/>&nbsp;<label for='answer-id-2254' id='answer-label-2254' class=' answer label-9'><span class='answer'>To add a new column to a table<\/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>How do you perform an equi-join in SQL?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='473' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2255' \/><div class='watu-question-choice'><input type='radio' name='answer-473[]' id='answer-id-2255' class='answer answer-10  answerof-473' value='2255' \/>&nbsp;<label for='answer-id-2255' id='answer-label-2255' class=' answer label-10'><span class='answer'>SELECT * FROM table1, table2 WHERE condition;<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2256' \/><div class='watu-question-choice'><input type='radio' name='answer-473[]' id='answer-id-2256' class='answer answer-10  answerof-473' value='2256' \/>&nbsp;<label for='answer-id-2256' id='answer-label-2256' class=' answer label-10'><span class='answer'>SELECT * FROM table1 JOIN table2 ON condition;<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2257' \/><div class='watu-question-choice'><input type='radio' name='answer-473[]' id='answer-id-2257' class='answer answer-10  answerof-473' value='2257' \/>&nbsp;<label for='answer-id-2257' id='answer-label-2257' class=' answer label-10'><span class='answer'>SELECT * FROM table1 INNER JOIN table2 ON condition;<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2258' \/><div class='watu-question-choice'><input type='radio' name='answer-473[]' id='answer-id-2258' class='answer answer-10  answerof-473' value='2258' \/>&nbsp;<label for='answer-id-2258' id='answer-label-2258' class=' answer label-10'><span class='answer'>SELECT * FROM table1 LEFT JOIN table2 ON condition;<\/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 does the UPDATE command in SQL do?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='474' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2259' \/><div class='watu-question-choice'><input type='radio' name='answer-474[]' id='answer-id-2259' class='answer answer-11  answerof-474' value='2259' \/>&nbsp;<label for='answer-id-2259' id='answer-label-2259' class=' answer label-11'><span class='answer'>Deletes records from a table<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2260' \/><div class='watu-question-choice'><input type='radio' name='answer-474[]' id='answer-id-2260' class='answer answer-11  answerof-474' value='2260' \/>&nbsp;<label for='answer-id-2260' id='answer-label-2260' class=' answer label-11'><span class='answer'>Modifies existing records in a table<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2261' \/><div class='watu-question-choice'><input type='radio' name='answer-474[]' id='answer-id-2261' class='answer answer-11  answerof-474' value='2261' \/>&nbsp;<label for='answer-id-2261' id='answer-label-2261' class=' answer label-11'><span class='answer'>Adds a new table to the database<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2262' \/><div class='watu-question-choice'><input type='radio' name='answer-474[]' id='answer-id-2262' class='answer answer-11  answerof-474' value='2262' \/>&nbsp;<label for='answer-id-2262' id='answer-label-2262' class=' answer label-11'><span class='answer'>Retrieves data from a table<\/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>Which keyword is used for removing records from a table in SQL?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='475' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2263' \/><div class='watu-question-choice'><input type='radio' name='answer-475[]' id='answer-id-2263' class='answer answer-12  answerof-475' value='2263' \/>&nbsp;<label for='answer-id-2263' id='answer-label-2263' class=' answer label-12'><span class='answer'>DELETE<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2264' \/><div class='watu-question-choice'><input type='radio' name='answer-475[]' id='answer-id-2264' class='answer answer-12  answerof-475' value='2264' \/>&nbsp;<label for='answer-id-2264' id='answer-label-2264' class=' answer label-12'><span class='answer'>REMOVE<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2265' \/><div class='watu-question-choice'><input type='radio' name='answer-475[]' id='answer-id-2265' class='answer answer-12  answerof-475' value='2265' \/>&nbsp;<label for='answer-id-2265' id='answer-label-2265' class=' answer label-12'><span class='answer'>DROP<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2266' \/><div class='watu-question-choice'><input type='radio' name='answer-475[]' id='answer-id-2266' class='answer answer-12  answerof-475' value='2266' \/>&nbsp;<label for='answer-id-2266' id='answer-label-2266' class=' answer label-12'><span class='answer'>ERASE<\/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>What is the purpose of the HAVING clause in SQL?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='476' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2267' \/><div class='watu-question-choice'><input type='radio' name='answer-476[]' id='answer-id-2267' class='answer answer-13  answerof-476' value='2267' \/>&nbsp;<label for='answer-id-2267' id='answer-label-2267' class=' answer label-13'><span class='answer'>To filter rows based on a condition<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2268' \/><div class='watu-question-choice'><input type='radio' name='answer-476[]' id='answer-id-2268' class='answer answer-13  answerof-476' value='2268' \/>&nbsp;<label for='answer-id-2268' id='answer-label-2268' class=' answer label-13'><span class='answer'>To filter aggregate functions&#8217; results<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2269' \/><div class='watu-question-choice'><input type='radio' name='answer-476[]' id='answer-id-2269' class='answer answer-13  answerof-476' value='2269' \/>&nbsp;<label for='answer-id-2269' id='answer-label-2269' class=' answer label-13'><span class='answer'>To create an alias for a column<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2270' \/><div class='watu-question-choice'><input type='radio' name='answer-476[]' id='answer-id-2270' class='answer answer-13  answerof-476' value='2270' \/>&nbsp;<label for='answer-id-2270' id='answer-label-2270' class=' answer label-13'><span class='answer'>To group rows based on a condition<\/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 does the MAX() function do in SQL?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='477' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2271' \/><div class='watu-question-choice'><input type='radio' name='answer-477[]' id='answer-id-2271' class='answer answer-14  answerof-477' value='2271' \/>&nbsp;<label for='answer-id-2271' id='answer-label-2271' class=' answer label-14'><span class='answer'>Calculates the average value<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2272' \/><div class='watu-question-choice'><input type='radio' name='answer-477[]' id='answer-id-2272' class='answer answer-14  answerof-477' value='2272' \/>&nbsp;<label for='answer-id-2272' id='answer-label-2272' class=' answer label-14'><span class='answer'>Retrieves the maximum value in a column<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2273' \/><div class='watu-question-choice'><input type='radio' name='answer-477[]' id='answer-id-2273' class='answer answer-14  answerof-477' value='2273' \/>&nbsp;<label for='answer-id-2273' id='answer-label-2273' class=' answer label-14'><span class='answer'>Counts the number of rows<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2274' \/><div class='watu-question-choice'><input type='radio' name='answer-477[]' id='answer-id-2274' class='answer answer-14  answerof-477' value='2274' \/>&nbsp;<label for='answer-id-2274' id='answer-label-2274' class=' answer label-14'><span class='answer'>Retrieves the minimum value in a column<\/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 is a Cartesian product in SQL?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='478' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2275' \/><div class='watu-question-choice'><input type='radio' name='answer-478[]' id='answer-id-2275' class='answer answer-15  answerof-478' value='2275' \/>&nbsp;<label for='answer-id-2275' id='answer-label-2275' class=' answer label-15'><span class='answer'>The result of multiplying the number of rows in two tables<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2276' \/><div class='watu-question-choice'><input type='radio' name='answer-478[]' id='answer-id-2276' class='answer answer-15  answerof-478' value='2276' \/>&nbsp;<label for='answer-id-2276' id='answer-label-2276' class=' answer label-15'><span class='answer'>A type of join that combines rows based on common values<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2277' \/><div class='watu-question-choice'><input type='radio' name='answer-478[]' id='answer-id-2277' class='answer answer-15  answerof-478' value='2277' \/>&nbsp;<label for='answer-id-2277' id='answer-label-2277' class=' answer label-15'><span class='answer'>The process of creating a new table<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2278' \/><div class='watu-question-choice'><input type='radio' name='answer-478[]' id='answer-id-2278' class='answer answer-15  answerof-478' value='2278' \/>&nbsp;<label for='answer-id-2278' id='answer-label-2278' class=' answer label-15'><span class='answer'>A function to calculate the average<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType15' value='radio' class='required'><\/div><div style='display:none' id='question-16'><br \/><div class='question-content'><img decoding=\"async\" src=\"https:\/\/cbsepython.in\/wp-content\/plugins\/watu\/loading.gif\" width=\"16\" height=\"16\" alt=\"Loading ...\" title=\"Loading ...\" \/>&nbsp;Loading &#8230;<\/div><\/div><br \/>\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=\"31\" \/>\n<input type=\"hidden\" id=\"watuStartTime\" name=\"start_time\" value=\"2026-04-11 10:31:02\" \/>\n<\/form>\n<\/div>\n<div id=\"watu-loading-result\" style=\"display:none;\">\n\t<p align=\"center\"><img decoding=\"async\" src=\"https:\/\/cbsepython.in\/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 = \"464,465,466,467,468,469,470,471,472,473,474,475,476,477,478\";\nexam_id = 31;\nWatu.exam_id = exam_id;\nWatu.qArr = question_ids.split(',');\nWatu.post_id = 4407;\nWatu.singlePage = '1';\nWatu.hAppID = \"0.44003600 1775883662\";\nwatuURL = \"https:\/\/cbsepython.in\/wp-admin\/admin-ajax.php\";\nWatu.noAlertUnanswered = 0;\n});\n<\/script>\n","protected":false},"excerpt":{"rendered":"<p>Here&#8217;s a 15-question &#8220;Structured Query Language Quiz Class 12&#8221; based on the topics &#8220;Structured Query Language (SQL): Introduction, Data Definition Language (DDL), Data Manipulation Language (DML), Data Types (CHAR(n), VARCHAR(n), INT, FLOAT, DATE), Constraints (NOT NULL, UNIQUE, PRIMARY KEY), Create Database, Use Database, Show Databases, Drop Database, Show Tables, Create Table, Describe Table, Alter Table [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[56],"tags":[],"class_list":["post-4407","post","type-post","status-publish","format-standard","hentry","category-quiz"],"_links":{"self":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/4407","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/comments?post=4407"}],"version-history":[{"count":0,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/4407\/revisions"}],"wp:attachment":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/media?parent=4407"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/categories?post=4407"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/tags?post=4407"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}