Question
In an examination, Ravi got more marks than Manoj but
not as many marks as Preeti. Preeti got more marks than Ganesh and Komal. Ganesh got less marks than Manoj, but his marks are not the lowest in the group. Who got the highest marks?Solution
Preeti < Ravi < Manoj < Ganesh < Komal
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
Which SQL statement combines the results of two queries and removes duplicates?
Which SQL clause is used to filter records based on aggregate functions?
Which SQL clause is used to filter results after a GROUP BY operation?
Which of the following statements about SQL `INDEXES` is generally TRUE?
Which SQL clause is used for filtering rows?
Given a table employees(id, dept_id, salary), which query returns departments with average salary greater than overall average across the company?
What is the main function of a PL/SQL `TRIGGER`?
Which join returns rows from the left table even when there is no matching row in the right table, filling with NULLs for the right side?
Which SQL clause is used to group rows?
Relevant for Exams:
