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

The techniques used to handle the phantom problem are

A. Time stamping
B. Index locking
C. Predicate locking
D. Execution indexing

Solution

The phantom problem occurs in database concurrency control when a transaction re-executes a query and finds new rows inserted by another transaction.

Techniques used to prevent phantom problem:

• Index locking – locks index ranges to prevent insertion of new tuples in the range.
• Predicate locking – locks records satisfying a condition.

Time stamping and execution indexing are not specifically used to solve phantom problem.

Therefore, correct options are B and C.

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

Nearest first

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

Ascending by ID
1
Which of the following are type of interface in an ATM network ?A. user-to-userB. user-to-networkC. network-to-networkD…
Topic: UGC NET Computer Science June 2024 (Paper II)
2
Arrange the following in correct order, so that they can follow a proper run time environment :A. Programming statement…
Topic: UGC NET Computer Science June 2024 (Paper II)
3
Match List-I with List-II.$f(n) = a f(n/b) + g(n)$ is a divide-and-conquer recurrence relation for the Listed-I algorit…
Topic: UGC NET Computer Science June 2024 (Paper II)
4
Match List-I with List-II : List-I List-II A. Channelization protocol I. ALOHA B. Bit-oriented…
Topic: UGC NET Computer Science June 2024 (Paper II)
5
An IPv4 packet has arrived with the first few hexadecimal digits as shown below. How many hops can this packet travel b…
Topic: UGC NET Computer Science June 2024 (Paper II)
6
Which of the following control problem does not exist, when processes unaware of each other during interaction?
Topic: UGC NET Computer Science June 2024 (Paper II)
7
Which of the following is the Markup language?A. HTMLB. XMLC. DHTMLD. LMLE. PML
Topic: UGC NET Computer Science June 2024 (Paper II)
8
Arrange the following prefix expressions based on their values in increasing order:A. + - * 2 / 8 4 3 2B. ↑ - * 3 3 * 4…
Topic: UGC NET Computer Science June 2024 (Paper II)
9
Match List-I with List-II: List-I (Line coding scheme) List-II (Bandwidth – average) A. NRZ-L I. B …
Topic: UGC NET Computer Science June 2024 (Paper II)
10
The instructionsADD R₁, A, B ADD R₂, C, D MUL X, R₁, R₂evaluate the expression $X = (A + B)(C + D)$ in which of the fol…
Topic: UGC NET Computer Science June 2024 (Paper II)
Ask Your Question or Put Your Review.

loading...