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

After 5 years of being diagnosed with rheumatoid arthritis, one every three patients will no longer be able to work.

Did you know?

According to animal studies, the typical American diet is damaging to the liver and may result in allergies, low energy, digestive problems, and a lack of ability to detoxify harmful substances.

Did you know?

The longest a person has survived after a heart transplant is 24 years.

Did you know?

A cataract is a clouding of the eyes' natural lens. As we age, some clouding of the lens may occur. The first sign of a cataract is usually blurry vision. Although glasses and other visual aids may at first help a person with cataracts, surgery may become inevitable. Cataract surgery is very successful in restoring vision, and it is the most frequently performed surgery in the United States.

Did you know?

Long-term mental and physical effects from substance abuse include: paranoia, psychosis, immune deficiencies, and organ damage.

For a complete list of videos, visit our video library