Consider the relation G20(country_name, foreign_minister_name, events, date, venue)\ Questions: 1. Find the name of foreign ministers whose names start with 'j' and have at least 5 characters. 2. Find out the number of events taking place in venue 'GIFT City'. 3. Find out the venue name and number of events taking place in each venue SQL queries: a. Select foreign_minister_name from G20 where foreign_minister_name like 'j' b. Select foreign_minister_name from G20 where foreign_minister_name like 'j%' c. Select count(events) from G20 where venue = 'GIFT City' d. Select count(events) from G20 where venue = 'GIFT City' Group By venue e. Select venue, count(events) from G20 Group By venue f. Select venue, count(events) from G20 Match the correct SQL queries with the corresponding Questions.

Database Management Systems · Quiz 1 · 16 Jul 2023 · May 2023 term

Question 9: Consider the relation G20(country_name, foreign_minister_…

Question 9

+4 marksOne or more correct options

Consider the relation G20(country_name, foreign_minister_name, events, date, venue)
Questions:

Find the name of foreign ministers whose names start with 'j' and have at least 5 characters.
Find out the number of events taking place in venue 'GIFT City'.
Find out the venue name and number of events taking place in each venue

SQL queries:

sql

1a. Select foreign_minister_name from G20
2where foreign_minister_name like 'j____'
3
4b. Select foreign_minister_name from G20
5where foreign_minister_name like 'j____%'
6
7c. Select count(events) from G20 where venue = 'GIFT City'
8
9d. Select count(events) from G20 where venue = 'GIFT City'
10   Group By venue
11
12e. Select venue, count(events) from G20
13   Group By venue
14
15f. Select venue, count(events) from G20

Match the correct SQL queries with the corresponding Questions.

Select all that apply.

A
1-a, 2-c, 3-f
B
1-b, 2-c, 3-e
C
1-a, 2-d, 3-f
D
1-b, 2-d, 3-e

Show answer

Correct answers

B
1-b, 2-c, 3-e
D
1-b, 2-d, 3-e

See the whole paper Take it as a mock test

Question 9 of 17 in the IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 16 Jul 2023, in the May 2023 term (IIT M FOUNDATION AN2 EXAM QPF2 16 JULY 2023). It carries 4 marks.

Question 9: Consider the relation G20(country_name, foreign_minister_…

Question 9

More questions from this paper