CPSC1050_OS and Information Systems

A record is a named heterogeneous collection of items in which individual items are accessed by index.

• True

• False

Given the following spreadsheet, which of the following is the correct formula in cell C3 to scale the grade in C2 by 4% (cell F2) and can be copied to cells D3:E3?

• C2 * $F$2

• C2 * F2

• C2 * F$2

Given the following table called 'coffee', write a SQL query that changes the Price for Hot Chocolate to 2.99.

• UPDATE coffee SET Price = 2.99 WHERE item = 'Hot Chocolate'

• SET Price = 2.99 UPDATE coffee WHERE item = 'Hot Chocolate'

• INSERT coffee SET Price = 2.99 WHERE item = 'Hot Chocolate'

• INSERT INTO coffee (Item, Price) VALUES ('Hot Chocolate', 2.99)

In which state does a process reside if it is waiting only for its turn to use the CPU?

• running

• ready

• waiting

• new

Suppose processes P1 through P5 arrive in the ready state at essentially the same time in the order given below. Given the service times shown, what would be the Turnaround Time for P2 using Round Robin scheduling algorithm with time slice of 60? (NOT the total turnaround time)

• 90

• 300

• 330

• 270