A one dimensional array A has indices 1....75. Each element is a string and takes up three memory words. The array is stored starting at location 1120 decimal. The starting address of A[49] is

A.  1167

B.  1164

C.  1264

D.  1169

Suppose you have 2 array of multidimensional. If you are python developer, how you will convert these array into one single dimensional array. Show proper code assuming that given array were numpy array.

Write proper code in python

Create a program that will allocate an array of quad integers and assign them some numbers. (Assembly Language and example below)

.data

Array: .quad xxx

             .quad xxxx

In your program, update the numbers to sequential numbers. (Load the address and save new data into the memory location) you can add to the memory base address or use relative addressing to move to different indexes in the array.

Write a series of statements that will add all the new data in the array into one sum.

Add a new variable to the data segment that will hold the average of these numbers.

Add a variable that will hold the remainder of any division. (modules)

Take the sum and divide it by the number of items in your array and save that answer in the variable you just added above.

Save the remainder of the division into the remainder variable, you added above.

(Needs to be done in Assembly Language in Linux 64 bit Ubuntu)

Q5. There are two tables with the following details:

Ride_details table:

Ride_id – A unique entry for each ride taken. Created_at – The time on which the ride was created. Pickup_location – An id for the pickup location.

Drop_location – An id for the drop location.

Location table:

Location_id – A unique entry for each location.

Metro_location – 1 implies that the stand is a metro station. 0 implies that the stand is not a metro station.

Write an SQL query to get the date wise number of rides in the following sets -

1. Rides starting from the metro and ending at a non-metro location - Column name – metro_start

1. Rides starting from a non-metro location and ending at the metro station - Column name –

metro_end

1. Rides starting and ending at the metro station - Column name – metro_start_end

Rides starting and ending at a non-metro location - Column name – non_metro_start_end