Which of the below select query will fail for this table?

You have created a table as below

CREATE TABLE SNOWFLAKE (FLAKE_ID INTEGER, UDEMY_COURSE VARCHAR);

Which of the below select query will fail for this table?
A . SELECT * from snowflake;
B . SELECT * from Snowflake;
C . SELECT * from "snowflake";
D . SELECT * FROM "SNOWFLAKE";

View Answer

Answer: D

Explanation:

SQL identifiers are case-insensitive unless quoted. If the table name is created in lowercase and quoted, then trying to query it with uppercase and quotes will fail because "SNOWFLAKE" will be treated as a different identifier than "snowflake".