Question
The question given below consists of two statements
numbered I and II given below it. You have to decide whether the data provided in the statements are sufficient to answer the question. Read all the statement and answer the question. There are six students L, M, N, O, P and Q who scored different number of marks in the exam. Who scored highest marks? Statement I: Q scored more marks than P but scored less number of marks than M and N. O, who scored second highest marks scored more number of marks than L and M. Statement II: L scored more marks than P but scored less number of marks Q and N. M scored more number of marks than at least three students.Solution
From statement I alone, we get, Q scored more marks than P but scored less number of marks than M and N. O, who scored second highest marks scored more number of marks than L and M. We get, N, M > Q > P We get, _ > O > _ > _ > _ > _ The final arrangement is as follows: N > O > M/L > L/M > Q > P Or N > O > M > Q > L/P > P/L So, N is the highest scorer. From statement II alone, we get, L scored more marks than P but scored less number of marks Q and N. M scored more number of marks than at least three students. We get, N, Q > L > P We get M is either highest or second highest or third highest mark scorer. Therefore, Data in statement I alone are sufficient to answer the question, while the data in statement II alone are not sufficient to answer the question.
Which command removes all rows but keeps table structure?
Which operator is used for pattern matching in SQL?
In PL/SQL, what type of parameter allows a procedure to both receive a value from the calling environment and return a modified value back to it?
ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC) assigns:
In SQL, the ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW clause applies to:
Which type of index physically reorders the data rows in the table itself based on the index key, meaning the data is stored in the order of the index?
Deadlock in DBMS can be prevented using:
What is an SQL `VIEW`?
Which type of index physically reorders the data rows in the table itself based on the index key, meaning the data is stored in the order of the index?
In PL/SQL, what type of parameter allows a procedure to both receive a value from the calling environment and return a modified value back to it?
Relevant for Exams:
