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

A strange skin disease referred to as Morgellons has occurred in the southern United States and in California. Symptoms include slowly healing sores, joint pain, persistent fatigue, and a sensation of things crawling through the skin. Another symptom is strange-looking, threadlike extrusions coming out of the skin.

Did you know?

In ancient Rome, many of the richer people in the population had lead-induced gout. The reason for this is unclear. Lead poisoning has also been linked to madness.

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?

Although not all of the following muscle groups are commonly used, intramuscular injections may be given into the abdominals, biceps, calves, deltoids, gluteals, laterals, pectorals, quadriceps, trapezoids, and triceps.

Did you know?

Automated pill dispensing systems have alarms to alert patients when the correct dosing time has arrived. Most systems work with many varieties of medications, so patients who are taking a variety of drugs can still be in control of their dose regimen.

For a complete list of videos, visit our video library