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

Which of the following features is supported in the relational database model?

Solution

In the relational database model, data is stored in the form of relations or tables.

Complex data-types are not directly supported in the basic relational model because values are generally atomic.

Multivalued attributes are also not directly stored in a single attribute; they are usually represented by creating another relation.

Generalization relationships are mainly part of the ER model or enhanced ER model.

But associations between entities can be represented using relations, primary keys and foreign keys. Multiplicity like one-to-one or one-to-many can also be represented using constraints.

Therefore, the supported feature is associations with multiplicities.

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

Nearest first
1
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)
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
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 key constraints is required for functioning of foreign key in the context of relational database…
Topic: UGC NET Computer Science June 2019 (Paper II)
5
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)
6
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)
7
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)
8
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)
9
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)
10
Consider the following statements regarding $2D$ transforms in computer graphics: $S1$: [ 1 0 …
Topic: UGC NET Computer Science June 2019 (Paper II)

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

Ascending by ID
1
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)
2
$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)
3
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)
4
Match List-I with List-II: List-I List-II (a) Disk …
Topic: UGC NET Computer Science June 2019 (Paper II)
5
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)
6
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)
7
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)
8
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)
9
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)
10
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)
Ask Your Question or Put Your Review.

loading...