Commerce (English Medium) Class 12 - CBSE Question Bank Solutions

What will be the output of the following code:

>>>import pandas as pd
>>>A = pd.Series(data = [35, 45, 55, 40])
>>>print(A > 45)

Write outputs for SQL queries that are based on the given table PURCHASE:

1. SELECT LENGTH(CNAME) FROM PURCHASE WHERE QUANTITY>100;
2. SELECT CNAME FROM PURCHASE WHERE MONTH(DOP) = 3;
3. SELECT MOD (QUANTITY, DAY(DOP)) FROM PURCHASE WHERE CITY = ‘CHANDIGARH’;

Based on the table STUDENT given here, write suitable SQL queries for the following:

1. Display gender-wise highest marks.
2. Display city-wise lowest marks.
3. Display the total number of male and female students.

Write suitable SQL query for the following:

Display 7 characters extracted from the 7^th left character onwards from the string ‘INDIA SHINING’.

Write suitable SQL query for the following:

Display the position of occurrence of the string ‘COME’ in the string ‘WELCOME WORLD’.

Write suitable SQL query for the following:

Round off the value 23.78 to one decimal place.

Write suitable SQL query for the following:

Display the remainder of 100 divided by 9.

Write suitable SQL query for the following:

Remove all the expected leading and trailing spaces from a column userid of the table ‘USERS’.

Explain the following SQL function using a suitable example.

UCASE()

Explain the following SQL function using a suitable example.

TRIM()

Explain the following SQL function using a suitable example.

MID()

Explain the following SQL function using a suitable example.

DAYNAME()

Explain the following SQL function using a suitable example.

POWER()

Shreya, a database administrator has designed a database for a clothing shop. Help her by writing answers to the following questions based on the given table:

1. Write a query to display cloth names in lowercase.
2. Write a query to display the lowest price of the clothes.
3. Write a query to count the total number of clothes purchased in medium size.
   OR
   Write a query to count the year-wise total number of clothes purchased.

Which SQL statement do we use to find out the total number of records present in the table ORDERS?

Which of the following can be used to specify the data while creating a DataFrame?

Assertion (A): DataFrame has both a row and column index.

Reasoning (R): A DataFrame is a two-dimensional labelled data structure like a table of MySQL.

Rashmi, a database administrator needs to display house wise total number of records of the ‘Red’ and ‘Yellow’ houses. She is encountering an error while executing the following query:

SELECT HOUSE, COUNT (*) FROM STUDENT GROUP BY HOUSE WHERE HOUSE=’RED’ OR HOUSE= ‘YELLOW’;

Help her in identifying the reason for the error and write the correct query by suggesting the possible correction (s).

What is the purpose of the Order By clause in SQL? Explain with the help of a suitable example.

Mention any four net etiquettes.