Aspire Faculty ID #17520 · Topic: UGC NET Computer Science August 2024 (Paper II) · Just now
UGC NET Computer Science August 2024 (Paper II)

Consider the transactions $T_1, T_2, T_3$ and the schedules $S_1$ and $S_2$ given below.

$T_1 : r_1(x); r_1(z); w_1(z)$
$T_2 : r_2(y); r_2(z); w_2(z)$
$T_3 : r_3(y); r_3(x); w_3(y)$

$S_1$ :
$r_1(x); r_3(y); r_3(x); r_2(y); r_2(z); w_3(y); w_3(z); r_1(z); w_1(x); w_1(z)$

$S_2$ :
$r_1(x); r_3(y); r_2(y); r_3(x); r_1(z); r_2(z); w_3(y); w_1(x); w_2(z); w_1(z)$

Which one of the following statements about the schedules is TRUE ?

Solution

To check conflict serializability we build precedence graph.

For $S_1$

Conflicts:

$T_1 \rightarrow T_3$
$T_3 \rightarrow T_2$
$T_2 \rightarrow T_1$

Cycle exists:

$T_1 \rightarrow T_3 \rightarrow T_2 \rightarrow T_1$

Therefore

$S_1$ not conflict-serializable

For $S_2$

Conflicts:

$T_3 \rightarrow T_1$
$T_2 \rightarrow T_1$
$T_3 \rightarrow T_2$

Graph has no cycle

Serializable order:

$T_3 \rightarrow T_2 \rightarrow T_1$

Thus

$S_2$ is conflict-serializable


Previous 10 Questions — UGC NET Computer Science August 2024 (Paper II)

Nearest first
1
Match List - I with List - II. List - I (software design principles) List - II (Definitions) (A) Cohesio…
Topic: UGC NET Computer Science August 2024 (Paper II)
2
Given a project that uses the COCOMO model with an estimated effort of 2000 person-months and a productivity rate of 5 …
Topic: UGC NET Computer Science August 2024 (Paper II)
3
What is SQL primarily used for in the context of relational databases?
Topic: UGC NET Computer Science August 2024 (Paper II)
4
What will be the output of the following C code?#include<stdio.h>void main(){    int arr[5] = {10, 20, …
Topic: UGC NET Computer Science August 2024 (Paper II)
5
Match List - I with List - II. List - I (IP Address)List - II (Class)   (A) 10.20.30.40 (I) Class E…
Topic: UGC NET Computer Science August 2024 (Paper II)
6
Two computers A and B are configured as follows :A has IP address 203.197.2.53 and subnet mask 255.255.128.0B has IP ad…
Topic: UGC NET Computer Science August 2024 (Paper II)
7
Consider the Grammar : $T \rightarrow Qx$ $Q \rightarrow RS$ $R \rightarrow y \mid \varepsilon$ $S \rightarrow z \mid \…
Topic: UGC NET Computer Science August 2024 (Paper II)
8
For all real numbers $x$, there exists a real number $y$ such that $x$ is less than $y$.(A) $L_1 = { w \in {0,1}^* \mid…
Topic: UGC NET Computer Science August 2024 (Paper II)
9
Translate $\forall x \exists y (x < y)$ in English. Consider domain as a real number for both the variables.
Topic: UGC NET Computer Science August 2024 (Paper II)
10
Consider the following C program :#include<stdio.h>int main(){    int x[]={2,4,6,8,10};    in…
Topic: UGC NET Computer Science August 2024 (Paper II)

Next 10 Questions — UGC NET Computer Science August 2024 (Paper II)

Ascending by ID
1
Consider the following statement regarding special purpose registers. (A) Program Counter (PC) keeps the track of next …
Topic: UGC NET Computer Science August 2024 (Paper II)
2
Which of the following are Agile Process Models ? (A) Extreme Programming (XP) (B) Waterfall (C) Scrum (D) Spiral (E) I…
Topic: UGC NET Computer Science August 2024 (Paper II)
3
Arrange the following phases of database design in the correct order :(A) Physical Design(B) Conceptual Design(C) Logic…
Topic: UGC NET Computer Science August 2024 (Paper II)
4
Which of the following statements are TRUE about mutual exclusion in concurrent programming ? (A) Mutual exclusion ensu…
Topic: UGC NET Computer Science August 2024 (Paper II)
5
Consider a relation schema $R = (U, V, W, X, Y, Z)$, on which the following functional dependencies hold:${U \rightarro…
Topic: UGC NET Computer Science August 2024 (Paper II)
6
Host A (on TCP/IPv4 Networks) send an IP Datagram D to host B (also on TCP/IPv4 network). Assume that no error occurred…
Topic: UGC NET Computer Science August 2024 (Paper II)
7
Consider a CSMA/CD network that transmits data at the rate of 100 Mbps over a 1 kilometre cable with no repeater. If th…
Topic: UGC NET Computer Science August 2024 (Paper II)
8
#include<iostream.h>using namespace std;void swap(int &x, int &y){    int temp = x;  &nbsp…
Topic: UGC NET Computer Science August 2024 (Paper II)
9
Consider the three-way handshaking process followed during TCP connection establishment between two hosts A and B. Let …
Topic: UGC NET Computer Science August 2024 (Paper II)
10
Arrange the following steps of file handling in C in the correct order :(A) Close the file(B) Read from or write to the…
Topic: UGC NET Computer Science August 2024 (Paper II)
Ask Your Question or Put Your Review.

loading...