Consider the following statements:
A. A database design is in BCNF if each member of the set of relation schemas that constitutes the design is in BCNF
B. A BCNF schema can have transitive dependency
C. It is always possible to obtain a 3NF design without sacrificing a lossless join
D. There are multivalued dependencies in 4NF
Previous 10 Questions — UGC NET Computer Science June 2023 (Paper II)
Nearest first
1
2
3
4
5
6
7
8
9
10
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)
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)
Which of the following is used to determine the cost performance index?
Topic: UGC NET Computer Science June 2023 (Paper II)
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)
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)
A processor chip is used for application in which 30% of execution time is spent on floating point addition. For the ne…
Topic: UGC NET Computer Science June 2023 (Paper II)
At a particular time of computation, the value of a counting semaphore is 7. Then 20 P operations and x V operations we…
Topic: UGC NET Computer Science June 2023 (Paper II)
Given below are two statements: one is labelled as Assertion A and the other is labelled as Reason R.A virtual memory s…
Topic: UGC NET Computer Science June 2023 (Paper II)
The total cost of retrieving records in sorted order using an unclustered B+ tree is(P – Average number of records per …
Topic: UGC NET Computer Science June 2023 (Paper II)
If A = {4n + 2 | n is a natural number} and B = {3n | n is a natural number}. Which of the following is correct for A ∩…
Topic: UGC NET Computer Science June 2023 (Paper II)
Next 10 Questions — UGC NET Computer Science June 2023 (Paper II)
Ascending by ID
1
2
3
4
5
6
7
8
9
10
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)
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)
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)
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)
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 …
Topic: UGC NET Computer Science June 2023 (Paper II)
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)
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)
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)
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)
What is the $(4+4)$ bit binary fixed point equivalent of $-(3.72)_{10}$?
Topic: UGC NET Computer Science June 2023 (Paper II)
