Consider the tables 3 and 4 and answer the given subquestions. Table 3: Relation team | team_id | name | ranking | country | |---|---|---|---| | Cric-1 | BCCI | 1 | India | | Cric-2 | ACB | 3 | Australia | | Cric-3 | PCB | 10 | Pakistan | | Cric-4 | NCB | 9 | Nepal | | Cric-5 | ECB | 4 | England | Table 4: Relation players | team_id | player_id | name | ranking | |---|---|---|---| | Cric-1 | BCCI-11 | Virat | 1 | | Cric-1 | BCCI-23 | Rohit | 3 | | Cric-3 | PCB-22 | Azam | 2 | | Cric-2 | ACB-12 | David | 6 | | Cric-2 | ACB-29 | Smith | 3 | | Cric-5 | ECB-88 | Cris | 4 | | Cric-5 | ECB-82 | Ben | 1 | Using the SQL query shown below, a view named BestTeam is created. CREATE VIEW BestTeam AS SELECT p.player_id, p.name, t.country FROM players p join team t on p.team_id = t.team_id WHERE t.ranking < 4 Which among the following SQL queries will display the table shown below? | player_id | name | |---|---| | BCCI-11 | Virat | | BCCI-23 | Rohit |

(B) Option figure from the original question paper

(A) Option figure from the original question paper

(C) Option figure from the original question paper

(D) Option figure from the original question paper

Database Management Systems · Quiz 1 · 27 Oct 2024 · September 2024 term

Question 14: Using the SQL query shown below, a view named BestTeam i…

Question 14

+4 marksOne correct option

Consider the tables 3 and 4 and answer the given subquestions.

Table 3: Relation team

team_id	name	ranking	country
Cric-1	BCCI	1	India
Cric-2	ACB	3	Australia
Cric-3	PCB	10	Pakistan
Cric-4	NCB	9	Nepal
Cric-5	ECB	4	England

Table 4: Relation players

team_id	player_id	name	ranking
Cric-1	BCCI-11	Virat	1
Cric-1	BCCI-23	Rohit	3
Cric-3	PCB-22	Azam	2
Cric-2	ACB-12	David	6
Cric-2	ACB-29	Smith	3
Cric-5	ECB-88	Cris	4
Cric-5	ECB-82	Ben	1

Using the SQL query shown below, a view named BestTeam is created.

sql

1CREATE VIEW BestTeam AS
2SELECT p.player_id, p.name, t.country
3FROM players p join team t on p.team_id = t.team_id
4WHERE t.ranking < 4

Which among the following SQL queries will display the table shown below?

player_id	name
BCCI-11	Virat
BCCI-23	Rohit

Show answer

Correct answer

See the whole paper Take it as a mock test

Question 14 of 14 in the IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 27 Oct 2024, in the September 2024 term (IIT M DIPLOMA AN EXAM QDD2 27 Oct 2024). It carries 4 marks.

Question 14: Using the SQL query shown below, a view named BestTeam i…

Question 14

More questions from this paper