Given a relation scheme $R(x,y,z,w)$ with functional dependencies set
$F=\{x\to y,\ z\to w\}$.
All attributes take single and atomic values only.
A. Relation $R$ is in First Normal Form
B. Relation $R$ is in Second Normal Form
C. Primary key of $R$ is $xz$
Choose the correct answer from the options given below:
Previous 10 Questions — UGC NET Computer Science Nov 2021 (Paper II)
Nearest first
1
2
3
4
5
6
7
8
9
10
Suppose a B tree is used for indexing a database file. Consider the following information:size of the search key field …
Topic: UGC NET Computer Science Nov 2021 (Paper II)
STUDENT(Rollno, Name, Courseno)COURSE(Courseno, Coursename, Capacity)where Rollno is the primary key of relation STUDEN…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
Given the following STUDENT-COURSE scheme:STUDENT(Rollno, Name, courseno)COURSE(courseno, coursename, capacity)where Ro…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
Given a fixed-length record file that is ordered on the key field. The file needs $B$ disk blocks to store $R$ number o…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
Consider following two statements:Statement I: Relational database schema represents the logical design of the database…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
Consider a domain consisting of three Boolean variables Toothache, Cavity, and Catch. The full joint distribution is a …
Topic: UGC NET Computer Science Nov 2021 (Paper II)
Consider a domain consisting of three Boolean variables Toothache, Cavity, and Catch. The full joint distribution is a …
Topic: UGC NET Computer Science Nov 2021 (Paper II)
Consider a domain consisting of three Boolean variables Toothache, Cavity, and Catch. The full joint distribution is a …
Topic: UGC NET Computer Science Nov 2021 (Paper II)
Consider a domain consisting of three Boolean variables Toothache, Cavity, and Catch. The full joint distribution is a …
Topic: UGC NET Computer Science Nov 2021 (Paper II)
Consider a domain consisting of three Boolean variables Toothache, Cavity, and Catch. The full joint distribution is a …
Topic: UGC NET Computer Science Nov 2021 (Paper II)
Next 10 Questions — UGC NET Computer Science Nov 2021 (Paper II)
Ascending by ID
1
2
3
4
5
6
7
8
9
10
A company is consuming parts in the manufacturing of other products. Each of the part is either manufactured within the…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
A transaction may be in one of the following states during its execution life cycle in concurrent execution envir…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
Which of the following is used to create a database schema?
Topic: UGC NET Computer Science Nov 2021 (Paper II)
Given memory access time as $p$ nanoseconds and additional $q$ nanoseconds for handling the page fault. What is the eff…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
In a file allocation system, the following allocation schemes are used:A. ContiguousB. IndexedC. Linked allocationWhich…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
Given below are three statements related to interrupt handling mechanism.A. Interrupt handler routine is not stored at …
Topic: UGC NET Computer Science Nov 2021 (Paper II)
Match List I with List IIList-IList-IIA. fork()I. sends a signal from one process to particular processB. exec()II. Ind…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
Consider the following 3 processes with the length of the CPU burst time given in milliseconds:ProcessArrival TimeBurst…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
Consider a machine with $16\ GB$ main memory and $32$-bits virtual address space, with page size as $4KB$. Frame size a…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
Consider a machine with $16\ GB$ main memory and $32$-bits virtual address space, with page size as $4KB$. Frame size a…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
