Srishti has created the following table with the name’Veterinary’.
Column Name | Constraint |
Animalld | Primary Key |
VaccinationDate | |
AnimalName | Not Null |
OwnerName |
One of the rows inserted is as follows :
Animalld | VaccinationDate | AnimalName | Storeld |
A101 | 2015-02-12 | Sheru | Amit Sharma |
(i) What are the data type of columns Animalld and Vaccination Date in the table Veterinary ?
(ii) Srishti is now trying to insert the following row :
Animalld | VaccinationDate | AnimalName | OwnerName |
A102 | 2015-08-09 | NULL | Abhimanyu Shah |
Will she be able to successfully insert it ? Give reason.
(i) Animalld = char
VaccinationDate = Date 2015-02-12
(ii) No, it will not be inserted as AnimalName column can’t have NULL values.