5 years ago in UGC CS - December 2012

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

[A] Select p.posting-No, p.posting-<br>No<br>from position p<br>where p.skill = p.skill<br>and p.posting-No < p.posting-No<br>
[B] Select p1.posting-No, p2.posting-<br>No<br>from position p1, position p2<br>where p1.skill = p2.skill
[C] Select p1.posting-No, p2.posting-<br>No<br>from position p1, position p2<br>where p1.skill = p2.skill<br>and p1.posting-No < p2.posting-<br>No
[D] Select p1.posting-No, p2.posting-<br>No<br>from position p1, position p2<br>where p1.skill = p2.skill<br>and p1.posting-No = p2.posting-<br>No
Loading...
Next Question

Overall Stats

Attempted 9
Correct 3
Incorrect 3
Viewed 3

Answers

Guest
Guest
suresh 1547
suresh 1547 - 2 years ago

suresh 1547 from India is saying Select p1.posting-No, p2.posting-
No
from position p1, position p2
where p1.skill = p2.skill
and p1.posting-No < p2.posting-
No
is correct answer

aarti jadhav
aarti jadhav - 2 years ago

aarti jadhav from Pune, India is saying Select p1.posting-No, p2.posting-
No
from position p1, position p2
where p1.skill = p2.skill
and p1.posting-No = p2.posting-
No
is correct answer

Nazia Sayed
Nazia Sayed - 2 years ago

Nazia Sayed from Mumbai, India is saying Select p1.posting-No, p2.posting-
No
from position p1, position p2
where p1.skill = p2.skill
and p1.posting-No < p2.posting-
No
is correct answer

Sayed badruzama
Sayed badruzama - 2 years ago

Sayed badruzama from Mumbai, India is saying Select p1.posting-No, p2.posting-
No
from position p1, position p2
where p1.skill = p2.skill
is correct answer

Tilkamanjhi Sarai
Tilkamanjhi Sarai - 2 years ago

Tilkamanjhi Sarai from Pune, India is saying Select p1.posting-No, p2.posting-
No
from position p1, position p2
where p1.skill = p2.skill
and p1.posting-No = p2.posting-
No
is correct answer

Related Questions

Which of the following is true while converting CFG to LL(I) grammar ?

  • [A] Remove left recursion alone
  • [B] Factoring grammar alone
  • [C] Both of the above
  • [D] None of the above

Component Level Design is concerned with

  • [A] Flow Oriented Analysis
  • [B] Class Based Analysis
  • [C] Both of the above
  • [D] None of the above