What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
Options
A. ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0);
B. ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);
C. ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
D. None of the above is correct.
Correct Answer
ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
More questions
1. In the relational model, relationships between relations or tables are created by using:
Correct Answer: Object Repository means not a collection of objects it's a common repository for all the people (testing, developers) for seeing all the data in single login for example QA wants to see 5 testers works then he goes to each person login and see the data It's very difficult job for this we can use Object Repository
Correct Answer: The OSI Model is used as a reference model The primary reason the OSI model was created was so that different networks could inter-operate Hence, different networks could communicate