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 110 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
YES! Correct, THANKS for helping me on my review


nothere

  • Member
  • Posts: 324
Reply 3 on: Yesterday
Wow, this really help

 

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?

Cyanide works by making the human body unable to use oxygen.

Did you know?

In 1864, the first barbiturate (barbituric acid) was synthesized.

Did you know?

Many supplement containers do not even contain what their labels say. There are many documented reports of products containing much less, or more, that what is listed on their labels. They may also contain undisclosed prescription drugs and even contaminants.

Did you know?

It is important to read food labels and choose foods with low cholesterol and saturated trans fat. You should limit saturated fat to no higher than 6% of daily calories.

For a complete list of videos, visit our video library