Author Question: If T3 is a table with three columns C1, C2, and C3, where C1 is integer data, C2 is character data, ... (Read 108 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?

Pope Sylvester II tried to introduce Arabic numbers into Europe between the years 999 and 1003, but their use did not catch on for a few more centuries, and Roman numerals continued to be the primary number system.

Did you know?

Approximately one in four people diagnosed with diabetes will develop foot problems. Of these, about one-third will require lower extremity amputation.

Did you know?

Cocaine was isolated in 1860 and first used as a local anesthetic in 1884. Its first clinical use was by Sigmund Freud to wean a patient from morphine addiction. The fictional character Sherlock Holmes was supposed to be addicted to cocaine by injection.

Did you know?

Certain rare plants containing cyanide include apricot pits and a type of potato called cassava. Fortunately, only chronic or massive ingestion of any of these plants can lead to serious poisoning.

Did you know?

Each year in the United States, there are approximately six million pregnancies. This means that at any one time, about 4% of women in the United States are pregnant.

For a complete list of videos, visit our video library