Register

NIELIT 2017 OCT Scientific Assistant A (IT) - Section C: 6
closed

• closed by
757 views
1 votes
1 votes
closed as a duplicate of: NIELIT 2017 OCT Scientific Assistant A (CS) - Section B: 13

Given relations $R(w,x)$ and $S(y,z),$ the result of  SELECT DISTINCT $w,x$ from $R,S$

  1. $R$ has no duplicates and $S$ is non-empty
  2. $R$ and $S$ have no duplicates
  3. $S$ has no duplicates and $R$ is non-empty
  4. $R$ and $S$ has the same number of tuples
• closed by
User Avatar
Voting & Accepting an answer helps improve the community
Answer:
← PreviousNext →
← Previous in categoryNext in category →

Related questions

1.0k
views
2 answers
1 votes
admin asked Apr 1, 2020
1,002 views
NIELIT 2017 OCT Scientific Assistant A (IT) - Section C: 5
Assume transaction $A$ holds a shared lock $R.$ If transaction $B$ also requests for a shared lock on $R.$ It willresult in deadlock situationimmediately be grantedimmediately be rejectedbe granted as soon as it is released by $A$
User Avatar
883
views
2 answers
2 votes
admin asked Apr 1, 2020
883 views
NIELIT 2017 OCT Scientific Assistant A (IT) - Section B: 16
For a database relation $R(a,b,c,d)$ where the domains of $a,b,c$ and $d$ include only atomic values, only the following functional ... normal formSecond normal form but not in third normal formThird normal formNone of the above
User Avatar
2.1k
views
2 answers
4 votes
admin asked Apr 1, 2020
2,058 views
NIELIT 2017 OCT Scientific Assistant A (IT) - Section B: 27
Which of the following desired features are beyond the capability of relational algebra?Aggregate ComputationMultiplicationFinding transitive closureAll of the above
User Avatar
741
views
1 answers
0 votes
admin asked Apr 1, 2020
741 views
NIELIT 2017 OCT Scientific Assistant A (IT) - Section B: 31
When transaction $Ti$ requests a data item currently held by $Tj,Ti$ is allowed to wait only if it has a time stamp smaller than that of $Tj$ (that ... Tj). Otherwise, $Ti$ is rolled back (dies). This isWait-dieWait-woundWound-waitWait
User Avatar
Link Copied!