Because cache misses lead to pipeline stall, they increase the CPI of a pipelined processor. True False Answer this question based on a direct-mapped cache design with the following bits (32-bit) of the address are used to access the cache. Tag: 31-10 Index: 9-5 Offset: 4-0 What is the cache block size (in words)? 12 4 8. We can't say by the given information.

You have been told that you need to store the zip code for employees.  Add a column to the EMPLOYEE table which will be used to store each employee’s zip code Update two rows in the EMPLOYEE table and assign a zip code (must have a WHERE clause).  (you MAY use 1 or 2 statements)  Write a query that includes each employee's last name, department name (not ID), and salary for each employee whose salary is less than the average for their department

List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.

IN SQL If you omitted the WHERE clause of SELECT statement, the query returns an error because the where clause is required. Select one: True False

pythin in file and list , I want to make list of month from Jan to Dec , and enter sales for each month . Make average , total , minimum and max sales .

The InstantRide User Satisfaction team requires the average and maximum number of rides users have taken so far with InstantRide. In addition, they would like to know the total number of travels. However, they need these details with the corresponding column names Average, Maximum and Total by using the AVG, MAX and SUM functions. In order to accomplish this, you will first need to create a derived table from the TRAVELS table to pass the TRAVEL_ID count to the three mathematical functions.

Which operator should you use to find NULL values?

the employee table have the following . ask user what is the employee_id and how much employee wants to contribute 2 substitutions variable from end user &emp_id      &contribution_amount If employee salary is in between $1000-$3999 And if  employee's contribution amount is less than $100 then company match $100                   if  employee's contribution amount is greater than 100 but less than $200 then company match $75                  if  employee's contribution amount is greater than $200 then company match $50 $4000-$6999 And if  employee's contribution amount is less than $100 then company match $150                   if  employee's contribution amount is greater than 100 but less than $200 then company match $100                  if  employee's contribution amount is greater than $200 then company match $75  $7000-$12000And if  employee's contribution amount is less than $100 then company match $200                   if  employee's contribution amount is greater than…

What is the Median for the following numbers: 8, 77, 44, 83, 63 Level of difficulty = 1 of 2 Please format to 2 decimal places?

You should use an Oracle function to calculate the number of days that have gone between your birthday and the current date.