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

In relational databases, if relation $R$ is in $BCNF$, then which of the following is true about relation $R$?

Solution

If a relation is in $BCNF$, then it is also in $3NF$.

Also, if a relation is in $3NF$, then it is already in $2NF$.

So, if $R$ is in $BCNF$, then $R$ must be in $2NF$ and $3NF$.

← Previous Next →

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

Nearest first
1
With respect to relational algebra, which of the following operations are included for mathematical set theory? $(a)$ J…
Topic: UGC NET Computer Science June 2019 (Paper II)
 2
Which of the following has same expressive power with regard to relational query language? $(a)$ Relational algebra and…
Topic: UGC NET Computer Science June 2019 (Paper II)
 3
Using the Phong reflectance model, the strength of the specular highlight is determined by the angle between:
Topic: UGC NET Computer Science June 2019 (Paper II)
 4
In the context of $3D$ computer graphics, which of the following statements is/are true? $P$: Orthographic transformati…
Topic: UGC NET Computer Science June 2019 (Paper II)
 5
Consider the following statements regarding $2D$ transforms in computer graphics: $S1$: [ 1 0 …
Topic: UGC NET Computer Science June 2019 (Paper II)
 6
Consider a raster system with resolution $640$ by $480$. What size is frame buffer in bytes for this system to store $1…
Topic: UGC NET Computer Science June 2019 (Paper II)
 7
Which of the following statements is/are true?$P$: An XML document with correct syntax as specified by W3C is called "W…
Topic: UGC NET Computer Science June 2019 (Paper II)
 8
Which of the following statements is/are true?$P$: In a scripting language like JavaScript, types are typically associa…
Topic: UGC NET Computer Science June 2019 (Paper II)
 9
Consider the following C++ function $f()$: unsigned int f(unsigned int n) { unsigned int b = 0; while (n) { b = b + (n …
Topic: UGC NET Computer Science June 2019 (Paper II)
 10
What is the output of the following JAVA program? public class Good { private int m; public Good(int m) { this.m = m; }…
Topic: UGC NET Computer Science June 2019 (Paper II)

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

Ascending by ID
1
Which of the following key constraints is required for functioning of foreign key in the context of relational database…
Topic: UGC NET Computer Science June 2019 (Paper II)
 2
In relational database management, which of the following is/are property/properties of candidate key?$P$: Uniqueness …
Topic: UGC NET Computer Science June 2019 (Paper II)
 3
Which of the following statements are DML statements? $(a)$ Update $[tablename]$ Set $[columnname]=VALUE$ $(b)$ Delete …
Topic: UGC NET Computer Science June 2019 (Paper II)
 4
Hadoop, a big data tool, works with a number of related tools. Choose from the following, the common tools included int…
Topic: UGC NET Computer Science June 2019 (Paper II)
 5
Which of the following features is supported in the relational database model?
Topic: UGC NET Computer Science June 2019 (Paper II)
 6
The following table has two attributes Employee_id and Manager_id, where Employee_id is a primary key and Manager_id is…
Topic: UGC NET Computer Science June 2019 (Paper II)
 7
$K$-mean clustering algorithm has clustered the given $8$ observations into $3$ clusters after $1^{st}$ iteration as fo…
Topic: UGC NET Computer Science June 2019 (Paper II)
 8
Consider a disk system with $100$ cylinders. The requests to access the cylinders occur in the following sequence: $4,3…
Topic: UGC NET Computer Science June 2019 (Paper II)
 9
Match List-I with List-II: List-I List-II (a) Disk …
Topic: UGC NET Computer Science June 2019 (Paper II)
 10
Which of the following are NOT shared by the threads of the same process? $(a)$ Stack $(b)$ Registers $(c)$ Address spa…
Topic: UGC NET Computer Science June 2019 (Paper II)
Ask Your Question or Put Your Review.

loading...