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) Any of the above will work correctly.

Question

Quizplus · Accepted Answer

The correct statement to enter the date 02/10/14 into table T3 while ensuring the correct formatting is option D, which uses the TO_DATE function to convert the input string to a date format. The format string 'DD/MM/YY' specifies that the input date should be in the day/month/year format with two-digit years. The other options either have incorrect formatting or do not use the TO_DATE function to convert the input to a proper date format.

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