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/13');
B)SET INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/13','DD/MM/YY'));
C)INSERT INTO T3 VALUES (101,'Smith','02/10/2013');
D)INSERT INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/13','DD/MM/YY'));
E)Any of the above will work correctly.

Question

Quizplus · Accepted Answer

The correct statement to enter the date into the table with the correct format would be to use the TO_DATE function. Option B correctly uses the TO_DATE function with the appropriate date format mask ('DD/MM/YY') to convert the string '02/10/13' to a DATE data type before inserting it into the table. Option A and C both attempt to insert a string value directly into the table which will not be interpreted as a date. Option E is incorrect as not all of the options will work correctly.

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