Aspire Faculty ID #19252 · Topic: UGC NET Computer Science June 2019 (Paper II) · Just now
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 databases?

Solution

A foreign key is used to create a relationship between two tables.

A foreign key in one table generally refers to the primary key of another table.

This ensures referential integrity between the two tables.

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

Nearest first
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
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)
3
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)
4
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)
5
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)
6
Consider the following statements regarding $2D$ transforms in computer graphics: $S1$: [ 1 0 …
Topic: UGC NET Computer Science June 2019 (Paper II)
7
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)
8
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)
9
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)
10
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)

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

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

loading...