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/14 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/14');
B) SET INTO T3 VALUES (101, 'Smith', TO_DATE ('02/10/14', 'DD/MM/YY'));
C) INSERT INTO T3 VALUES (101, 'Smith', '02/10/2014');
D) INSERT INTO T3 VALUES (101, 'Smith', TO_DATE ('02/10/14', 'DD/MM/YY'));
E) INSERT INTO T3 VALUES ('Smith', TO_DATE ('02/10/14', 'DD/MM/YY'), 101);

Question

Quizplus · Accepted Answer

When inserting a date value into Oracle Database, it is recommended to use the TO_DATE function to ensure that the date is formatted correctly. In this case, option D is the only choice that uses the TO_DATE function with the correct format mask of 'DD/MM/YY'. Option A and C do not use the TO_DATE function and option E has the columns in the wrong order. Therefore, the correct choice is D.

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