Transaction B can commit on this schedule? (True/False) 

Find the total cost (total blocks transfer) using Merge Join =  _______ If the size of buffer is in memory = 4 blocks for r, 2 blocks for s and using Nested Loop Join,  what is total of block transfer? =  _______ What does the total block seek? =  _______

A new skyscraper is to be added to the Orlando skyline. Its roof, in red below, is determined by the equation

  Using Figure 15.7 Merge join with the following relation R and S:    Round# Record in R where pr point to Record in S where ps point to SS … … … …       A.) Create the table, fill in all the values after each round for the outer while loop? (5 Points)        B.) What is the output relation after doing the merge join between R and S?            (3 Points) Please upload file to answer the question.

Given the SQL Database as the following: CREATE TABLE t1 (id integer, name text); INSERT INTO t1 VALUES (generate_series(1,10000), ‘Noname’);   And the NoSQL Database in MongoDB as the following: Collection t1 {     { id: 1, name: “Noname” },     { id: 2, name: “Noname” },     { id: 3, name: “Noname” },      …      { id: 10000, name: “Noname” }, } Create the shell commands in MongoDB that are equivalent as the following SQL Command:   SELECT name FROM t1 WHERE id>1000; For example: SQL Command                                  MongoDB Shell Command SELECT * FROM t1;                          db.t1.find( ); or db.t1.find({ });

                 Which transaction(s) need to rollback?                 (1 Point)         Which transaction(s) have to be killed?                 (1 Point)         Which transaction(s) can execute completely?     (1 Point)

Using Figure 15.7 Merge join with the following relation R and S: How many rounds for the outer while loop? _______

             Transaction A can commit on this schedule? (True/False) 

              Deadlock occurred in this schedule? (True/False) 

Given transaction T1 deletes index 0030. When T1 reached to the leaf node, it is safe? (True/False)