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

Author Question: What is the process for adding a NOT NULL column to a table? What will be an ideal ... (Read 56 times)

appyboo

  • Hero Member
  • *****
  • Posts: 527
What is the process for adding a NOT NULL column to a table?
 
  What will be an ideal response?

Question 2

If you have a table with a set of columns named Child01, Child02 and Child03, the table is likely to have the multivalued, multicolumn problem.
 
  Indicate whether the statement is true or false



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

chem1s3

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

There are three steps in adding a NOT NULL column to a table. First, the column is added as a NULL column. Second, data is added to the column using one or more UPDATE statements. Finally, the ALTER command is used to change the column from NULL to NOT NULL.

Answer to Question 2

TRUE




appyboo

  • Member
  • Posts: 527
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review


adammoses97

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

 

Did you know?

Your chance of developing a kidney stone is 1 in 10. In recent years, approximately 3.7 million people in the United States were diagnosed with a kidney disease.

Did you know?

Tobacco depletes the body of vitamins A, C, and E, which can result in any of the following: dry hair, dry skin, dry eyes, poor growth, night blindness, abscesses, insomnia, fatigue, reproductive system problems, sinusitis, pneumonia, frequent respiratory problems, skin disorders, weight loss, rickets, osteomalacia, nervousness, muscle spasms, leg cramps, extremity numbness, bone malformations, decayed teeth, difficulty in walking, irritability, restlessness, profuse sweating, increased uric acid (gout), joint damage, damaged red blood cells, destruction of nerves, infertility, miscarriage, and many types of cancer.

Did you know?

About 3.2 billion people, nearly half the world population, are at risk for malaria. In 2015, there are about 214 million malaria cases and an estimated 438,000 malaria deaths.

Did you know?

To combat osteoporosis, changes in lifestyle and diet are recommended. At-risk patients should include 1,200 to 1,500 mg of calcium daily either via dietary means or with supplements.

Did you know?

Malaria was not eliminated in the United States until 1951. The term eliminated means that no new cases arise in a country for 3 years.

For a complete list of videos, visit our video library