Multiple Choice
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
Correct Answer:
Verified
Q14: There is no good SQL command that
Q26: The NOT EXISTS keyword will be true
Q30: The design produced by reverse engineering may
Q36: In the SQL statements SELECT C1.CustName,C1.SalesRepNo<br>FROM CUSTOMER
Q37: The data model produced by reverse engineering
Q38: When running a correlated subquery,the DBMS _.<br>A)runs
Q39: To drop a primary key column from
Q88: SQL contains an SQL command RENAME TABLENAME
Q95: When using queries with EXISTS and NOT
Q98: To drop a foreign key column from