logo

Crowdly

Browser

Add to Chrome

Questions Bank (1573663 total)

Consider two transactions T1 and T2 with timestamps TS(T1)=5 and TS(T2)=10 and the following schedule:

   T1.                |   T2

--------------+-------------

 write(A)          | 

                         | read(A)

  

Under the basic timestamp ordering protocol, what happens?

 

❌
❌
✅
❌
View this question

The following question is about visualisation.

The data shows calories of a selection of chocolate bars, 100g equivalents. Calories mapped to the vertical axis. If you are wanting the reader to compare the inter quantile range of calories of milk and dark chocolates, which part of the plot do you need to observe?

Image failed to load

100%
0%
0%
0%
View this question

Consider the following transaction schedule. Indicate if it is conflict-serializable or not:

 

|   T1          |   T2

+---------+--------

| read(A)   |  

|                 | read(B)

| read(B).  |  

|                 | write(B)

| write(A)  |  

| write(B)  |  

|                 | read(A)

|                 | write(A)

| commit   |  

|                 | commit

✅
❌
View this question

Consider this schedule under basic 2PL where locks may be released as soon as the write is done (so uncommitted writes can be seen by others)

|   T1                  |   T2

+--------------+-------------

| lock_X(A)       | 

| write(A)          | 

| unlock(A)       | 

|                        | lock_S(A)

|                        | read(A)

| abort              | 

|                        | 

Under this protocol, does the schedule exhibit

✅
❌
❌
❌
View this question

Under basic two‐phase locking, once a transaction releases any lock, it cannot acquire any new locks.

0%
0%
View this question

Deadlock avoidance using wait‐die and wound‐wait schemes is typically integrated with which protocol?

❌
✅
❌
❌
View this question

In a timestamp‐ordering protocol, a read operation may ever cause the reading transaction to abort if the data item was last written by a younger transaction.

0%
0%
View this question

Consider the following schedule under basic 2PL

|   T1                  |   T2

+--------------+-------------

| lock_S(A)        | 

|                         | lock_S(B)

| lock_X(B)       | 

|                         | lock_X(A)

Under this 2PL protocol, does the schedule exhibit

❌
✅
❌
❌
View this question
The term “human capital” refers to the number of workers.
0%
0%
View this question
Leisure time sacrificed to study Economics is an example of an opportunity cost.
0%
0%
View this question