+2 votes
in Class 12 by kratos

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.

1 Answer

+5 votes
by kratos
 
Best answer

(i) Animalld = char

VaccinationDate = Date 2015-02-12

(ii) No, it will not be inserted as AnimalName column can't have NULL values.

...