Question

Which of the following is not a valid way to avoid search problems when you want to search for rows that have a specific date in a column that’s defined with the DATE data type? a. use the TRUNC function to truncate the time values from the date value in the column that you’re searching b. search for date values that fall between the day and the day after the date you want c. use the TO_DATE function to remove the time values from the dates in each column

Answer 1

Answer:

use the TO_DATE function to remove the time values from the dates in each column

Explanation:

DATE types are involved in most obfuscations. One database that has been considered vulnerable in this regard is the Oracle database due to the fact that a time component is always included in its DATE type. Usually, the common practice would be to use the TRUNC function for the purpose of removing the time component, when in real sense, this function does not actually remove the time. Hence to avoid search problems when searchinc for rows with a specific date in a column defined with the DATE data type, it is most effective to use the TO_DATE function to remove the time values from the dates in each column.