Crowdly

Add to Chrome

Which of the following commands will enforce the EMPLOYEE table to not accept ne...

✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.

Which of the following commands will enforce the EMPLOYEE table to not accept negative values in the SALARY field?

ALTER TABLE EMPLOYEE; ALTER COLUMN SALARY CHECK (SALARY>=0)

❌

ALTER TABLE EMPLOYEE; ADD CONSTRAINT SALARY>=0

❌

ALTER TABLE EMPLOYEE; ADD CHECK (SALARY>=0)

❌

ALTER TABLE EMPLOYEE; ADD CONSTRAINT chk_Emp_Salary CHECK (SALARY>=0)

✅

More questions like this

Want instant access to all verified answers on softserve.academy?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome

Telegram Instagram TikTok Question Bank

Terms of Use Contact Us