Database Management Systems, OPPE 2

January 2025 term, 6 Apr 2025, Set A

Quiz Space

MusicOpen the study music controls.

CalculatorOpen the calculatorLearning mode

Question 1

+1−0Instructions

QuestionTest casesSolution

Write an SQL query to find the name and quantity of the products whose name starts with the character 'F' and ends with the character 'e'.

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 an SQL query to find the name and quantity of the products whose name starts with the character 'F' and ends with the character 'e'. Write an SQL query to find the name and jersey number of the players from the team 'Arawali'. Write an SQL query to find the first name and last name of the authors (without any duplicates) whose books were published in the years '2017' or '2019'.