Question 1

Question 17What will be returned by the given query ?SELECT Sign(26);1-10none of these

Accepted Answer

1Reason — The SIGN() function is used to determine the sign of a given number. It returns 1 if the number is positive, -1 if the number is negative, and 0 if the number is zero. In this query, SIGN(26) represents a positive number. Therefore, it will return 1 as the output.

Question 2

Question 22Predict the output of the following query :SELECT MOD(9, 0);0NULLNaN9

Accepted Answer

NULLReason — The MOD() function returns NULL when the divisor is zero because division by zero is undefined in SQL.

Source: This question is from MySQL Functions, Informatics Practices &mdash; Class 12, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter MySQL Functions: Question, Predict, Output, Query, Select, Mod. These are fundamental topics in Informatics Practices that students are expected to master as part of the CBSE Class 12 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Informatics Practices papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach MCQsMultiple choice questions test your ability to quickly recall facts and apply concepts. Read all options carefully before selecting your answer. Use the process of elimination to rule out clearly incorrect options first. If two options seem similar, look for the subtle difference that makes one more accurate. For numerical MCQs, verify your answer by substituting it back into the problem.
Key Points to RememberRead the question carefully and identify all parts before answering.
Use the terminology specific to this subject and chapter.
Review the textbook content for this chapter before attempting questions.
Practice writing concise, well-structured answers within time limits.
Related Questions from MySQL FunctionsQ1: Question 1 Based on the SQL table CAR_SALES, write suitable queries for the following : NUMBER...
Q10: Question 3(iv) What will be the output of following code ? mysql > SELECT CONCAT( LOWER ( &#x27; Class &#x27;...
Q11: Question 4 If Str = "INFORMATICS PRACTICES ...." and Str1 = "... FOR CLASS XI" Write commands to...
Q12: Question 5 Write commands to display the system date.
Q13: Question 6 Write a command to display the name of current month.
Practice more questions from MySQL Functions &mdash; Informatics Practices, Class 12 CBSE

Question 3

Question 23The avg() function in MySQL is an example of ............... .Math functionText functionDate FunctionAggregate Function

Accepted Answer

Aggregate FunctionReason — The AVG() function is classified as an aggregate function because it performs a calculation on a set of values to return a single value.

Question 4

Question 24An aggregate function performs a calculation on ............... and returns a single value.single valuemultiple valuesno valuenone of these

Accepted Answer

multiple valuesReason — An aggregate function performs a calculation on multiple rows and returns a summary result for a group of rows.

Source: This question is from MySQL Functions, Informatics Practices &mdash; Class 12, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter MySQL Functions: Question, Aggregate, Performs, Calculation, Returns, Single. These are fundamental topics in Informatics Practices that students are expected to master as part of the CBSE Class 12 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Informatics Practices papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach MCQsMultiple choice questions test your ability to quickly recall facts and apply concepts. Read all options carefully before selecting your answer. Use the process of elimination to rule out clearly incorrect options first. If two options seem similar, look for the subtle difference that makes one more accurate. For numerical MCQs, verify your answer by substituting it back into the problem.
Key Points to RememberRead the question carefully and identify all parts before answering.
Use the terminology specific to this subject and chapter.
Review the textbook content for this chapter before attempting questions.
Practice writing concise, well-structured answers within time limits.
Related Questions from MySQL FunctionsQ1: Question 1 Based on the SQL table CAR_SALES, write suitable queries for the following : NUMBER...
Q10: Question 3(iv) What will be the output of following code ? mysql > SELECT CONCAT( LOWER ( &#x27; Class &#x27;...
Q11: Question 4 If Str = "INFORMATICS PRACTICES ...." and Str1 = "... FOR CLASS XI" Write commands to...
Q12: Question 5 Write commands to display the system date.
Q13: Question 6 Write a command to display the name of current month.
Practice more questions from MySQL Functions &mdash; Informatics Practices, Class 12 CBSE

Question 5

Question 2(iv)Explain the DAYNAME() SQL function using suitable examples.

Accepted Answer

The DAYNAME() function returns the name of weekday for date. The syntax is DAYNAME(date). For example,SELECT DAYNAME('2024-05-20');Output+-----------------------+
| DAYNAME('2024-05-20') |
+-----------------------+
| Monday                |
+-----------------------+

Question 6

Question 2(v)Explain the POWER() SQL function using suitable examples.

Accepted Answer

The POWER()/POW() function returns the value of m raised to the nth power, denoted as mn. The syntax is POWER(m, n) or POW(m, n). Both m and n can be any numbers, but if m is negative, n must be an integer. For example,SELECT POWER(4, 2) "Raised";Output+--------+
| Raised |
+--------+
|     16 |
+--------+

Question 7

Question 3(i)What will be the output of following code ?mysql> SELECT CONCAT(CONCAT('Inform', 'atics'), 'Practices');

Accepted Answer

Output+------------------------------------------------+
| CONCAT(CONCAT('Inform', 'atics'), 'Practices') |
+------------------------------------------------+
| InformaticsPractices                           |
+------------------------------------------------+
ExplanationThe CONCAT() function in SQL is used to concatenate two or more strings into a single string. In this query, the inner CONCAT('Inform', 'atics') concatenates 'Inform' and 'atics' to produce 'Informatics'. The outer CONCAT() then concatenates 'Informatics' with 'Practices' to produce 'InformaticsPractices'. Therefore, the final output is 'InformaticsPractices'.

Question 8

Question 3(iii)What will be the output of following code ?mysql> SELECT UCASE('Computer studies');

Accepted Answer

Output+---------------------------+
| UCASE('Computer studies') |
+---------------------------+
| COMPUTER STUDIES          |
+---------------------------+
ExplanationThe UCASE() function in SQL is used to convert all characters of a given string to uppercase. In this query, UCASE('Computer studies') converts the entire string to 'COMPUTER STUDIES'. Therefore, the output is 'COMPUTER STUDIES'.

Question 9

Question 3(iv)What will be the output of following code ?mysql> SELECT CONCAT(LOWER('Class'), UPPER('xii'));

Accepted Answer

Output+--------------------------------------+
| CONCAT(LOWER('Class'), UPPER('xii')) |
+--------------------------------------+
| classXII                             |
+--------------------------------------+
ExplanationIn the query, LOWER('Class') converts 'Class' to lowercase, resulting in 'class', and UPPER('xii') converts 'xii' to uppercase, resulting in 'XII'. The CONCAT() function then combines these two results, producing the final output 'classXII'.

Question 10

Question 4If Str = "INFORMATICS PRACTICES ...." and Str1 = "... FOR CLASS XI"Write commands to print the output as 'informatics practices for class xi'

Accepted Answer

SELECT CONCAT(LCASE('INFORMATICS PRACTICES'), ' ', LCASE('FOR CLASS XI'));Output+--------------------------------------------------------------------+
| CONCAT(LCASE('INFORMATICS PRACTICES'), ' ', LCASE('FOR CLASS XI')) |
+--------------------------------------------------------------------+
| informatics practices for class xi                                 |
+--------------------------------------------------------------------+

Question 11

Question 5Write commands to display the system date.

Accepted Answer

SELECT SYSDATE();Output+---------------------+
| SYSDATE()           |
+---------------------+
| 2024-05-20 15:31:25 |
+---------------------+

Question 12

Question 6Write a command to display the name of current month.

Accepted Answer

SELECT MONTHNAME(CURDATE());Output+----------------------+
| MONTHNAME(CURDATE()) |
+----------------------+
| May                  |
+----------------------+

Question 13

Question 7Write SQL statement to displayToday, the date is <current date>

Accepted Answer

SELECT CONCAT('Today, the date is ', CURDATE()) AS CURDATE;Output+-------------------------------+
| CURDATE                       |
+-------------------------------+
| Today, the date is 2024-05-20 |
+-------------------------------+

Question 14

Question 8Write command to print the day of the week of your Birthday in the year 1999.

Accepted Answer

SELECT DAYOFWEEK('1999-07-21');Output+-------------------------+
| DAYOFWEEK('1999-07-21') |
+-------------------------+
|                       4 |
+-------------------------+

Question 15

Question 9Write a command to display the current time.

Accepted Answer

SELECT TIME(NOW());Output+-------------+
| TIME(NOW()) |
+-------------+
| 15:40:57    |
+-------------+

Question 16

Question 11(i)Find the output of the following SQL Query :SELECT ROUND(7658.345, 2);

Accepted Answer

Output+--------------------+
| ROUND(7658.345, 2) |
+--------------------+
|            7658.35 |
+--------------------+
ExplanationIn the query, the ROUND function is used to round a number to 2 decimal places, resulting in 7658.35.

Question 17

Question 11(ii)Find the output of the following SQL Query :SELECT MOD(ROUND (13.9, 0), 3);

Accepted Answer

Output+------------------------+
| MOD(ROUND(13.9, 0), 3) |
+------------------------+
|                      2 |
+------------------------+
ExplanationIn the above query, 13.9 is first rounded to the nearest whole number (0 decimal places), resulting in 14 using the ROUND function. Then, the MOD function computes the remainder of 14 divided by 3, resulting in 2. Therefore, the output of the query is 2.

Question 18

Question 12Write the SQL functions which will perform the following operations :(i) To display the name of the month of the current date.(ii) To remove spaces from the beginning and end of a string, "Panorama".(iii) To display the name of the day e.g., Friday or Sunday from your date of birth, dob.(iv) To display the starting position of your first name(fname) from your whole name (name).(v) To compute the remainder of division between two numbers, n1 and n2.

Accepted Answer

Question 19

Question 13Write suitable SQL query for the following :(i) Display 7 characters extracted from 7th left character onwards from the string 'INDIA SHINING'.(ii) Display the position of occurrence of string 'COME' in the string 'WELCOME WORLD'.(iii) Round off the value 23.78 to one decimal place.(iv) Display the remainder of 100 divided by 9.(v) Remove all the expected leading and trailing spaces from a column userid of the table 'USERS'.

Accepted Answer

(i)SELECT SUBSTR('INDIA SHINING', 7, 7);Output+-------------------------------+
| SUBSTR('INDIA SHINING', 7, 7) |
+-------------------------------+
| SHINING                       |
+-------------------------------+
(ii)SELECT INSTR('WELCOME WORLD', 'COME');Output+--------------------------------+
| INSTR('WELCOME WORLD', 'COME') |
+--------------------------------+
|                              4 |
+--------------------------------+
(iii)SELECT ROUND(23.78, 1);Output+-----------------+
| ROUND(23.78, 1) |
+-----------------+
|            23.8 |
+-----------------+
(iv)SELECT MOD(100, 9);Output+-------------+
| MOD(100, 9) |
+-------------+
|           1 |
+-------------+
(v)SELECT TRIM(userid) FROM USERS;

Question 20

Question 1Based on the SQL table CAR_SALES, write suitable queries for the following :NUMBERSEGMENTFUELQT1QT21Compact HatchBackPetrol56000700002Compact HatchBackDiesel34000400003MUVPetrol33000350004MUVDiesel14000150005SUVPetrol27000540006SUVDiesel18000300007SedanPetrol8000100008SedanDiesel10005000(i) Display fuel wise average sales in the first quarter.(ii) Display segment wise highest sales in the second quarter.(iii) Display the records in the descending order of sales in the second quarter.

Accepted Answer

(i)SELECT FUEL, AVG(QT1) AS Avg_Sales_QT1 
FROM CAR_SALES 
GROUP BY FUEL;Output+--------+---------------+
| FUEL   | Avg_Sales_QT1 |
+--------+---------------+
| Petrol |    31000.0000 |
| Diesel |    16750.0000 |
+--------+---------------+
(ii)SELECT SEGMENT, MAX(QT2) AS HIGHEST_SALES
FROM CAR_SALES
GROUP BY SEGMENT;Output+-------------------+---------------+
| SEGMENT           | HIGHEST_SALES |
+-------------------+---------------+
| Compact HatchBack |         70000 |
| MUV               |         35000 |
| SUV               |         54000 |
| Sedan             |         10000 |
+-------------------+---------------+
(iii)SELECT * FROM CAR_SALES
ORDER BY QT2 DESC;Output+--------+-------------------+--------+-------+-------+
| NUMBER | SEGMENT           | FUEL   | QT1   | QT2   |
+--------+-------------------+--------+-------+-------+
|      1 | Compact HatchBack | Petrol | 56000 | 70000 |
|      5 | SUV               | Petrol | 27000 | 54000 |
|      2 | Compact HatchBack | Diesel | 34000 | 40000 |
|      3 | MUV               | Petrol | 33000 | 35000 |
|      6 | SUV               | Diesel | 18000 | 30000 |
|      4 | MUV               | Diesel | 14000 | 15000 |
|      7 | Sedan             | Petrol |  8000 | 10000 |
|      8 | Sedan             | Diesel |  1000 |  5000 |
+--------+-------------------+--------+-------+-------+

MySQL Functions

Multiple Choice Questions

Type A Short Answer Questionsconceptual Questions

Type B Short Answer Questions