{"id":27452,"date":"2022-01-31T19:45:07","date_gmt":"2022-01-31T14:15:07","guid":{"rendered":"https:\/\/infinitylearn.com\/surge\/?p=27452"},"modified":"2025-02-05T14:48:42","modified_gmt":"2025-02-05T09:18:42","slug":"informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins","status":"publish","type":"post","link":"https:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/","title":{"rendered":"Informatics Practices Class 12 Important Questions Chapter 11 SQL Functions and Table Joins"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_37 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" style=\"display: none;\"><label for=\"item\" aria-label=\"Table of Content\"><span style=\"display: flex;align-items: center;width: 35px;height: 30px;justify-content: center;\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/label><input type=\"checkbox\" id=\"item\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' style='display:block'><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/#lass_12_Important_Questions_Chapter_11_SQL_Functions_and_Table_Joins_-_Question_with_Answer\" title=\"lass 12 Important Questions Chapter 11 SQL Functions and Table Joins &#8211; Question with Answer\">lass 12 Important Questions Chapter 11 SQL Functions and Table Joins &#8211; Question with Answer<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/#FAQs\" title=\"FAQs\">FAQs<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/#What_are_SQL_table_joins\" title=\"What are SQL table joins?\">What are SQL table joins?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/#What_is_SQL_JOIN_Class_12\" title=\"What is SQL JOIN Class 12?\">What is SQL JOIN Class 12?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/#What_are_the_4_types_of_joins_in_SQL\" title=\"What are the 4 types of joins in SQL?\">What are the 4 types of joins in SQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/#What_is_SQL_Class_12_IP\" title=\"What is SQL Class 12 IP?\">What is SQL Class 12 IP?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/#What_are_the_aggregate_functions_in_SQL_Class_12\" title=\"What are the aggregate functions in SQL Class 12?\">What are the aggregate functions in SQL Class 12?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/#What_is_JOIN_in_SQL_Class_12\" title=\"What is JOIN in SQL Class 12?\">What is JOIN in SQL Class 12?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/#What_is_SQL_Class_12_Computer_Science\" title=\"What is SQL Class 12 Computer Science?\">What is SQL Class 12 Computer Science?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/#Is_a_standard_naming_convention_used_for_accessing_resources_over_the_Internet\" title=\"Is a standard naming convention used for accessing resources over the Internet?\">Is a standard naming convention used for accessing resources over the Internet?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/#What_is_the_use_of_SQL_in_MySQL_Class_12\" title=\"What is the use of SQL in MySQL Class 12?\">What is the use of SQL in MySQL Class 12?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"lass_12_Important_Questions_Chapter_11_SQL_Functions_and_Table_Joins_-_Question_with_Answer\"><\/span>lass 12 Important Questions Chapter 11 SQL Functions and Table Joins &#8211; Question with Answer<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>1. What is an SQL function?<\/strong><\/p>\n<p><strong>Answer:<\/strong> An SQL function is a predefined command that performs a specific operation and returns a single value.<\/p>\n<p><strong>2. Differentiate between single-row and multiple-row functions.<\/strong><\/p>\n<p><strong>Answer:<\/strong> Single-row functions operate on individual rows and return one result per row, such as string or mathematical functions. Multiple-row functions, also known as aggregate functions, operate on groups of rows and return a single result for the group, like SUM() or AVG().<\/p>\n<p><strong>3. Name two case-manipulation functions in SQL.<\/strong><\/p>\n<p><strong>Answer:<\/strong> UPPER() and LOWER().<\/p>\n<p><strong>4. What does the CONCAT() function do?<\/strong><\/p>\n<p><strong>Answer:<\/strong> CONCAT() combines two or more strings into one.<\/p>\n<p><strong>5. How does the LENGTH() function work?<\/strong><\/p>\n<p><strong>Answer:<\/strong> LENGTH() returns the number of characters in a string.<\/p>\n<p><strong>6. Explain the TRIM() function.<\/strong><\/p>\n<p><strong>Answer:<\/strong> TRIM() removes leading and trailing spaces from a string.<\/p>\n<p><strong>7. What is the purpose of the SUBSTR() function?<\/strong><\/p>\n<p><strong>Answer:<\/strong> SUBSTR() extracts a substring from a string, starting at a specified position.<\/p>\n<p><strong>8. Describe the INSTR() function.<\/strong><\/p>\n<p><strong>Answer:<\/strong> INSTR() returns the position of the first occurrence of a substring within a string.<\/p>\n<p><strong>9. What does the LPAD() function do?<\/strong><\/p>\n<p><strong>Answer:<\/strong> LPAD() pads the left side of a string with a specified character to a certain length.<\/p>\n<p><strong>10. How does the RPAD() function work?<\/strong><\/p>\n<p><strong>Answer:<\/strong> RPAD() pads the right side of a string with a specified character to a certain length.<\/p>\n<p style=\"text-align: center;\"><strong>Also Check: <a href=\"https:\/\/infinitylearn.com\/surge\/cbse\/cbse-class-12-physics-syllabus\/\" target=\"_blank\" rel=\"noopener\">CBSE Class 12 Physics Syllabus 2023-24<\/a><\/strong><\/p>\n<p><strong>11. Name two mathematical functions in SQL.<\/strong><\/p>\n<p><strong>Answer:<\/strong> ROUND() and MOD().<\/p>\n<p><strong>12. What is the use of the ROUND() function?<\/strong><\/p>\n<p><strong>Answer:<\/strong> ROUND() rounds a number to a specified number of decimal places.<\/p>\n<p><strong>13. Explain the MOD() function.<\/strong><\/p>\n<p><strong>Answer:<\/strong> MOD() returns the remainder of a division operation between two numbers.<\/p>\n<p><strong>14. What does the POWER() function do?<\/strong><\/p>\n<p><strong>Answer:<\/strong> POWER() raises a number to the power of another number.<\/p>\n<p><strong>15. How does the SQRT() function work?<\/strong><\/p>\n<p><strong>Answer:<\/strong> SQRT() returns the square root of a number.<\/p>\n<p><strong>16. Describe the ABS() function.<\/strong><\/p>\n<p><strong>Answer:<\/strong> ABS() returns the absolute (positive) value of a number.<\/p>\n<p><strong>17. What is the purpose of the CEIL() function?<\/strong><\/p>\n<p><strong>Answer:<\/strong> CEIL() rounds a number up to the nearest integer.<\/p>\n<p><strong>18. Explain the FLOOR() function.<\/strong><\/p>\n<p><strong>Answer:<\/strong> FLOOR() rounds a number down to the nearest integer.<\/p>\n<p><strong>19. Name two date functions in SQL.<\/strong><\/p>\n<p><strong>Answer:<\/strong> CURDATE() and NOW().<\/p>\n<p><strong>20. What does the CURDATE() function return?<\/strong><\/p>\n<p><strong>Answer:<\/strong> CURDATE() returns the current date.<\/p>\n<p><strong>21. How does the NOW() function work?<\/strong><\/p>\n<p><strong>Answer:<\/strong> NOW() returns the current date and time.<\/p>\n<p><strong>22. Explain the YEAR() function.<\/strong><\/p>\n<p><strong>Answer:<\/strong> YEAR() extracts the year from a date.<\/p>\n<p><strong>23. What is the use of the MONTH() function?<\/strong><\/p>\n<p><strong>Answer:<\/strong> MONTH() extracts the month from a date.<\/p>\n<p><strong>24. Describe the DAY() function.<\/strong><\/p>\n<p><strong>Answer:<\/strong> DAY() extracts the day from a date.<\/p>\n<p><strong>25. What does the DATEDIFF() function do?<\/strong><\/p>\n<p><strong>Answer:<\/strong> DATEDIFF() returns the difference in days between two dates.<\/p>\n<p><strong>26. Name two aggregate functions in SQL.<\/strong><\/p>\n<p><strong>Answer:<\/strong> SUM() and COUNT().<\/p>\n<p><strong>27. What is the purpose of the SUM() function?<\/strong><\/p>\n<p><strong>Answer:<\/strong> SUM() calculates the total sum of a numeric column.<\/p>\n<p><strong>28. How does the COUNT() function work?<\/strong><\/p>\n<p><strong>Answer:<\/strong> COUNT() returns the number of rows that match a specified condition.<\/p>\n<p><strong>29. Explain the AVG() function.<\/strong><\/p>\n<p><strong>Answer:<\/strong> AVG() calculates the average value of a numeric column.<\/p>\n<p><strong>30. What does the MAX() function do?<\/strong><\/p>\n<p><strong>Answer:<\/strong> MAX() returns the maximum value in a set of values.<\/p>\n<p><strong>31. Describe the MIN() function.<\/strong><\/p>\n<p><strong>Answer:<\/strong> MIN() returns the minimum value in a set of values.<\/p>\n<p><strong>32. What is a table join in SQL?<\/strong><\/p>\n<p><strong>Answer:<\/strong> A table join combines rows from two or more tables based on a related column between them.<\/p>\n<p><strong>33. Name the different types of joins in SQL.<\/strong><\/p>\n<p><strong>Answer:<\/strong> INNER JOIN, LEFT JOIN (or LEFT OUTER JOIN), RIGHT JOIN (or RIGHT OUTER JOIN), and FULL JOIN (or FULL OUTER JOIN).<\/p>\n<p><strong>34. Explain an INNER JOIN.<\/strong><\/p>\n<p><strong>Answer:<\/strong> An INNER JOIN returns only the rows that have matching values in both tables.<\/p>\n<p><strong>35. What is a LEFT JOIN?<\/strong><\/p>\n<p><strong>Answer:<\/strong> A LEFT JOIN returns all rows from the left table and the matched rows from the right table. If no match is found, NULL values are returned for columns from the right table.<\/p>\n<p><strong>36. Describe a RIGHT JOIN.<\/strong><\/p>\n<p><strong>Answer:<\/strong> A RIGHT JOIN returns all rows from the right table and the matched rows from the left table. If no match is found, NULL values are returned for columns from the left table.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"FAQs\"><\/span>FAQs<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\t\t<section class=\"sc_fs_faq sc_card \">\n\t\t\t<div>\n\t\t\t\t<h3><span class=\"ez-toc-section\" id=\"What_are_SQL_table_joins\"><\/span>What are SQL table joins?<span class=\"ez-toc-section-end\"><\/span><\/h3>\t\t\t\t<div>\n\t\t\t\t\t\t\t\t\t\t<p>\n\t\t\t\t\t\tSQL table joins are used to combine rows from two or more tables based on a common column.\t\t\t\t\t<\/p>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"sc_fs_faq sc_card \">\n\t\t\t<div>\n\t\t\t\t<h3><span class=\"ez-toc-section\" id=\"What_is_SQL_JOIN_Class_12\"><\/span>What is SQL JOIN Class 12?<span class=\"ez-toc-section-end\"><\/span><\/h3>\t\t\t\t<div>\n\t\t\t\t\t\t\t\t\t\t<p>\n\t\t\t\t\t\tIn Class 12, SQL JOIN refers to a method of combining data from multiple tables using a common key.\t\t\t\t\t<\/p>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"sc_fs_faq sc_card \">\n\t\t\t<div>\n\t\t\t\t<h3><span class=\"ez-toc-section\" id=\"What_are_the_4_types_of_joins_in_SQL\"><\/span>What are the 4 types of joins in SQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\t\t\t\t<div>\n\t\t\t\t\t\t\t\t\t\t<p>\n\t\t\t\t\t\tThe four types of SQL joins are INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.\t\t\t\t\t<\/p>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"sc_fs_faq sc_card \">\n\t\t\t<div>\n\t\t\t\t<h3><span class=\"ez-toc-section\" id=\"What_is_SQL_Class_12_IP\"><\/span>What is SQL Class 12 IP?<span class=\"ez-toc-section-end\"><\/span><\/h3>\t\t\t\t<div>\n\t\t\t\t\t\t\t\t\t\t<p>\n\t\t\t\t\t\tSQL (Structured Query Language) in Class 12 IP (Informatics Practices) is used to manage and query databases.\t\t\t\t\t<\/p>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"sc_fs_faq sc_card \">\n\t\t\t<div>\n\t\t\t\t<h3><span class=\"ez-toc-section\" id=\"What_are_the_aggregate_functions_in_SQL_Class_12\"><\/span>What are the aggregate functions in SQL Class 12?<span class=\"ez-toc-section-end\"><\/span><\/h3>\t\t\t\t<div>\n\t\t\t\t\t\t\t\t\t\t<p>\n\t\t\t\t\t\tAggregate functions in SQL include SUM(), AVG(), COUNT(), MAX(), and MIN., used to perform calculations on data.\t\t\t\t\t<\/p>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"sc_fs_faq sc_card \">\n\t\t\t<div>\n\t\t\t\t<h3><span class=\"ez-toc-section\" id=\"What_is_JOIN_in_SQL_Class_12\"><\/span>What is JOIN in SQL Class 12?<span class=\"ez-toc-section-end\"><\/span><\/h3>\t\t\t\t<div>\n\t\t\t\t\t\t\t\t\t\t<p>\n\t\t\t\t\t\tA JOIN in SQL is used to retrieve related data from multiple tables by linking them using a common column.\t\t\t\t\t<\/p>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"sc_fs_faq sc_card \">\n\t\t\t<div>\n\t\t\t\t<h3><span class=\"ez-toc-section\" id=\"What_is_SQL_Class_12_Computer_Science\"><\/span>What is SQL Class 12 Computer Science?<span class=\"ez-toc-section-end\"><\/span><\/h3>\t\t\t\t<div>\n\t\t\t\t\t\t\t\t\t\t<p>\n\t\t\t\t\t\tSQL in Class 12 Computer Science is a database language used for storing, managing, and retrieving data in relational databases.\t\t\t\t\t<\/p>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"sc_fs_faq sc_card \">\n\t\t\t<div>\n\t\t\t\t<h3><span class=\"ez-toc-section\" id=\"Is_a_standard_naming_convention_used_for_accessing_resources_over_the_Internet\"><\/span>Is a standard naming convention used for accessing resources over the Internet?<span class=\"ez-toc-section-end\"><\/span><\/h3>\t\t\t\t<div>\n\t\t\t\t\t\t\t\t\t\t<p>\n\t\t\t\t\t\tYes, URL (Uniform Resource Locator) is the standard naming convention used to access resources on the internet.\t\t\t\t\t<\/p>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"sc_fs_faq sc_card \">\n\t\t\t<div>\n\t\t\t\t<h3><span class=\"ez-toc-section\" id=\"What_is_the_use_of_SQL_in_MySQL_Class_12\"><\/span>What is the use of SQL in MySQL Class 12?<span class=\"ez-toc-section-end\"><\/span><\/h3>\t\t\t\t<div>\n\t\t\t\t\t\t\t\t\t\t<p>\n\t\t\t\t\t\tSQL is used in MySQL to create, modify, delete, and retrieve data from a relational database.\t\t\t\t\t<\/p>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/section>\n\t\t\n<script type=\"application\/ld+json\">\n\t{\n\t\t\"@context\": \"https:\/\/schema.org\",\n\t\t\"@type\": \"FAQPage\",\n\t\t\"mainEntity\": [\n\t\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"What are SQL table joins?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"SQL table joins are used to combine rows from two or more tables based on a common column.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"What is SQL JOIN Class 12?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"In Class 12, SQL JOIN refers to a method of combining data from multiple tables using a common key.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"What are the 4 types of joins in SQL?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"The four types of SQL joins are INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"What is SQL Class 12 IP?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"SQL (Structured Query Language) in Class 12 IP (Informatics Practices) is used to manage and query databases.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"What are the aggregate functions in SQL Class 12?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"Aggregate functions in SQL include SUM(), AVG(), COUNT(), MAX(), and MIN., used to perform calculations on data.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"What is JOIN in SQL Class 12?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"A JOIN in SQL is used to retrieve related data from multiple tables by linking them using a common column.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"What is SQL Class 12 Computer Science?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"SQL in Class 12 Computer Science is a database language used for storing, managing, and retrieving data in relational databases.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"Is a standard naming convention used for accessing resources over the Internet?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"Yes, URL (Uniform Resource Locator) is the standard naming convention used to access resources on the internet.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"What is the use of SQL in MySQL Class 12?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"SQL is used in MySQL to create, modify, delete, and retrieve data from a relational database.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t\t\t\t]\n\t}\n<\/script>\n\n","protected":false},"excerpt":{"rendered":"<p>lass 12 Important Questions Chapter 11 SQL Functions and Table Joins &#8211; Question with Answer 1. What is an SQL [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_yoast_wpseo_focuskw":"class 12 mysql practical questions with answers","_yoast_wpseo_title":"Class 12 Important Questions Chapter 11 SQL Functions and Table Joins","_yoast_wpseo_metadesc":"Get Informatics Practices Class 12 Important Questions Chapter 11 SQL Functions and Table Joins on Infinity Learn.","custom_permalink":"study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/"},"categories":[92,21],"tags":[5826,5821,5828,5827,5829,5830,5823,5824,5825,5822],"table_tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Class 12 Important Questions Chapter 11 SQL Functions and Table Joins<\/title>\n<meta name=\"description\" content=\"Get Informatics Practices Class 12 Important Questions Chapter 11 SQL Functions and Table Joins on Infinity Learn.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Class 12 Important Questions Chapter 11 SQL Functions and Table Joins\" \/>\n<meta property=\"og:description\" content=\"Get Informatics Practices Class 12 Important Questions Chapter 11 SQL Functions and Table Joins on Infinity Learn.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/\" \/>\n<meta property=\"og:site_name\" content=\"Infinity Learn by Sri Chaitanya\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/InfinityLearn.SriChaitanya\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-31T14:15:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-05T09:18:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/infinitylearn.com\/surge\/wp-content\/uploads\/2025\/04\/infinitylearn.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1008\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@InfinityLearn_\" \/>\n<meta name=\"twitter:site\" content=\"@InfinityLearn_\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prasad Gupta\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"19 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Class 12 Important Questions Chapter 11 SQL Functions and Table Joins","description":"Get Informatics Practices Class 12 Important Questions Chapter 11 SQL Functions and Table Joins on Infinity Learn.","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:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/","og_locale":"en_US","og_type":"article","og_title":"Class 12 Important Questions Chapter 11 SQL Functions and Table Joins","og_description":"Get Informatics Practices Class 12 Important Questions Chapter 11 SQL Functions and Table Joins on Infinity Learn.","og_url":"https:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/","og_site_name":"Infinity Learn by Sri Chaitanya","article_publisher":"https:\/\/www.facebook.com\/InfinityLearn.SriChaitanya\/","article_published_time":"2022-01-31T14:15:07+00:00","article_modified_time":"2025-02-05T09:18:42+00:00","og_image":[{"width":1920,"height":1008,"url":"https:\/\/infinitylearn.com\/surge\/wp-content\/uploads\/2025\/04\/infinitylearn.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_creator":"@InfinityLearn_","twitter_site":"@InfinityLearn_","twitter_misc":{"Written by":"Prasad Gupta","Est. reading time":"19 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/infinitylearn.com\/surge\/#organization","name":"Infinity Learn","url":"https:\/\/infinitylearn.com\/surge\/","sameAs":["https:\/\/www.facebook.com\/InfinityLearn.SriChaitanya\/","https:\/\/www.instagram.com\/infinitylearn_by_srichaitanya\/","https:\/\/www.linkedin.com\/company\/infinity-learn-by-sri-chaitanya\/","https:\/\/www.youtube.com\/c\/InfinityLearnEdu","https:\/\/twitter.com\/InfinityLearn_"],"logo":{"@type":"ImageObject","@id":"https:\/\/infinitylearn.com\/surge\/#logo","inLanguage":"en-US","url":"","contentUrl":"","caption":"Infinity Learn"},"image":{"@id":"https:\/\/infinitylearn.com\/surge\/#logo"}},{"@type":"WebSite","@id":"https:\/\/infinitylearn.com\/surge\/#website","url":"https:\/\/infinitylearn.com\/surge\/","name":"Infinity Learn by Sri Chaitanya","description":"Surge","publisher":{"@id":"https:\/\/infinitylearn.com\/surge\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/infinitylearn.com\/surge\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/#webpage","url":"https:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/","name":"Class 12 Important Questions Chapter 11 SQL Functions and Table Joins","isPartOf":{"@id":"https:\/\/infinitylearn.com\/surge\/#website"},"datePublished":"2022-01-31T14:15:07+00:00","dateModified":"2025-02-05T09:18:42+00:00","description":"Get Informatics Practices Class 12 Important Questions Chapter 11 SQL Functions and Table Joins on Infinity Learn.","breadcrumb":{"@id":"https:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/infinitylearn.com\/surge\/"},{"@type":"ListItem","position":2,"name":"Informatics Practices Class 12 Important Questions Chapter 11 SQL Functions and Table Joins"}]},{"@type":"Article","@id":"https:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/#article","isPartOf":{"@id":"https:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/#webpage"},"author":{"@id":"https:\/\/infinitylearn.com\/surge\/#\/schema\/person\/143c89c9c2f5e56ed91f96dde47b0b05"},"headline":"Informatics Practices Class 12 Important Questions Chapter 11 SQL Functions and Table Joins","datePublished":"2022-01-31T14:15:07+00:00","dateModified":"2025-02-05T09:18:42+00:00","mainEntityOfPage":{"@id":"https:\/\/infinitylearn.com\/surge\/study-material\/cbse-notes\/class-12\/informatics-practices\/informatics-practices-class-12-important-questions-chapter-11-sql-functions-and-table-joins\/#webpage"},"wordCount":979,"publisher":{"@id":"https:\/\/infinitylearn.com\/surge\/#organization"},"keywords":["class 12 ip sql questions","class 12 mysql practical questions with answers","database query using sql class 12 questions and answers","mysql class 12 questions","mysql questions class 12","sql class 12 important questions","sql class 12 questions","sql queries class 12","sql questions class 12","sql questions for class 12"],"articleSection":["CBSE Notes","Study Materials"],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/infinitylearn.com\/surge\/#\/schema\/person\/143c89c9c2f5e56ed91f96dde47b0b05","name":"Prasad Gupta","image":{"@type":"ImageObject","@id":"https:\/\/infinitylearn.com\/surge\/#personlogo","inLanguage":"en-US","url":"https:\/\/secure.gravatar.com\/avatar\/200104b443e586c76c46cadc113d931c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/200104b443e586c76c46cadc113d931c?s=96&d=mm&r=g","caption":"Prasad Gupta"},"url":"https:\/\/infinitylearn.com\/surge\/author\/prasad\/"}]}},"_links":{"self":[{"href":"https:\/\/infinitylearn.com\/surge\/wp-json\/wp\/v2\/posts\/27452"}],"collection":[{"href":"https:\/\/infinitylearn.com\/surge\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/infinitylearn.com\/surge\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/infinitylearn.com\/surge\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/infinitylearn.com\/surge\/wp-json\/wp\/v2\/comments?post=27452"}],"version-history":[{"count":0,"href":"https:\/\/infinitylearn.com\/surge\/wp-json\/wp\/v2\/posts\/27452\/revisions"}],"wp:attachment":[{"href":"https:\/\/infinitylearn.com\/surge\/wp-json\/wp\/v2\/media?parent=27452"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/infinitylearn.com\/surge\/wp-json\/wp\/v2\/categories?post=27452"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/infinitylearn.com\/surge\/wp-json\/wp\/v2\/tags?post=27452"},{"taxonomy":"table_tags","embeddable":true,"href":"https:\/\/infinitylearn.com\/surge\/wp-json\/wp\/v2\/table_tags?post=27452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}