Answer:
The answer is "number of the column containing the return value".
Explanation:
In Excel, the "VLOOKUP" method is used to perform the vertical search by looking for both the value during the user table and retrieving the number of the index number location in the same row. It is a built-in function, which is classified as a Lookup or Reference worksheet function, and the following function can be defined as follows:
- In the 1st parameter, it is used to watch the value for the match.
- In the 2nd parameter, it is used to search the table.
- In the 3rd parameter, it is used as the column number representing the return value.
- In the 4th parameter, it is used to return only if the same match is found.
Answer:
a. 0.01
b. 0.001
c. The identification field of the packet fragment can be used to uniquely identify and collate the fragments lost in transmission.
Explanation:
The probability of losing a packet is 10% or 0.1, so the probability of losing the packet twice during transmission;
= 0.1 x 0.1 = 0.01
When any fragments have been part of the transmission, the probability of the packet is dependent on the fragments;
= 0.01 x 0.1 = 0.001
The identification field is a unique 16-bit value assigned to an IPv4 packet, when a packet is fragmented for transmission, its field is used to collate the unique fragments in the packet.
Answer:
Cache is the fastest and most expensive, RAM is slower and less expensive, and virtual memory is the slowest and least expensive type.
Explanation:
Depends really. Have you got prior coding experience? The semantics of certain languages are much easier to pick up if you've had prior experience, but it might seem impossible to someone who has minimal experience.
Assuming that you're no older than 15 or 16, I'm going to suggest Python. It's a simple, high-level language that's easier to understand than most languages. If you think you've got enough experience to quickly understand and pick up things, then I'd probably say R is a good language to start with. It's very well-suited for AI and tends to be a favourite for AI researchers.
Answer:
D) use SQL or graphical tools to query the database
Explanation:
To query the database using SQL or graphical tools will help Howie to retrieve bulk of records from the database according to his requirements and it will help to understand and work with the data in a better way than using the data in raw form.
SQL is a language of database used to manipulate and manage the data in the relational database and to query the database.
It is an easy and faster way to query using SQL or graphical tools because no coding is required here.
Different graphical tools are used to present the data in the database in a way that can be easily understood by a person. Different interfaces are provided to visualize the database tables or schema diagrammatically e.g in the form of graphs etc. Different views of the database can be provided to different users according to their requirement and what information they required to be presented.