Which of the following has same expressive power with regard to relational query language?
$(a)$ Relational algebra and domain relational calculus
$(b)$ Relational algebra and tuple relational calculus
$(c)$ Relational algebra and domain relational calculus restricted to safe expression
$(d)$ Relational algebra and tuple relational calculus restricted to safe expression
Previous 10 Questions — UGC NET Computer Science June 2019 (Paper II)
Nearest first
1
2
3
4
5
6
7
8
9
10
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)
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)
Consider the following statements regarding $2D$ transforms in computer graphics:
$S1$:
[
1
0
…
Topic: UGC NET Computer Science June 2019 (Paper II)
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)
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)
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)
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)
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)
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)
Consider the following pseudo-code fragment in which an invariant for the loop is $m \times x^k=p^n$ and $k\ge 0$.
Pre-…
Topic: UGC NET Computer Science June 2019 (Paper II)
Next 10 Questions — UGC NET Computer Science June 2019 (Paper II)
Ascending by ID
1
2
3
4
5
6
7
8
9
10
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)
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)
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)
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)
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)
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)
Which of the following features is supported in the relational database model?
Topic: UGC NET Computer Science June 2019 (Paper II)
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)
$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)
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)
