Welcome to your Data Integrity

1. Data Integrity is used to restrict the invalid data into the database at the

a. Column level

b. Row level

2. How many types of constraints do we have?

a. four

b. five

3. Candidate Key are those columns eligible to become the primary key.

a. Yes

b. No

4. Not Null is a constraint at a column level that can be felt blank.

a. True

b. False

5. The foreign key will always be present on the child table.

a. True

b. False

6. The primary key will always be present on the master table.

a. True

b. False

7. Each record should be unique as rows are unique.

a. True

b. False

8. The table should not have a transitive functional dependency, (TFD)

a. True

b. False

9. In SQL every data has a datatype.

a. False

b. True

10. Boolean gives a condition either True or False.

a. False

b. True

Data Integrity