MySQL Class 12 Quiz-9

Share with others

Welcome to your MySQL Class 12 Quiz-9

Name
Email
School Name
Q81. Consider the following column of table "student"

Name
Amit
Sumit
Naina
Null

Write the output of the following query.

Select Count(*) from student;

Q82. Consider the following column of table "Teacher"

Name
Amit
Sumit
Naina
Null

Write the output of the following query.

Select Count(Name) from Teacher;

Q83. Consider the following column of table "sports".

Category
1
2
3
2
1
4
1

Write the query for the following

Display the total number of records from table "sports" having category 1

Q84. Consider the following column of table "sports".

Category
1
2
3
2
1
4
1

Write the query for the following

Display the total number of different types of category from table "sports".

Q85. _________________ Clause in SQL is used to specify conditions on the rows with Group By clause.

Q86. Which clause fetch a group of rows on the basis of common values in a column?

Q87. Consider the table given below and answer the following questions

MCQ on SQL Class 12

Write the query for the following:

Display the number of Cars purchased by each Customer from SALE table.

Q88. Refer to the table given in Q87, Write the query to display the Customer Id and number of cars purchased if the customer purchased more than 1 car from SALE table.

Q89. Refer to the table given in Q87, Write the query to display the number of people in each category of payment mode from the table SALE.

Q90. Refer to the table given in Q87, Write the query to display the PaymentMode and number of payments made using that mode more than once.


Share with others

Leave a Reply

error: Content is protected !!