Question

Which of the following is an accurate statement? When the LOWER function is used in a SELECT clause, it will automatically store the data in lower-case letters in the database table. When the LOWER function is used in a SELECT clause, the function stays in effect for the remainder of that user's session. When the LOWER function is used in a SELECT clause, the function only stays in effect for the duration of that SQL statement. none of the above

Answer 1

Answer:

Hi there! The answer is C:

Explanation:

The scope of the LOWER function is limited to the select clause it is being used in. Outside of the select statement, the column will be returned as it is currently present in the database. Using the LOWER function will not automatically store data in lower case letters in the database tables. As an exercise, try creating a simple database table called "Employees" with columns "id" and "name". Then input a row using an insert statement with id as 1 and name as "BLAH". Try using the select statement with LOWER function and then without the LOWER statement.