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

A B-tree used as an index for a large database table has four levels including the root node. If a new key is inserted in this index, then maximum number of nodes that could be newly created in the process is

Solution

In worst case, insertion causes splitting at every level.


There are 4 levels, so 4 new nodes may be created due to splitting.


If the root also splits, one extra new root node is created.


Maximum newly created nodes:


$4 + 1 = 5$

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

Nearest first
1
Match List I with List II LIST ILIST II   A. Physical layer I. Transforming the raw bits in the for…
Topic: UGC NET Computer Science June 2023 (Paper II)
2
Let $R(A, B, C, D, E)$ be a relational schema with following functional dependencies:$C \to F,\ E \to A,\ EC \to D,\ A …
Topic: UGC NET Computer Science June 2023 (Paper II)
3
Consider the following statements:S1: LRU page replacement algorithm suffers from the Belady's anomalyS2: Shortest rema…
Topic: UGC NET Computer Science June 2023 (Paper II)
4
Which is not a basic approach to the problem of conflict resolution in a production system?
Topic: UGC NET Computer Science June 2023 (Paper II)
5
Consider the following statements:A. A database design is in BCNF if each member of the set of relation schemas that co…
Topic: UGC NET Computer Science June 2023 (Paper II)
6
Consider a popular sports news site. At a given moment, 20,000 concurrent users submit a request, a transaction T, once…
Topic: UGC NET Computer Science June 2023 (Paper II)
7
A TCP server application is programmed to listen on port P on host S. A TCP client is connected to the TCP server over …
Topic: UGC NET Computer Science June 2023 (Paper II)
8
Which of the following is used to determine the cost performance index?
Topic: UGC NET Computer Science June 2023 (Paper II)
9
A three dimensional array in C++ is declared as int A [a] [b] [c]. Consider that array elements are stored in row major…
Topic: UGC NET Computer Science June 2023 (Paper II)
10
Which of the following transforms in 2 dimension is used to resize a 2-dimensional object?
Topic: UGC NET Computer Science June 2023 (Paper II)

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

Ascending by ID
1
Suppose a circular queue of capacity $(n - 1)$ elements is implemented with an array of $n$ elements. Assume that the i…
Topic: UGC NET Computer Science June 2023 (Paper II)
2
Match List I with List II LIST ILIST II  A. Scenario testing I. To verify the I/O behavior of text …
Topic: UGC NET Computer Science June 2023 (Paper II)
3
Given below are two statements:Let $f(n)$ and $g(n)$ be asymptotically positive functions. The following conjectures ar…
Topic: UGC NET Computer Science June 2023 (Paper II)
4
Consider the rectangle with vertices $(0,0)$, $(0,2)$, $(3,0)$, $(3,2)$. There is scaling of 2 towards x-axis and 3 tow…
Topic: UGC NET Computer Science June 2023 (Paper II)
5
What is the $(4+4)$ bit binary fixed point equivalent of $-(3.72)_{10}$?
Topic: UGC NET Computer Science June 2023 (Paper II)
6
Consider following statements:A. A context free language is generated by LR(0) grammar if and only if it is accepted by…
Topic: UGC NET Computer Science June 2023 (Paper II)
7
Match List I with List II LIST ILIST II  A. PERT I. Used for non repetitive jobs B. Optimistic…
Topic: UGC NET Computer Science June 2023 (Paper II)
8
Match List I with List II LIST ILIST II A. Bezier curves I. 3 dim objects that have translation rotational sy…
Topic: UGC NET Computer Science June 2023 (Paper II)
9
Given below are two statements:Statement I: If f and g are two functions and f = O(g) but g ≠ o(f), we say that the gro…
Topic: UGC NET Computer Science June 2023 (Paper II)
10
What is the output of following code?main(){static float a[] = {13.24, 1.5, 4.5, 5.4, 3.5}float *j, *k;j = a;k = a + 4j…
Topic: UGC NET Computer Science June 2023 (Paper II)
Ask Your Question or Put Your Review.

loading...