Aspire Faculty ID #18404 · Topic: UGC NET Computer Science June 2023 (Paper II) · Just now
UGC NET Computer Science June 2023 (Paper II)

Given below are two statements:

Which of the following concurrency control protocol ensures both conflict serializability and freedom from deadlock?

Statement I: Two phase locking

Statement II: Timestamp ordering

In the light of the above statements, choose the most appropriate answer from the options given below:

Solution

Two phase locking ensures conflict serializability, but it may cause deadlock. So, it does not ensure freedom from deadlock.

Timestamp ordering ensures conflict serializability and it is deadlock-free because transactions do not wait for locks.

So, Statement I is incorrect and Statement II is correct.

Previous 10 Questions — UGC NET Computer Science June 2023 (Paper II)

Nearest first

Next 10 Questions — UGC NET Computer Science June 2023 (Paper II)

Ascending by ID
1
The clipping process in computer graphics is used for
Topic: UGC NET Computer Science June 2023 (Paper II)
2
Given below are two statements: one is labelled as Assertion A and the other is labelled as Reason R.Assertion A: I/O p…
Topic: UGC NET Computer Science June 2023 (Paper II)
3
Let R = {x : x ∈ N, x is multiple of 3 and x ≤ 100} and S = {x : x ∈ N, x is multiple of 5 and x < 100}. What is the…
Topic: UGC NET Computer Science June 2023 (Paper II)
4
Given below are two statements:Statement I: Fuzzifier is a part of a fuzzy systemStatement II: Inference engine is a pa…
Topic: UGC NET Computer Science June 2023 (Paper II)
5
What will be the output of the following code?include <stdio.h>int main() {int a, b, c;a = 0x10; b = 010;c = a + …
Topic: UGC NET Computer Science June 2023 (Paper II)
6
What is the output of following code?main()struct s1{char *z;int i;struct s1 *p;}static struct s1 a[] = {{"Nagpur", 1, …
Topic: UGC NET Computer Science June 2023 (Paper II)
7
Match List I with List II List I List II A. The running time of straight forward recursive method to com…
Topic: UGC NET Computer Science June 2023 (Paper II)
8
Consider a disk system with cylinders. The request to access the cylinders occurs in the following sequence:4, 34, 10, …
Topic: UGC NET Computer Science June 2023 (Paper II)
9
Find the sum of all four digit numbers formed using the digits 1, 2, 4 and 6.
Topic: UGC NET Computer Science June 2023 (Paper II)
10
How will you free the memory allocated by the following program?#include <stdio.h>#define MAXROW 3#define MAXCOL …
Topic: UGC NET Computer Science June 2023 (Paper II)
Ask Your Question or Put Your Review.

loading...