To increase the number of nullable columns for a table:

A. Use the alter table statement.
B. Ensure that all column values are NULL for all rows.
C. First, increase the size of adjacent column datatypes, and then add the column.
D. Add the column, populate the column, and then add the NOT NULL constraint.

Answer: A. Use the alter table statement.

Computer Science & Information Technology

You might also like to view...

A printer on the second floor is not printing for anyone. However, the printer has power and displays ready on the LCD display. There is paper in the trays and the toner was recently changed. The system administrator goes to the location with a laptop and tests the network port and is able to connect. Jobs are being queued on the local machines. Which of the following should the system administrator do to get the printer functioning again?

A. Move the printer to a known good port and connect to the network B. Replace the network cable to the printer C. Verify the server's print spooler service is running D. Attach the printer directly to the laptop and print a test page

Computer Science & Information Technology

What is the purpose of using an assert or throwing an exception in the peek method?

What will be an ideal response?

Computer Science & Information Technology