The following table has two attributes Employee_id and Manager_id, where Employee_id is a primary key and Manager_id is a foreign key referencing Employee_id with on-delete cascade:
Employee_id
Manager_id
20
40
25
40
30
35
35
20
40
45
45
25
On deleting the tuple $(20,40)$, the set of other tuples that must be deleted to maintain the referential integrity of the table is:
| Employee_id | Manager_id |
|---|---|
| 20 | 40 |
| 25 | 40 |
| 30 | 35 |
| 35 | 20 |
| 40 | 45 |
| 45 | 25 |
Previous 10 Questions — UGC NET Computer Science June 2019 (Paper II)
Nearest first
1
2
3
4
5
6
7
8
9
10
Which of the following features is supported in the relational database model?
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 statements are DML statements?
$(a)$ Update $[tablename]$ Set $[columnname]=VALUE$
$(b)$ Delete …
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 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 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)
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)
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)
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)
Next 10 Questions — UGC NET Computer Science June 2019 (Paper II)
Ascending by ID
1
2
3
4
5
6
7
8
9
10
$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)
Match List-I with List-II:
List-I
List-II
(a) Disk
…
Topic: UGC NET Computer Science June 2019 (Paper II)
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)
Consider that a process has been allocated $3$ frames and has a sequence of page referencing as $1,2,1,3,7,4,5,6,3,1$. …
Topic: UGC NET Computer Science June 2019 (Paper II)
Consider three CPU intensive processes, which require $10,20$ and $30$ units of time and arrive at times $0,2$ and $6$ …
Topic: UGC NET Computer Science June 2019 (Paper II)
At a particular time of computation, the value of a counting semaphore is $7$. Then $20$ $P$ wait operations and $15$ $…
Topic: UGC NET Computer Science June 2019 (Paper II)
The minimum number of page frames that must be allocated to a running process in a virtual memory environment is determ…
Topic: UGC NET Computer Science June 2019 (Paper II)
A computer has six tape drives with $n$ processes competing for them. Each process may need two drives. What is the max…
Topic: UGC NET Computer Science June 2019 (Paper II)
A processor can support a maximum memory of $4GB$ where memory is word addressable and a word is $2$ bytes. What will b…
Topic: UGC NET Computer Science June 2019 (Paper II)
