retagged by
2,877 views
2 votes
2 votes

Given a Relation POSITION (Posting-No, Skill), then the query to retrieve all distinct pairs of posting-nos. requiring skill is

  1. Select p.posting-No, p.posting-No from position p where p.skill=p.skill and p.posting-No < p.posting-No
  2. Select p$_1$.posting-No, p$_2$.posting-No from position p$_1$, position p$_2$  where p$_1$.skill=p$_2$.skill
  3. Select p$_1$.posting-No, p$_2$.posting-No from position p$_1$, position p$_2$  where p$_1$.skill=p$_2$.skill and p$_1$.posting.No < p$_2$.posting-No
  4. Select p$_1$.posting-No, p$_2$.posting-No from position p$_1$, position p$_2$  where p$_1$.skill=p$_2$.skill and p$_1$.posting.No = p$_2$.posting-No
retagged by

3 Answers

0 votes
0 votes
answer is C

we need to join position with itself based on skill

then it is given distinct pairs so we need to consider only p1.position-no < p2.position-no
Answer:

Related questions

0 votes
0 votes
1 answer
1
1 votes
1 votes
1 answer
2
im.raj asked Jun 16, 2016
5,680 views
Which of the following is true?A relation in BCNF is always in 3NFA relation in 3NF is always in BCNFBCNF and 3NF are sameA relation in BCNF is not in 3NF
4 votes
4 votes
2 answers
3
go_editor asked Jul 11, 2016
4,400 views
The maximum number of keys stored in a B-tree of order $m$ and depth $d$ is$m^{d +1}-1$$\frac{m^{d+1}-1}{m-1}$$(m-1)(m^{d+1}-1)$$\frac{m^d-1}{m-1}$
1 votes
1 votes
1 answer
4
go_editor asked Jul 10, 2016
2,620 views
In DML, RECONNCT command cannot be used withOPTIONAL SetFIXED SetMANDATOR SetAll of the above