Values = [1.1, 10, 4.55, 30004, 0.2]
Answer:
UPDATE acctmanager WHERE amid = 'J500';
Explanation:
The statement written above is not valid SQL statement because there is no SET after UPDATE. Update is always used with SET.If you are updating something then you need to specify the value with which that value should be replaced.
UPDATE acctmanager SET amname = UPPER(amname);
This statement does not contains WHERE clause but it will run all the values of amname column will get updated in the table acctmanager.
Answer:
d. refresh
Explanation:
The Excel software does not allow a user to change values/data directly in the Pivottable. You will get an error message like "Cannot change this part of a PivotTable report" when you try to type data directly. You will have to edit the Excel Table and then refresh to reflect the updated data.
Answer:
Check below for answers and explanations.
Explanation:
The major reasons why computer processes are suspended or terminated are:
1. When there is insufficient memory for successful completion of the process
2. When there's an unauthorized access of any of the computer resources by the process.
It is possible that some processes are terminated why some are suspended because, when the system runs out of memory, the running processes are put on hold until the system is able to create free memory space for the completion of the process. In this case the process is suspended. But if the system cannot provide enough space for the process, the process is terminated.
In the example provided in this exercise, some of the processes were suspended because the system wants to create free memory space for their completion while others are terminated either because the available space is not sufficient for their completion or they want to access an unauthorized resources on the system.
The correct answer would be D
