Answer:
The number of invoices for each vendor that have a larger balance due than the average balance due for all invoices.
Explanation:
This part of the code below
WHERE InvoiceTotal - PaymentTotal - CreditTotal >
(SELECT AVG (InvoiceTotal - PaymentTotal- CreditTotal)
FROM Invoices)
gives the condition to pick the invoices with balance that are greater than the average balance for all invoice.
This part of the code below
GROUP BY VendorName
ORDER BY BalanceDue DESC;
then enables the program to group the result of the above condition by VendorName and sort the resulting rows in the order of BalanceDue. You will therefore, obtain for each row in the NumberOfInvoices column, the number of invoices for each vendor that have a larger balance due than the average balance due for all invoices.
Answer:
a. Telnet transmissions are not encrypted.
Explanation:
Indeed, since <em>Telnet transmissions are not encrypted,</em> all the information sent, and even the characters typed in the telnet console are sent in clear text.
This is a security issue, since any other device in the same network will receive a copy of the information (packets) sent. For default, all the devices, except for the server expecting to receive the information, will discard the packets. However it is easy to actively <em>listen </em>and keep those packets, wich will contain the information in plain text and human readable.
It is a good programming practice to explain your functions by writing comments that describe what they do.
Performance problems in a computer system are usually due to hardware & software problems.