Quiz for Case Sensitivity

Q1: Which part of an SQL query is usually case-insensitive?

A. Table names B. Column names C. SQL keywords D. String data

Q2: Is SQL case sensitive for keywords?

A. Yes B. No C. Depends on DBMS D. Only in MySQL

Q3: Is SQL case sensitive for table names?

A. Always yes B. Always no C. Depends on OS and DBMS D. Only in Oracle

Q4: Which of the following is case sensitive in SQL by default?

A. Column names B. Aliases C. String comparisons D. Keywords

Q5: How do you perform a case-insensitive search in SQL?

A. Using UPPER() B. Using LOWER() C. Using ILIKE (in PostgreSQL) D. All of the above

Q6: Is the following SQL query case sensitive? SELECT * FROM users WHERE name = "John";

A. Yes B. No C. Depends on DBMS D. Depends on table collation

Q7: Which DBMS uses ILIKE for case-insensitive pattern matching?

A. MySQL B. PostgreSQL C. SQL Server D. Oracle

Q8: Which clause can be used with UPPER() to make search case-insensitive?

A. WHERE B. GROUP BY C. HAVING D. SELECT

Q9: What is the output of: SELECT "Hello" = "hello"; in MySQL?

A. true B. false C. error D. depends on collation

Q10: Are SQL column aliases case sensitive?

A. Yes B. No C. Depends on DBMS D. Only in SELECT clause

Q11: Which of the following is treated as same in SQL?

A. SELECT, select B. TABLE, Table C. users, Users D. All of the above

Q12: To enforce case-sensitive comparison in SQL Server, use:

A. COLLATE Latin1_General_CS_AS B. UPPER() C. ILIKE D. BINARY

Q13: Which SQL clause is most affected by case sensitivity in search?

A. WHERE B. SELECT C. GROUP BY D. ORDER BY

Q14: Which collation disables case sensitivity in MySQL?

A. utf8_general_ci B. utf8_bin C. latin1_general_cs D. ascii_bin

Q15: Does Oracle SQL treat identifiers as case-sensitive?

A. Yes B. No C. Only when quoted D. Only for functions

Q16: Which one is a case-sensitive collation in MySQL?

A. utf8_bin B. utf8_general_ci C. latin1_swedish_ci D. ascii_ci

Q17: What will be the result of SELECT "A" = "a" in PostgreSQL by default?

A. true B. false C. error D. depends on DB version

Q18: Which operator performs case-insensitive comparison in PostgreSQL?

A. LIKE B. ILIKE C. = D. MATCH

Q19: Which setting influences case sensitivity in MySQL tables?

A. Storage engine B. Collation C. SQL mode D. Indexing

Q20: Which of the following will match "Data" in a case-sensitive WHERE clause?

A. WHERE column = "Data" B. WHERE column = "data" C. WHERE column = "DATA" D. None unless exact case matches

Q21: To make SQL keyword comparisons case-sensitive, what must be done?

A. Change DBMS B. Enable strict mode C. Use binary collation D. Not possible