Consider following two statements:
Statement I: Relational database schema represents the logical design of the database.
Statement II: Current snapshot of a relation only provides the degree of the relation.
In the context to the above statements, choose the correct option 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
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)
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 the sentence below.There is a country that borders both India and Pakistan.Which of the following logical expr…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
Which among the following statement(s) is(are) FALSE?A. Greedy best-first search is not optimal but is often efficient.…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
Consider the given tree below. Calculate the
value at the root of the tree using alpha‐beta
pruning algorithm.
Topic: UGC NET Computer Science Nov 2021 (Paper II)
Given below are two statementsStatement I: Breadth-First Search is optimal when all the step costs are equal whereas un…
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
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)
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)
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)
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)
Given a relation scheme $R(x,y,z,w)$ with functional dependencies set$F=\{x\to y,\ z\to w\}$.All attributes take single…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
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)
