Register

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

• closed by
725 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

4 votes
4 votes
2 answers
3
admin asked Apr 1, 2020
1,957 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 Computation Multiplication Finding transitive closure All of the above
Which of the following desired features are beyond the capability of relational algebra?Aggregate ComputationMultiplicationFinding transitive closureAll of the above
User Avatar
0 votes
0 votes
1 answer
4
admin asked Apr 1, 2020
719 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 is $Ti$ is order than Tj). Otherwise, $Ti$ is rolled back (dies). This is Wait-die Wait-wound Wound-wait Wait
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 is $Ti$ is order than ...
User Avatar
Link Copied!