Very important Database Table based question with solutions | Subject Code : 402 | Part 2

 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 2 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. 

Q2. Consider the following Answer the following question based on

Table – candidate : 

Sno	name	fees	subject	marks	status
1	Preet	350	PCM	68	pending
2	Vansh	450	PCB	52	pending
3	Dhwanil	350	PCM	89	admitted
4	Kirsha	450	PCM	75	pending
5	Diya	350	PCB	72	admitted

1. Display all details whose PCM subject.
2. Display names of candidates whose admission is pending in ascending order of name. 
3. Display the records of PCB candidates whose marks are less than 70. 
4. Display the name, fees and subject of candidates whose fees are more than 400. 

Answers:

1. Select * from CANDIDATE where subject ="PCM";

2. Select name from CANDIDATE where status = "pending" order by name;

OR

    Select name from CANDIDATE where status = "pending" order by name asc;

3. Select * from CANDIDATE where subject ="PCM" and marks <70 ;

4. select name,fees,subject from CANDIDATE where fee >=400.

You can comment your answer of these questions.