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?

Related MCQs

• With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?
• Consider a hash table of size seven, with starting index zero, and a hash function (3x + 4)mod7. Assuming the hash table is initially empty, which of the following is the contents of the table when the sequence 1, 3, 8, 10 is inserted into the table using closed hashing? Note that ‘_’ denotes an empty location in the table.
• Which of the syntax is correct for insert statement? i) insert into <table_name> values <list of values> ii) insert into <table_name> (column list) values <list of values>
• With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName”?
• What SQL structure is used to limit column values of a table?
• Which command is used to add a column to an existing table?
• Drop Table cannot be used to drop a table referenced by a                    constraint.
• Drop Table cannot be used to drop a table referenced by a …………… constraint.
• If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
• You have a column that will only contain values from 0 to 256. What is the most economical data type to use for the column?