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

Question

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

Quizplus · Accepted Answer

The LOWER function in a SELECT clause only stays in effect for the duration of that SQL statement. It does not permanently alter the data in the database table, nor does it stay in effect for the remainder of the user's session.

Which of the Following Is an Accurate Statement?​

Which of the Following Is an Accurate Statement?