If T3 is a table with three columns C1,C2 and C3,where C1 is integer data,C2 is character data,and C3 is date data,which of the following would be the proper statement to have Oracle Database enter the date 02/10/03 into a row in table T3 while making sure that it is formatted correctly as shown?
A)SET INTO T3 VALUES (101,'Smith','02/10/03');
B)SET INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/03','DD/MM/YY'));
C)INSERT INTO T3 VALUES (101,'Smith','02/10/2003');
D)INSERT INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/03','DD/MM/YY'));
E)Any of the above will work correctly.

Question

Quizplus · Accepted Answer

To properly enter the date 02/10/03 into column C3 in table T3, we need to use the TO_DATE function to convert the character string into a date data type. The correct format of the TO_DATE function for the given date format is 'DD/MM/YY'. Therefore, the correct statement would be:

INSERT INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/03','DD/MM/YY'));

If T3 Is a Table with Three Columns C1,C2 and C3,where