Very important Database Table based question with solution | Subject Code : 402 | Part 1

Very important Database Table based question | CBSE Class 10 | Subject Code : 402 | Part 1

Hello student try these question based on Database management. This questions are very important for your class 10 Board examination. In CBSE board examination CBSE asked 4 questions of 4 Marks based on Database Table. Today I am sharing Part 1 of Question bank important for CBSE Class 10 Subject code 402. Answer of these question with explanation will update soon on My YouTube Channel Informatics Practices with Python. Subscribe My channel and get regular update when new video uploaded on my Channel . After doing all questions of question bank you will score 100% in DATABASE MANAGEMENT SYSTEM. Soon we will share more question based on DATABASE MANAGEMENT SYSTEM. 

Q1. Write down SQL query for following question base on 

Table : Student

rollno	name	stream	percentage	class
1201	Krish	Commerce	85.79	12D
1202	Jay	Science	89.71	12B
1203	Nadiya	Commerce	92.74	12C
1204	Archi	Science	72.84	12A
1205	Adnan	Commerce	84.86	12D
1206	Mahek	Science	62.11	12B

1. Display the student’s details of the commerce stream.
2. Display records of class 12D  students
3. Display  the name whose percentage more than 64.15.
4. Display the records of those who belongs to Commerce.

Answer: 

1. Select * from STUDENT where stream ="Commerce";

2. Select * from STUDENT where class ="12D";

3. Select NAME from STUDENT where percentage >=64.15;

4. Select * from STUDENT where stream ="Commerce";

You can comment your answer of these questions.