Commerce (English Medium) Class 12 - CBSE Important Questions for Informatics Practices

Mention any two ways to avoid plagiarism.

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 SQL statement do we use to find out the total number of records present in the table ORDERS?

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?

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

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.

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.

Discuss the significance of Group by clause in detail with the help of a suitable example.

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