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

question 67

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/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.

---

Definitions:

Predictive Validity

The extent to which a score on a scale or test predicts future performance or behavior.

Intrapersonal Intelligence

Intrapersonal intelligence is the capacity to understand oneself, including one's emotions, motivations, and thoughts.

Creative Intelligence

The ability to go beyond existing ideas to create novel and interesting ones, a component of Sternberg's triarchic theory of intelligence.

Savant Syndrome

A condition where someone with significant mental disabilities demonstrates profound and prodigious capacities or abilities in limited areas.