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 84 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
Gracias!


bulacsom

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

 

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Did you know?

If all the neurons in the human body were lined up, they would stretch more than 600 miles.

Did you know?

According to the CDC, approximately 31.7% of the U.S. population has high low-density lipoprotein (LDL) or "bad cholesterol" levels.

Did you know?

The strongest synthetic topical retinoid drug available, tazarotene, is used to treat sun-damaged skin, acne, and psoriasis.

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.

For a complete list of videos, visit our video library