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'));

Question

Quizplus · Accepted Answer

The correct syntax for inserting a date into an Oracle Database table with a specific format is to use the TO_DATE function along with the INSERT INTO statement. The TO_DATE function converts a string to a date, using the format specified ('DD/MM/YY' in this case). Option D correctly uses both the INSERT INTO statement and the TO_DATE function to insert the date in the desired format.

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