ER-Model
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 565 |
Given a Relation POSITION (Posting- No, Skill), then query to retrieve all distinct pairs of posting-nos. requiring skill is
| Select p.posting-No, p.posting No from position p where p.skill = p.skilland p.posting-No < p.posting-No | |
| Select p1.posting-No, p2.posting- No from position p1, position p2 where p1.skill = p2.skill | |
| Select p1.posting-No, p2posting-No from position p1, position p2 where p1.skill = p2.skill and p1.posting-No < p2.posting-No | |
| Select p1.posting-No, p2.posting- No from position p1, position p2 where p1.skill = p2.skill and p1.posting-No = p2.posting-No |
Question 565 Explanation:
Option (A) is incorrect because No self join is not possible without aliasing. Without aliasing it will through an error.
Option(B) is not correct because it is not resulting into distinct pairs of posting-nos.
Option(B) is not correct because it is not resulting into distinct pairs of posting-nos.
Correct Answer: C
Question 565 Explanation:
Option (A) is incorrect because No self join is not possible without aliasing. Without aliasing it will through an error.
Option(B) is not correct because it is not resulting into distinct pairs of posting-nos.
Option(B) is not correct because it is not resulting into distinct pairs of posting-nos.
Subscribe
Login
0 Comments