Test: Integrity Constraints - Computer Science Engineering (CSE) MCQ

All phone numbers must include the area code

Certain fields are required (such as the email address, or phone number) before the record is accepted

Information on the customer must be known before anything can be sold to that customer

When entering an order quantity, the user must input a number and not some text (i.e., 12 rather than ‘a dozen’)

Create assertion ‘assertion-name’ check ‘predicate’;

Create assertion check ‘predicate’ ‘assertion-name’;

Create assertions ‘predicates’;

All of the mentioned

Delete

Delete cascade

Set null

All of the mentioned

Check(budget>0)

Check(budget<0)

Alter(budget>0)

Alter(budget<0)

Not null

Positive

Unique

Check ‘predicate’

Control who is allowed access to the data

Ensure that duplicate records are not entered into the table

Improve the quality of data entered for a specific property (i.e., table column)

Prevent users from changing the values stored in the table

Foreign key

Primary key

Assertion

Referential constraint

Foreign key

Primary key

References

Check constraint

All statements executed

Error in create statement

Error in insert into Employee values(1006,Ted,Finance, );

Error in insert into Employee values(1008,Ross,Sales,20000);

Create table

Modify table

Alter table

Drop table