Aspire Faculty ID #18613 · Topic: UGC NET Computer Science Dec 2022 Shift II (Paper II) · Just now
UGC NET Computer Science Dec 2022 Shift II (Paper II)

Consider the two relations below. The primary keys are underlined. Identify all possible foreign key(s) from the options based only on the two relations.

$EMP(eid, ename, did)$

$DEPT(did, dname)$

Solution

In $DEPT$, $did$ is the primary key.

In $EMP$, $did$ can refer to $DEPT(did)$.

So, $EMP.did$ is a foreign key.

Previous 10 Questions — UGC NET Computer Science Dec 2022 Shift II (Paper II)

Nearest first

Next 10 Questions — UGC NET Computer Science Dec 2022 Shift II (Paper II)

Ascending by ID
1
Which of the following statements is correct, according to the following instance of the relational schema R(X, Y, Z)?&…
Topic: UGC NET Computer Science Dec 2022 Shift II (Paper II)
2
In Linux Operating System, when __________ is invoked, it is passed a set of flags that determine how much sharing is t…
Topic: UGC NET Computer Science Dec 2022 Shift II (Paper II)
3
The main function of the microkernel is to provide a communication facility between the __________ program and the vari…
Topic: UGC NET Computer Science Dec 2022 Shift II (Paper II)
4
Consider an operating system capable of loading and executing a single sequential user process at a time. The disk head…
Topic: UGC NET Computer Science Dec 2022 Shift II (Paper II)
5
For the following set of processes scheduled using FCFS policy, determine the average waiting time. Assume that the pro…
Topic: UGC NET Computer Science Dec 2022 Shift II (Paper II)
6
Which of the following is not a Non-functional requirement?
Topic: UGC NET Computer Science Dec 2022 Shift II (Paper II)
7
Topic: Software Engineering → Software Cost Estimation COCOMO stands for-
Topic: UGC NET Computer Science Dec 2022 Shift II (Paper II)
8
Modifying the software to match changes in the ever-changing environment is called as
Topic: UGC NET Computer Science Dec 2022 Shift II (Paper II)
9
For a function of two variables, boundary value analysis yields,
Topic: UGC NET Computer Science Dec 2022 Shift II (Paper II)
10
How many different binary trees are possible with $n$ nodes?
Topic: UGC NET Computer Science Dec 2022 Shift II (Paper II)
Ask Your Question or Put Your Review.

loading...