When the LOWER function is used in a SELECT clause, it will automatically store

Question

       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 affect for the remainder of that user's session.
       When the LOWER function is used in a SELECT clause, the function only stays in affect for the duration of that SQL statement.
       When the LOWER function is used in a SELECT clause, the function only affects the first column in the result set.

Explanation / Answer

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

Use the LOWER function to replace every uppercase letter in a character string with a lowercase letter. The LOWER function accepts an argument of a character data type and returns a value of the same data type as the argument you specify.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.