Answer:
a) SELECT COUNT(*)
FROM Supplies
WHERE sid=T OR sid=X;
b) SELECT sid
CASE
WHEN sid=IMB AND pid=T
THEN 'YES'
ELSE 'No'
END AS 'check'
FROM Supplies
c) SELECT pid
WHERE partname != computers
FROM Parts
LEFT JOIN Supplies
ON Parts.pid=Supplies.pid;
d) SELECT color
FROM Parts
WHERE pid=T;
Explanation:
a) Here we will use aggregate function along with WHERE and operators to count for specifc part ids
b) This is a CASE query
c) This is again a case query but invloves two separate tables. So, here 1st required values from 1st table are selected and then table is joined with the other table using OUTER JOIN
d) This is again a CASE query. It can be written by calling upon the all the values in one column corresponding to values in another column
The answer would be...ACLs
It should be listed as one on it's product information sheet.
Answer.
1.Surge protection board
2.Uninterrupted Power Supply (UPS)
Explanation
A surge protection board is designed to protect equipment against a power surge or over voltage in power supply.A UPS provides back up power in occasions of power outage.In most events of power cut,UPS units only allow a person to save the work and perform a controlled shutting down of a computer.
