A foreign key constraint can only be created at the column level. True False A NOT NULL constraint can only be created at the columa level True False When dropping a constraint, the user is always required to specify the name of the constraint being dropped True False The ALTER TABLE command with the ENABLE clause can be used to enable a constraint True False The SYSDATE can be used as a condition in a CHECK goastraint True False A FOREIGN KEY constraint will not allow a row containing a NUL valbe in the foreign key column to be added to the table. A CHECK constraint requires that a data value meet a certain condition before the record is added to the database table, A Datatype is a rule used to ensure the accuracy of data stored in a database. True False False True With the exception of the NOT NULL constraint, constraints can be added to a table using the ADD clause of the ALTER TABLE command False False A constraint can be added to a table after the table has been populated with data even if the existing data violates the True False A(a) UNIQUE constraint will allow NULL values to be stored in the designated column Faise If a FOREIGN KEY constraint exists, then a record cannot be deleted from the parent table if that row is referenced by an entry in the child table. True False A constraint is always enforced at the table level the table Jevel. False
1. Foreign key constraint can only be created at the column level
True
The foreign key is a column in a table, but it refers to the primary key in the other table.
2. A NOT NULL constraint can only be created at the column level
True
There is no way that we can put NOT NULL constraint for anything other than column.
3. When dropping a constraint, the user is always required to specify the number of constraint being dropped
False
There is no need to give the number of constraint being dropped. Mentioning the names and deleting them is the way of doing.
4. The ALTER TABLE command with the ENABLE clause can be used to enable a constraint
True
To enable a constraint on a table, we should use ALTER TABLE since it is an altering operation which is getting performed on a table.