Multitasking , in a variety of environments, long distance communications
The format for the UPDATE command is the word UPDATE, followed by the name of the table to be updated. The next portion of the command consists of the word <u>SET</u>, followed by the name of the column to be updated, an equals sign, and the new value.
Explanation:
- An Update Query is an action query (SQL statement) that changes a set of records according to criteria you specify.
- The SQL UPDATE Query is used to modify the existing records in a table. You can use the WHERE clause with the UPDATE query to update the selected rows, otherwise all the rows would be affected.
- Update Queries let you modify the values of a field or fields in a table.
<u>UPDATE Syntax
</u>
- UPDATE table_name
- SET column1 = value1, column2 = value2, ...
- WHERE condition;
UPDATE table_name SET column1 = value1, column2 = value2, etc WHERE condition;
- table_name: name of the table
- column1: name of first , second, third column....
- value1: new value for first, second, third column....
- condition: condition to select the rows for which the
- values of columns needs to be updated.
Answer:
Hyperlink camp’s web page to the document is the right answer.
Explanation:
Adding pictures will occupy more space, activity schedules might change time to time. So considering all these factors, it is better to go for adding hyperlink of the web page in the excel. The advantage here is that, if we keep all additional data in web, we can update content any time and the client can view at any time.
Also images are displayed best in web only. If we add additional column in excel, it might not work fine for adding pictures or menu. Even if we add additional worksheet, it might not satisfy the need.
Answer:
Option B, to instantly compare results when data in numerous cells change to specified values
Explanation:
Scenario setting with in the What If Analysis is used to compare various scenarios with in the same excel sheet. Scenarios has set of values that are saves and updated automatically as the values with in the cell changes. Also the scenarios can be switched.
Hence, option B is correct
11 answer would be A and 12 answer would be C as a freelancer there is no guarantee of jobs or job security
