Practice mode DBMS and SQL

Table Result(name, marks) has rows (‘Ali’,80), (‘Bina’,90), (‘Chand’,80), (‘Dua’,70). SELECT name FROM Result ORDER BY marks DESC, name ASC LIMIT 2; What is returned?

Correct answer A. Bina, Ali

Explanation

Rows are sorted by marks from highest to lowest, and the second key, name ascending, breaks ties. Bina (90) comes first. Ali and Chand both have 80, and alphabetically Ali comes before Chand, so Ali is second. LIMIT 2 keeps those two rows. Without the tie-breaker the order of Ali and Chand would not be guaranteed.

Report a problem

Answer checked 12 October 2026 How we write and check questions

Tip: press A, B, C or D to answer, and N for the next question.

Table Result(name, marks) has rows (‘Ali’,80), (‘Bina’,90), (‘Chand’,80), (‘Dua’,70). SELECT name FROM Result ORDER BY marks DESC, name ASC LIMIT 2; What is returned?

Discussion

Have a question about this answer? Cancel reply

Table Result(name, marks) has rows (‘Ali’,80), (‘Bina’,90), (‘Chand’,80), (‘Dua’,70). SELECT name FROM Result ORDER BY marks DESC, name ASC LIMIT 2; What is returned?

More DBMS and SQL questions

Table Emp(id, dept, salary) has rows (1,’HR’,3000), (2,’IT’,5000), (3,’IT’,4000), (4,’HR’,NULL), (5,’Ops’,2000). SELECT COUNT(*), COUNT(salary) FROM Emp; What does this query return?

Table Emp(id, dept, salary) has rows (1,’HR’,3000), (2,’IT’,5000), (3,’IT’,4000), (4,’HR’,NULL), (5,’Ops’,2000). SELECT AVG(salary) FROM Emp WHERE dept = ‘HR’; What value is returned?

Table Emp(id, dept, salary) has rows (1,’HR’,3000), (2,’IT’,5000), (3,’IT’,4000), (4,’HR’,NULL), (5,’Ops’,2000). SELECT dept, SUM(salary) FROM Emp GROUP BY dept HAVING SUM(salary) > 3000 ORDER BY dept; Which rows are returned?

Table Emp(id, dept, salary) has rows (1,’HR’,3000), (2,’IT’,5000), (3,’IT’,4000), (4,’HR’,NULL), (5,’Ops’,2000). SELECT COUNT(DISTINCT dept) FROM Emp; What is the output?

Discussion

Have a question about this answer? Cancel reply