This topic contains a solution. Click here to go to the answer
« previous next »

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

appyboo

  • Hero Member
  • *****
  • Posts: 527
on: Jul 7, 2018
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
Reply #1 on: Jul 7, 2018
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

LegendaryAnswers

  • Member
  • Posts: 341
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

Serum cholesterol testing in adults is recommended every 1 to 5 years. People with diabetes and a family history of high cholesterol should be tested even more frequently.

Did you know?

Your heart beats over 36 million times a year.

Did you know?

Signs and symptoms of a drug overdose include losing consciousness, fever or sweating, breathing problems, abnormal pulse, and changes in skin color.

Did you know?

A recent study has found that following a diet rich in berries may slow down the aging process of the brain. This diet apparently helps to keep dopamine levels much higher than are seen in normal individuals who do not eat berries as a regular part of their diet as they enter their later years.

Did you know?

The Centers for Disease Control and Prevention (CDC) was originally known as the Communicable Disease Center, which was formed to fight malaria. It was originally headquartered in Atlanta, Georgia, since the Southern states faced the worst threat from malaria.

The Periodic Table (Part 2) The Periodic Table (Part 2)
Comparison of Steps of the Nursing Process with the Research Process Comparison of Steps of the Nursing Process with the Research Process
The Three Stages of the Birth Process The Three Stages of the Birth Process
Frank Lloyd Wright, Table lamp, executed for the Linden Glass Co. for the Susan Lawrence Dana ... Frank Lloyd Wright, Table lamp, executed for the Linden Glass Co. for the Susan Lawrence Dana ...
table table
Table - Correlation Analysis Table - Correlation Analysis
Video: Muscle Twitch and Muscle Tension - Motor unit size and force

For a complete list of videos, visit our video library