Multiple choice

Which of the following is (are) true with respect to SQL?

(I) SQL is case insensitive

(II) Patterns used for comparison of string are case sensitive

(III) FROM and fROM are equivalent and mean the same keyword

(IV) String 'Mr' is not equal to string 'MR'

  1. (I) , (II) and (III) only

  2. (I) and (IV) only

  3. (II), (III) and (IV) only

  4. (I) , (II), (III) and (IV) only
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

SQL is case insensitive, meaning that it treats upper and lower case letters as the same letter.$\therefore$ Statements (I) and (III) are true.But patterns used for comparison of string are case sensitive. Instead all inside quotes is case sensitive. $\therefore$ Statements (II) and (IV) are also true hence, (4) is the answer.

Keep practicing — related questions