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

