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

question 43

Multiple Choice

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.

---

Definitions:

Bushels of Wheat

A unit of measure used in agriculture, particularly in the United States, for trading and pricing wheat.

Workers

Individuals engaged in a task or activity for wages or salary.

Diminishing Marginal Product

The decrease in the additional output gained from using an extra unit of a production input, holding all other inputs constant, beyond a certain point.

Marginal Product

The supplementary yield that comes from the utilization of an extra unit of a given input, with all other inputs remaining fixed.