Author Question: If T3 is a table with three columns C1, C2, and C3, where C1 is integer data, C2 is character data, ... (Read 73 times)

evelyn o bentley

  • Hero Member
  • *****
  • Posts: 564
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 2

Group attributes are composites of other attributes.
 
  Indicate whether the statement is true or false



mcarey591

  • Sr. Member
  • ****
  • Posts: 365
Answer to Question 1

D

Answer to Question 2

TRUE



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

Urine turns bright yellow if larger than normal amounts of certain substances are consumed; one of these substances is asparagus.

Did you know?

The largest baby ever born weighed more than 23 pounds but died just 11 hours after his birth in 1879. The largest surviving baby was born in October 2009 in Sumatra, Indonesia, and weighed an astounding 19.2 pounds at birth.

Did you know?

There are actually 60 minerals, 16 vitamins, 12 essential amino acids, and three essential fatty acids that your body needs every day.

Did you know?

Although the Roman numeral for the number 4 has always been taught to have been "IV," according to historians, the ancient Romans probably used "IIII" most of the time. This is partially backed up by the fact that early grandfather clocks displayed IIII for the number 4 instead of IV. Early clockmakers apparently thought that the IIII balanced out the VIII (used for the number 8) on the clock face and that it just looked better.

Did you know?

Patients who have undergone chemotherapy for the treatment of cancer often complain of a lack of mental focus; memory loss; and a general diminution in abilities such as multitasking, attention span, and general mental agility.

For a complete list of videos, visit our video library