Answer:
SELECT last_name, job_title, hire_date FROM employee WHERE hire_date>="01-12-2016" AND job_title != "STOCK CLERK" ORDER BY job_title DESC;
Explanation:
The SQL code queries the employee table returning records of the last_name, job_title, and hire_date columns matching the employees hired on or after December 2016 and job titles that are not stock clerks in the employee table.
The WHERE and AND clause is responsible for the condition while the ORDER BY clause returns the query result in the of the job title in descending order.
Answer:
Microsoft Excel
Explanation:
Microsoft Excel is a Microsoft application package. It is a spreadsheet application used to analyse and manipulate data. It has columns which are referred to fields and rows also known as records.There are various features in excel that used to create statistical and graphical esctasies and data presentations.
It can be used to create template for CVs/resumes, Bank draft, receipts and invoice etc.
Answer:
The back propagation algorithm causes the network to settle into a stable state where it can correctly respond, to any desired degree of accuracy, to all inputs in the training set.
Explanation:
Back propagation algorithm is a part of the learning of a neural network. In a simple neural network setting at each iteration;
- The network<em> </em>assumes <em>random weights</em> at each network layer and passes the value to the next trough an <em>activation function</em>.
- Then a loss function is calculated by comparing the distace of the final value with the label value using a predetermined distance metric.
- The weights are optimized trough back propagation
Thus, back propagation algorithm used to reach the final weights of the neural network, so that it can work more accurately.
Answer:
This is because, the advertisers report the storage space in decimal while the computer reads the storage space in binary.
Explanation:
The advertisers report the storage space in decimal or base 10 because humans count in decimal, whereas the computer reports the storage space in binary or base 2.
Since the computer storage is in bytes and 8 bits equal 1 byte, It is easier to write a storage space of 1 kB as 1000 B but it is actually supposed to be 1024 B(2¹⁰). So, there is a discrepancy of 1024 B - 1000 B = 24 B.
As we go higher, the discrepancy increases. For example, 1 MB is advertised as 1000 kB = 1000000 B but is actually supposed to be 1024 kB = 1024 × 1024 B = 1048576 B. So, there is a discrepancy of 1048576 B - 1000000 B = 48576 B.
So, the actual number of bytes on the storage device is actually less than that reported due to the different number systems in which they are reported in. This discrepancy is less in memory cards or flash drives though in which the stated value of storage capacity might be the actual storage size.
Note that the base 10 or decimal system was chosen by advertiser since this is what consumers understand.
