Kizspy. me or example, if we execute the following statements to insert two doctors (one with DepartmentID=NULL and the other with DepartmentID=5) and then select these two doctors,we can see that the DepartmentID of the doctor with DepartmentID=null is set to the id of the
department named 'Cardiology' as shown in the following figure:
insert into Doctors (DoctorID, FirstName, LastName, PhoneNumber, Email, DepartmentID)
values (70,'Van Chien', 'Nguyen', '0928367812', '
[email protected]', null),
(71, 'Thi Binh', 'Nguyen', '0989278127','
[email protected]',5)
select from Doctors where DoctorID in (70,71)
DoctorID FirstName LastName Phone Number Email DepartmentID
70 Van Chien Nguyen 0928367812
[email protected] 1
71
Thi Binh Nguyen 0989278127
[email protected] 5
1
2
8 of 8
Paper No: 7
Question 10:
Picture 9.1
Write statements to delete from the Tests table two tests named 'Blood Test' and 'CT Scan'
Zoom
+ 90%
Close
