A. Delete the table CLICK_STREAM, and then re-create it such that the column DTis of the TIMESTAMP
type. Reload the data.

B. Add two columns to the table CLICK STREAM: TSof the TIMESTAMPtype and IS_NEWof the
BOOLEANtype. Reload all data in append mode. For each appended row, set the value of IS_NEWto
true. For future queries, reference the column TSinstead of the column DT, with the WHEREclause
ensuring that the value of IS_NEWmust be true.

C. Create a view CLICK_STREAM_V, where strings from the column DTare cast into TIMESTAMPvalues.
Reference the view CLICK_STREAM_Vinstead of the table CLICK_STREAMfrom now on.

D. Construct a query to return every row of the table CLICK_STREAM, while using the built-in function to
cast strings from the column DTinto TIMESTAMPvalues. Run the query into a destination table
NEW_CLICK_STREAM, in which the column TSis the TIMESTAMPtype. Reference the table
NEW_CLICK_STREAMinstead of the table CLICK_STREAMfrom now on. In the future, new data is
loaded into the table NEW_CLICK_STREAM.

E. Add a column TSof the TIMESTAMPtype to the table CLICK_STREAM, and populate the numeric
values from the column TSfor each row. Reference the column TSinstead of the column DTfrom now
on.