On your sheet of paper, copy the following statement and sign your name below it: I understand that this quiz will be marked “NOT Present” if the 10 exam procedures are not followed, and that my original scores on Q1, Q2, and Midterm 1 will not be restored.I understand that this Restore-Your-Score Quiz is only able to recover points on Exam 2 that resulted in a 0 due to failure to meet exam policies.                           X___________________________(signature)

ConConsider a table Product(id, cost) where id is a key. The table initially contains two tuples: (1, 100) and (2, 150). Two transactions execute concurrently as follows: Transaction T1: BEGIN TRANSACTION; A1: INSERT INTO Product VALUES (3, 200);A2: UPDATE Product SET cost = cost + 50 WHERE id = 1; COMMIT; Transaction T2: BEGIN TRANSACTION; B1: SELECT SUM(cost) AS s1 FROM Product;B2: SELECT SUM(cost) AS s2 FROM Product; COMMIT; Assume all statements execute atomically. Transaction T1 always uses isolation level Serializable. If Transaction T2 also uses Serializable, what possible pairs of values (s1, s2) can it return?  

Congratulations on reaching the end of this quiz! We will now take a few moments to walk through the steps to submit your required work. It is important you do these before submitting an answer to this final question (and during other assessments, before you close out of D2L) so they are completed during your Honorlock proctoring session. Skipping any of these steps can result in you being marked “NOT Present” and receiving a score of 0 on the quiz.  Check off each item as you complete it. Again,  Read each item carefully Ensure that you have done it Check off each box when completed

We are a new travel website which offers exclusive discounts from our partner resorts and tour groups to discerning clients that have a credit card with our parent corporation.  The number of offerings is not huge because we target only high end properties and exclusive tour groups for out clients.  We want to calculate the best index to make in our database to maximize performance for our customers who can assess the database through our website and view our travel offerings. Bookings are done in another systems once a customer is ready to book. We estimate that all of the database transaction for the table we are currently interested in can be placed into three query types. Q1: Queries that our clients execute that accesses information about travel destinations in a specific category (skiing, diving, adventure, luxury travel etc) Q2: Queries that our clients execute that access information about activities in a specific location which are broken down into either city or subcity sections depending on the city size (, Tokyo Ginza area, London Mayfair, Concord, Tampa etc) Q3: Queries that our sales team performs that add new resorts and tours organization to our partnership data base so the customers can discovery them.  Because we are new the addition of new clients has been rapid Assumptions about the data.  We have grown considerably and this table is currently 40 pages in length so if we have to access the entire database it required 40 pages reads. On average a location has 5 partner offerings and each category of offering is available in 20 different locations. Make the assumption that if we know the locations of each partner we still make 5 disk access for Q2 and if we know the locations of the offerings  in each category 20 disk access are required for Q1. One disk access is required to read any index we use and if we modify the database we must also modify the index (requiring both a read and a write (2 disk access)). We will also assume that if we modify the database we can find a blank page and will only require one disk access to read the page and one to write back the modified page. Given these assumptions would it be better to use no index, one index on locations, one index on offerings, or two indexes (both offerings and locations)? Action Frequency No index Index on offerings Index on Location Both index Q1: Category .30         Q2: Location .60         Q3: Update .10         Average           Calculate the average for each of the 4 options.  What is the lowest average (report to 1 decimal place e.g. XX.x)?

The table “Department” was created with the specification below.    CREATE TABLE Department ( Code TINYINT UNSIGNED, Name VARCHAR(20) UNIQUE, ManagerID SMALLINT, Appointment DATE, PRIMARY KEY (Code), UNIQUE (ManagerID, Appointment) );True or False that the two rows below violate the UNIQUE constraints on Department. (12, ‘Marketing’, 2538, ‘2019-11-22’) (99, ‘Marketing’, NULL, NULL)

Consider table Worker(name,pay) where name is a key, and the following two concurrent transactions.   T1:   Begin Transaction   S1: update Worker set pay = 2*pay where name = ‘Amy’   S2: update Worker set pay = 3*pay where name = ‘Amy’   Commit T2:   Begin Transaction   S3: update Worker set pay = pay-20 where name = ‘Amy’   S4: update Worker set pay = pay-10 where name = ‘Amy’   Commit Assume that the individual statements S1, S2, S3, and S4 always execute atomically. Let Amy’s pay be 50 before either transaction begins execution. Suppose both transactions T1 and T2 execute to completion with isolation level Read-Committed.  What are the possible values for Amy’s final pay?  

A NULL value represents _________

A _____ is a collection of values with no inherent order

Refer to the Product table. Which of the following would complete the SQL statement to select all products with sizes 0-3M, 3-6M, and 6-9M (Select all options that would work). SELECT ProductName, Quantity FROM Product WHERE Size _____ (‘0-3M’, ‘3-6M’, ‘6-9M’);

Refer to the Product table. Complete the SQL statement to select the two set…… ‘Cosmic Encounters Expansion Set’ and ‘Terraforming Mars Expansion Set’. ProductID Product Name Price Quantity 012 Cosmic Encounters Expansion Set 95.99 12 011 Terraforming Mars 69.95 6 143 Mousetrap 56.95 12 214 Terraforming Mars Expansion Set 95.99 18 421 Cosmic Encounters Basic 49.95 6 129 Azul 44.99 24 SELECT ProductName, Quantity FROM Product WHERE ProductName LIKE _____;