Which query element should be uppercase? Select 5 correct answers.A. selectB. fromC. likeD. whereE. column nameF. table nameG. cast()

In SQL queries, the convention is to write the SQL keywords in uppercase to enhance readability and differentiate them from identifiers like table names and column names which typically follow standard casing conventions. Based on this:

1. A. select - Correct. SQL keyword.
2. B. from - Correct. SQL keyword.
3. C. like - Correct. SQL keyword.
4. D. where - Correct. SQL keyword.
5. E. column name - Incorrect. Should be written in lowercase or camel case (e.g., columnName).
6. F. table name - Incorrect. Should also follow standard naming conventions.
7. G. cast() - Correct. Although it is a function, it is convention to write SQL functions in uppercase.

Final Answer

The correct uppercase query elements are: A, B, C, D, G.