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

## Overall Stats

Attempted 9
Correct 3
Incorrect 3
Viewed 3

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

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

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

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

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

## 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

### If a packet arrive with an M-bit value is '1' and a fragmentation offset value is '0', then it is ____________ fragment.

• [A] First
• [B] Middle
• [C] Last
• [D] All of the above

### AES is a round cipher based on the Rijndal Algorithm that uses a 128-bit block of data. AES has three different configurations. ______ rounds with a key size of 128 bits, ______ rounds with a key size of 192 bits and ______ rounds with a key size of 256 bits.

• [A] 5, 7, 15
• [B] 10, 12, 14
• [C] 5, 6, 7
• [D] 20, 12, 14

### In which addressing mode, the effective address of the operand is generated by adding a constant value to the contents of register ?

• [A] Absolute
• [B] Indirect
• [C] Immediate
• [D] Index