Question
Among the seven students P, Q, R, S, T, U and V, who
scored 2nd highest in quant test? I: P scored more than only R. Two students scored more than V, who scored more than P and Q. II: T scored less than S, who scored more than Q. III. R scored less than S, who does not score the highest In the following question, a given questions is followed by information in three statements. You have to decide the data in which statement (s) is sufficient to answer the question and mark your answer accordingly.Solution
From statement I and II: P scored more than only R. Two students scored more than V, who scored more than P and Q. ? > ? > V > ?> ? > P > R T scored less than S, who scored more than Q. So, no proper information is given. From statement II and III: T scored less than S, who scored more than Q. R scored less than S, who does not score the highest. So, no proper information is given. From both I and III: P scored more than only R. Two students scored more than V, who scored more than P and Q. R scored less than S, who does not score the highest. ? > ? > V > ?> ? > P > R So, no proper information is given. From I, II and III: U > S > V > T/Q > Q/T > P > R So, from I, II and III It is clear that S, scored the 2nd highest.
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?