Solved

​Structure of the ORDERITEMS Table

Question 55

Multiple Choice

​Structure of the ORDERITEMS table
​Structure of the ORDERITEMS table -Based on the structure of the ORDERITEMS table,which of the following commands will add a NOT NULL constraint to the ISBN column?​ A) ​ALTER TABLE orderitems ADD (isbn NOT NULL) ; B) ​ALTER TABLE orderitems ADD NOT NULL (isbn) ; C) ​ALTER TABLE orderitems ADD isbn NOT NULL; D) ​none of the above
-Based on the structure of the ORDERITEMS table,which of the following commands will add a NOT NULL constraint to the ISBN column?​


A) ​ALTER TABLE orderitems ADD (isbn NOT NULL) ;
B) ​ALTER TABLE orderitems ADD NOT NULL (isbn) ;
C) ​ALTER TABLE orderitems ADD isbn NOT NULL;
D) ​none of the above

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q50: ​Structure of the ORDERITEMS table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg"

Q51: ​Structure of the PROMOTION table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg"

Q52: Which of the following are used to

Q53: ​Structure of the PROMOTION table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg"

Q54: Constraints are rules used to enforce business

Q56: Unless a PRIMARY KEY or a(n)_ constraint

Q57: The CONSTRAINT keyword is required if the

Q58: A(n)<u>UNIQUE</u> constraint will allow NULL values to

Q59: A<u> Datatype</u> is a rule used to

Q60: ​Which of the following is the standard