Answer:
Using join on both table against column CUST_ID will return customer ID, company and total sales
Explanation:
select
CUSTOMERS.CUST_ID,
CUSTOMERS.COMPANY,
SALES.TOTAL_SALES
from CUSTOMERS JOIN SALES
ON
CUSTOMERS.CUST_ID=SALES.CUST_ID
Above query selects required customer id and company table from customers table and total sales from sales table and apply join against customer id
JOIN in sql returns all the row where for a value in first table there is a matching value in second table.
answer:
transgenic means that one or more DNA sequences from another species have been introduced by artificial means.
explanation:
- transgenic plants can be made by introducing foreign DNA into a variety of different tissues
- transgenic mice are one of the most common animal models used
Answer:
Add an entry to the HOSTS file
Explanation:
A file that is used to add the host name along with their IP addresses is called Host file. In this file all the IP addresses are mapped with their respective host names. Whenever some user tries to access some website, he may use the name of website to access it. The website have both name and IP address of the server, both of these information stored in host file. On GUI the user only see the information of Host name.
If some user only access the IP address of the website instead of the host name. The technician should add the name and IP address of the host in Host file. He should follow the following steps to resolve the problem.
- Access the host file by following the given path of file in Windows operating system.
- open the host file
- edit the file with new host name and relevant IP address
- save the changes
Answer:
Yes a computer can evaluate between a true or false. x < 1, and if the condition is met, the value is true, else its false. A computer itself cannot handle any "maybe" expression, but with the influence of human opinion, in theory its possible. Chocolate cake < Vanilla cake, is an example. Entirely on opinion.
