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

With respect to relational algebra, which of the following operations are included for mathematical set theory?

$(a)$ Join
$(b)$ Intersection
$(c)$ Cartesian product
$(d)$ Project

Solution

In relational algebra, some operations are based on mathematical set theory.

Intersection is a set operation.

Cartesian product is also a set operation.

Join and project are relational algebra operations, but they are not basic mathematical set theory operations.

So, the operations included for mathematical set theory are:

$(b)$ Intersection

$(c)$ Cartesian product

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

Nearest first
1
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)
2
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)
3
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)
4
Consider the following statements regarding $2D$ transforms in computer graphics: $S1$: [ 1 0 …
Topic: UGC NET Computer Science June 2019 (Paper II)
5
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)
6
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)
7
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)
8
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)
9
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)
10
Consider the following C-code fragment running on a $32$-bit x86 machine:typedef struct { union { unsigned char a; unsi…
Topic: UGC NET Computer Science June 2019 (Paper II)

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

Ascending by ID
1
In relational databases, if relation $R$ is in $BCNF$, then which of the following is true about relation $R$?
Topic: UGC NET Computer Science June 2019 (Paper II)
2
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)
3
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)
4
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)
5
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)
6
Which of the following features is supported in the relational database model?
Topic: UGC NET Computer Science June 2019 (Paper II)
7
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)
8
$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)
9
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)
10
Match List-I with List-II: List-I List-II (a) Disk …
Topic: UGC NET Computer Science June 2019 (Paper II)
Ask Your Question or Put Your Review.

loading...