Page 335 - Trackpad 402_Class-X_Final
P. 335
19. Consider the following table : STUDENT [2022]
ADMNO NAME GRADE DOB MARKS HOUSE GENDER
1001 RUPAL 9 10/04/2006 76 GREEN M
1002 RASHMI 9 08/12/2005 87 RED F
1003 ARNAV 10 25/05/2004 81 GREEN M
1004 SUMONA 9 23/08/2005 68 RED F
1005 ARUN 9 16/07/2005 72 GREEN M
1006 TIA 9 22/09/2005 91 BLUE F
1007 ROSHAN 10 26/08/2004 89 BLUE M
Write SQL Commands:
a. To display the details of all students of Green House.
b. To increase the marks by 5 whose ADMNO is 1005.
c. To display the details of all students whose MARKS are less than 80.
d. Display the list of all students in descending order of MARKS.
20. Create table EMPLOYEE [2020]
EMPID Char(4)
EMPNAME Varchar(15)
DESIGN Varchar(20)
SALARY Decimal
21. command is used to create a new table in a database. [2018]
a. New b. Create
c. Alter d. Select
22. Write SQL query to create the Table Flight with the following structure: [2018]
23. Consider the following table and answer the following: [2018]
a. Identify suitable Primary Key from the above table.
b. Add a new record with the following data:
(‘H608’, ‘Cardiology’, ‘TTS’, ‘Vinita Wahi’)
c. Write a select query to display records of those Doctors whose OPD_DAYS are ‘MWF’.
24. What is DDL ? Mention any two DDL statements. [2018]
25. What do you mean by DDL and DML commands? [2017]
Database Management System 335

