Question

We need to ensure that the amount withdrawn should be less then the credit
card limit amount, to ensure this integrity what type constraint will be used?
Select one:
a. column level check constraint
b. table level check constraint
c. table level foreign key constraint
d. column level foreign key constraint​

Answer 1

Answer:

column level check constraint

Explanation:

because we are checking only amount column not checking about cardholder's name,cardno etc.

Answer 2

The Correct answer is

column level check constraint

To ensure that the amount withdrawn should be less then the credit

card limit amount, to ensure this integrity the type constraint will be used is

column level check constraint

column level check constraint

• It is used to meet our demands as we have to put the limit on account amount which is present in any column.

table level check constraint

• It is used to block the whole table which is not used in the purpose.
• Yes but If we have to freeze any of the account we can use table level check constraint.

table level foreign key constraint

• It is used to link two different tables in one.
• It is used to merge multiple files.

column level foreign key constraint

• It is used to link two different column in one.
• It is used to merge multiple files.