Quiz Space

Database Management Systems · Quiz 1 · 7 Jul 2024 · May 2024 term

Question 2: Consider the table Champions_League for given subquestion…

Question 2

+4 marksNumerical answer

Consider the table Champions_League for given subquestions

NameAgeTeamCountryGoals
De jong26BarcelonaNetherlands20
Bellingham20Real MadridEngland18
Haaland23Manchester CityNorway18
Araujo25BarcelonaUruguay20
Martinelli22ArsenalBrazil16
Mbappe25PSGFrance16
Kroos34Real MadridGermany18
Dembele26PSGFrance14
Saka22ArsenalEngland16
Cubarsi17BarcelonaSpain12

Table 1: Figure 1: Champions_League

Show answer

Correct answer: 4

See the whole paperTake it as a mock test

Question 2 of 15 in the IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 7 Jul 2024, in the May 2024 term (IIT M DIPLOMA AN EXAM QDD2 7 July 2024). It carries 4 marks.

More questions from this paper

  1. Q1Consider the table Champions_League for given subquestions | Name | Age | Team | Country | Goals | |---|---|---|---|---…
  2. Q3Consider the following SQL statement: Which among the following will cause an integrity constraint violation in the Car…
  3. Q4Figure question
  4. Q5Figure question
  5. Q6Consider the following relations: players(<u>pid</u>, name, age, jersey_no)\ teams(<u>team_name</u>, matches, points, p…
  6. Q7Consider the following data for given subquestions: | Driver_ID | Name | Team | Salary | |---|---|---|---| | 55 | Carlo…
  7. Q8Consider the following data for given subquestions: | Driver_ID | Name | Team | Salary | |---|---|---|---| | 55 | Carlo…
  8. Q9Which of the following statement(s) is/are correct?
  9. Q10Consider the E-R diagram given in Figure 1 and answer the subquestions. Identify the correct relational schema for the …
  10. Q11Consider the E-R diagram given in Figure 1 and answer the subquestions. Identify the correct relational schema for the …
  11. Q12Consider the E-R diagram given in Figure 1 and answer the subquestions.
  12. Q13Consider the tables r and s. | A | B | C | D | |---|---|---|---| | p | 1 | p | a | | q | 2 | r | a | | r | 4 | q | b | …
  13. Q14Consider a relational schema:\ Parts(<u>Pid</u>, Pname, Price, Quantity)\ Vendors (<u>Vid</u>, Vname, Location, Pid) Co…
  14. Q15Consider the following table which has three attributes: X, Y and Z, where X is the primary key and Z is the foreign ke…