To add a NOT NULL column to a table,we ________.
A) use the REVISE TABLE command
B) use the ALTER TABLE command
C) use the MODIFY TABLE command
D) create a new NULL column,insert data values into every row,and change the NULL constraint to NOT NULL
E) None of the above is the correct way to add a NOT NULL column to a table.
Correct Answer:
Verified
Q83: Why do databases need redesigning?
Q87: Explain the results provided by the EXISTS,NOT
Q88: When changing the minimum cardinality on the
Q90: When dropping a primary key column from
Q90: Discuss the role of backup and test
Q92: When changing column data types,which of the
Q93: When dropping a foreign key column from
Q95: When redesigning a database,how can we check
Q95: What is a correlated subquery?
Q96: When decreasing cardinalities,there will always be _.
A)relationship
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents