Solved

Contents of the PUBLISHER Table​

Question 14

Multiple Choice

Contents of the PUBLISHER table​
Contents of the PUBLISHER table​ -If a column named SAL_PCT is to be defined to ensure a value of 100 is input if a NULL value is provided when a new row is inserted,which column definition should be used?​ A) ​SAL_PCT NULL 100 DEFAULT. B) ​SAL_PCT DEFAULT ON NULL 100. C) ​SAL_PCT DEFAULT 100. D) ​SAL_PCT ON NULL 100.
-If a column named SAL_PCT is to be defined to ensure a value of 100 is input if a NULL value is provided when a new row is inserted,which column definition should be used?​


A) ​SAL_PCT NULL 100 DEFAULT.
B) ​SAL_PCT DEFAULT ON NULL 100.
C) ​SAL_PCT DEFAULT 100.
D) ​SAL_PCT ON NULL 100.

Correct Answer:

verifed

Verified

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

Related Questions

Q9: Commands used to modify data are known

Q10: A(n)<u>shared </u>lock prevents other users from obtaining

Q11: Commands used to modify data are called

Q12: If the WHERE clause is omitted from

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

Q15: If the _ clause of the UPDATE

Q16: A shared lock is automatically obtained when

Q17: The <u>SELECT...FOR UPDATE</u> can be used to

Q18: The BLOCK ACCESS command can be used

Q19: Data that is being added to a