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

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

Q3. Consider the following Answer the following question based on 

Table STORE

itemno	itemname	supplier	qty	rate	city	state
1001	Chocolate	Cadbury India	150	40.00	Pune	Maharashtra
1002	Bread	Amul	500	30.00	Anand	Gujarat
1003	Cookies	Dark Fantasy	250	35.00	Haridwar	Uttarakhand
1004	Biscuits	Parle	700	25.00	Jaipur	Rajasthan
1005	Namkeen	Gopal	500	45.00	Rajkot	Gujarat
1006	Sev	Bikaji	600	32.00	Bikaner	Rajasthan
1007	Chocolate	Amul	500	42.00	Anand	Gujarat

 

1. Display the records in the descending order of rate 
2. Display the itemname, supplier from Gujarat and Rajasthan. 
3. Display Supplier , qty, rate and itemno
4. Display the information of items whose price is more than 30. 

Answer :

1. Select * From STORE order by rate;

OR

    Select * From STORE order by rate asc;

2. Select supplier,qty,rate,itemno From STORE ;

3. Select itemname, suppllier  From STORE where state = "Gujarat" or state = "Rajasthan";

4. Select * From STORE where rate >30;

You can comment your answer below this post.