Start practising
Practice mode DBMS and SQL

Table Marks(score) has rows 40, 50, 60, 70 and 80. SELECT COUNT(*) FROM Marks WHERE score BETWEEN 50 AND 70; What is returned?

Correct answer B. 3

Explanation

BETWEEN is inclusive at both ends: score BETWEEN 50 AND 70 means score >= 50 AND score and <.

Report a problem

Answer checked How we write and check questions

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

Advertisement

More DBMS and SQL questions

See all
Question 01 DBMS and SQL

Why must a secondary index, built on a key that is not the file’s sort order, be a dense index?

Correct answer C. Because the records are not sorted on that key, so every key value needs its own index entry

Open question
Advertisement

Discussion

Have a question about this answer?

Your email address will not be published. Required fields are marked *

Links and website addresses are not allowed in comments.