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

Write a Python code to create a DataFrame with appropriate column headings from the list given below:

[[101,'Gurman',98], [102,'Rajveer',95], [103,'Samar' ,96], [104,'Yuvraj',88]]

Which type of values will not be considered by SQL while executing the following statement?

SELECT COUNT(column name) FROM inventory;

If column “Fees” contains the data set (5000,8000,7500,5000,8000), what will be the output after the execution of the given query?

SELECT SUM (DISTINCT Fees) FROM student;

Which one of the following is not an aggregate function?

Which one of the following functions are used to find the largest value from the given data in MySQL?

To display the last five rows of a series object ‘S’, you may write ______

Which of the following statement will import pandas library?

In SQL, which function is used to display the current date and time?

______ is the trail of data we leave behind when we visit any website (or use any online application or portal) to fill in data or perform any transaction.

Write a program to create a series of objects using a dictionary that stores the number of students in each house of class 12D of your school.

Note: Assume four house names are Beas, Chenab, Ravi, and Satluj having 18, 2, 20, and 18 students respectively and pandas library has been imported as pd.

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()