Database Management Systems, OPPE 2

January 2025 term, 30 Mar 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 ends with the character 'b' and contains at least five characters.

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 ends with the character 'b' and contains at least five characters. Write an SQL query to find the titles of the book, that were published after 2005 and author's first name is 'Subrata' and lastname is 'Saha'. Write an SQL query to find the referee\ id, number of matches conducted by\ referee 'Tony Joseph Louis'.