R

Ram Sharma • 193.84K Points
Coach 

Q. 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?

(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) neither of these two conditions is met.
Correct : Option (B)

Share

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs

Q. Software engineering needed for building -----------systems in a timely manner with high quality.

Q. Attribute-based identification is

Q. The waterfall model of the software process considers each process activity as a _______ pha

Q. Which is not a computer of first generation?

Q. Which of the following operators allow defining the member functions of a class outside the class?

Q. Inst_dept (ID, name, salary, dept name, building, budget) is decomposed into instructor (ID, name, dept name, salary) department (dept name, building,

Q. who consider diagrams as a type of Class diagram, component diagram, object diagram, and deployment diagram?

Q. In software testing Verification is …..

Q. Management information systems (MIS)

Q. For any given sequence, there will ALWAYS be a unique increasing subsequence with the longest length.