Page 416 - Trackpad 402_Class-X_Final
P. 416

21.  Consider the following Vendor table and write the queries for the following:                       4
            Table Datesheet

               Sub_code     Sub_Name    DateofExam      Days
                 E001        English     11-03-2021   Monday
                 H002         Hindi      15-03-2021    Friday

                 S003       Social Sci.  18-03-2021   Monday
                 S004        Science     21-03-2021   Thursday

            i.  Write a SQL command to display the records in ascending order by date of exam.
            ii.  Write a query to display the above date sheet.
            iii.  Write a query to display the subject name and date of the exam held on ‘Monday’
            iv.  Write a SQL command to display the date of exam and Sub_Name of Science subject.

        For Visually Impaired Students
        22.  Write a short note on the following:                                                               4
            a.  DBMS
            b.  Database Server
            c.  Data Integrity
            d.  Record





















































          416   Trackpad Information Technology-X
   411   412   413   414   415   416