Database Management Systems, OPPE 2

May 2025 term, 17 Aug 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 titles and publishers of books where the title contains the word Python. Display title and publisher name.

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 titles and publishers of books where the title contains the word Python. Display title and publisher name. Write an SQL query to find the name of the host team that played a match on\ '2020-05-15' Write an SQL query to find the product name whose price is higher than the average price of all products. Display product_name and price