This topic contains a solution. Click here to go to the answer

Author Question: To drop a primary key column from a table the primary key constraint must first be dropped, but this ... (Read 111 times)

CBme

  • Hero Member
  • *****
  • Posts: 548
To drop a primary key column from a table the primary key constraint must first be dropped, but this does not require that related foreign keys based on the column be dropped.
 
  Indicate whether the statement is true or false

Question 2

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/14 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/14');
  B) SET INTO T3 VALUES (101, 'Smith', TO_DATE ('02/10/14', 'DD/MM/YY'));
  C) INSERT INTO T3 VALUES (101, 'Smith', '02/10/2014');
  D) INSERT INTO T3 VALUES (101, 'Smith', TO_DATE ('02/10/14', 'DD/MM/YY'));
  E) Any of the above will work correctly.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

krakiolit

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

FALSE

Answer to Question 2

D




CBme

  • Member
  • Posts: 548
Reply 2 on: Jul 7, 2018
Gracias!


AngeliqueG

  • Member
  • Posts: 343
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

 

Did you know?

Acute bronchitis is an inflammation of the breathing tubes (bronchi), which causes increased mucus production and other changes. It is usually caused by bacteria or viruses, can be serious in people who have pulmonary or cardiac diseases, and can lead to pneumonia.

Did you know?

Allergies play a major part in the health of children. The most prevalent childhood allergies are milk, egg, soy, wheat, peanuts, tree nuts, and seafood.

Did you know?

Signs of depression include feeling sad most of the time for 2 weeks or longer; loss of interest in things normally enjoyed; lack of energy; sleep and appetite disturbances; weight changes; feelings of hopelessness, helplessness, or worthlessness; an inability to make decisions; and thoughts of death and suicide.

Did you know?

An identified risk factor for osteoporosis is the intake of excessive amounts of vitamin A. Dietary intake of approximately double the recommended daily amount of vitamin A, by women, has been shown to reduce bone mineral density and increase the chances for hip fractures compared with women who consumed the recommended daily amount (or less) of vitamin A.

Did you know?

The first documented use of surgical anesthesia in the United States was in Connecticut in 1844.

For a complete list of videos, visit our video library