Database Management Systems, OPPE 2

September 2025 term, 6 Dec 2025, Set A

Quiz Space

MusicOpen the study music controls.

CalculatorOpen the calculatorLearning mode

Question 1

+1−0Instructions

QuestionTest casesSolution

Write a SQL Query to find the names of all players belonging to the teams 'Amigos', 'Thunder', and 'Arawali'

Primary keyForeign key

−100%+Fit

Code Editor

SQL

−14+

ResetNot submitted

Run sample testsSubmit

Submit this paper?

You cannot change your answers after submitting.

Answered

0

Not answered

1

Marked for review

0

Answered & marked for review

0

Not visited

2

Keep goingSubmit paper

Instructions

The palette shows the status of every question. Pick a number to go straight to it.

Answered

0

Not answered

1

Marked for review

0

Answered & marked for review

0

Not visited

2

• Save & Next moves to the next question. Answers are saved as you go.
• Mark for Review & Next flags the question to come back to. A flagged answer still counts.
• Clear Response removes your answer to the question on screen.
• The ← and → keys move to the previous and next question.

Write a SQL Query to find the names of all players belonging to the teams 'Amigos', 'Thunder', and 'Arawali' Write a SQL query to find the roll numbers of students whose first name starts with 'S', ends with 'a', and who were born after 2002-07-01 Write a SQL query to find the number of female students in each department. Display the department name and number of students