Question

Gender
DOB
1. Answer the following question based on table.
Reg_No Student Name Class
APS101 Abhishek
APS102 Aradhya
10
APS103 Chetan
10
APS104 Soumya
10
APS105 Sandeep
10
M
F
14-09-2005
12-05-2004
01-04-2004
05-11-2002
07-12-2000
M
a) Which field can become a primary key in the above table?
b)Write the appropriate data type for the field Reg_No.
c) What is the validation rule for DOB?
d) Write the SQL Query to add a new record with the following details
(6,'Sahana', '10', 'F', '06-8-2001')
e) Write the SQL query to modify the class of APS105 from class 10 to class 9​

Answer 1

Answer:

aps103sanddep

aps104soumya