MS SQL Server - 18 - Integrity Constraints MCQ

18 – Integrity Constraints MCQ

Best of luck!

1 / 25

1. What is the primary purpose of integrity constraints in a database?

To create new tables

To enforce data accuracy and consistency

To optimize storage space

To improve query performance

2 / 25

2. In SQL Server, which type of integrity constraint ensures that all values in a column are unique within a table?

Primary Key constraint

Default constraint

Foreign Key constraint

Check constraint

3 / 25

3. What is referential integrity in the context of a database?

It ensures that data is stored efficiently.

It enforces that all values in a column are unique.

It optimizes query performance.

It maintains consistency and relationships between tables.

4 / 25

4. In SQL Server, which type of constraint is used to enforce referential integrity between two tables?

Foreign Key constraint

Unique constraint

Check constraint

Primary Key constraint

5 / 25

5. What is the purpose of a Foreign Key constraint in SQL Server?

To define a default value for a column

To allow NULL values in a column

To enforce referential integrity between tables

To specify a unique constraint for a column

6 / 25

6. In SQL Server, what happens if a Foreign Key constraint is violated?

An error is raised, and the operation is aborted.

The constraint is automatically disabled.

NULL values are inserted into the column.

The constraint is temporarily suspended.

7 / 25

7. Which SQL statement is used to create a Foreign Key constraint in SQL Server?

CREATE TABLE

CREATE FOREIGN KEY

CREATE CONSTRAINT

CREATE INDEX

8 / 25

8. What is the primary purpose of a Check constraint in SQL Server?

To enforce referential integrity between tables

To allow NULL values in a column

To define a default value for a column

To specify a condition for column values

9 / 25

9. In SQL Server, how is a Check constraint defined?

By specifying a column's data type

By setting the column as the primary key

By providing a condition for acceptable values

By assigning a default value to the column

10 / 25

10. Which SQL statement is used to create a Check constraint in SQL Server?

CREATE CONSTRAINT

CREATE CHECK

CREATE INDEX

CREATE TABLE

11 / 25

11. In SQL Server, what is the primary purpose of the Unique constraint?

To enforce data accuracy and consistency

To allow duplicate values in a column

To improve query performance

To specify a default value for a column

12 / 25

12. Which SQL statement is used to create a Unique constraint in SQL Server?

CREATE CONSTRAINT

CREATE UNIQUE

CREATE TABLE

CREATE INDEX

13 / 25

13. What is a domain in the context of database design?

A table definition

A specific set of values that a column can hold

A unique identifier for a table

A foreign key constraint

14 / 25

14. In SQL Server, how can you enforce domain integrity?

By creating a Primary Key constraint

By using the FOREIGN KEY constraint

By using the CHECK constraint with a domain-specific condition

By allowing NULL values in columns

15 / 25

15. What is the primary purpose of a Primary Key constraint in SQL Server?

To specify a default value for a column

To enforce data accuracy and consistency

To allow NULL values in a column

To improve query performance

16 / 25

16. Which SQL statement is used to create a Primary Key constraint in SQL Server?

CREATE PRIMARY KEY

CREATE TABLE

CREATE CONSTRAINT

CREATE INDEX

17 / 25

17. In SQL Server, what is the purpose of the “CASCADE” option for a Foreign Key constraint?

It disables the constraint when a violation occurs.

It automatically generates unique values for the foreign key.

It allows NULL values in the foreign key column.

It specifies that changes to the referenced key will propagate to the foreign key.

18 / 25

18. What is the role of the “NO ACTION” option for a Foreign Key constraint in SQL Server?

It allows NULL values in the foreign key column.

It automatically generates unique values for the foreign key.

It specifies that no action should be taken on a violation.

It disables the constraint when a violation occurs.

19 / 25

19. In SQL Server, what is the purpose of the “SET NULL” option for a Foreign Key constraint?

It automatically generates unique values for the foreign key.

It allows NULL values in the foreign key column.

It disables the constraint when a violation occurs.

It specifies that the foreign key should be set to NULL on a violation.

20 / 25

20. Which SQL statement is used to drop a constraint in SQL Server?

DROP TABLE

DROP CONSTRAINT

DELETE CONSTRAINT

ALTER CONSTRAINT

21 / 25

21. In SQL Server, what is the role of the “SET DEFAULT” option for a Foreign Key constraint?

It specifies a default value for the foreign key on a violation.

It allows NULL values in the foreign key column.

It disables the constraint when a violation occurs.

It automatically generates unique values for the foreign key.

22 / 25

22. What is the primary purpose of a Unique constraint in SQL Server?

To allow duplicate values in a column

To improve query performance

To specify a default value for a column

To enforce data accuracy and consistency

23 / 25

23. In SQL Server, which keyword is used to specify a default value for a column when creating a table?

DEFAULT

SET DEFAULT

DEFAULT VALUE

SET VALUE

24 / 25

24. What is the role of the “CASCADE” option for a Delete operation in SQL Server?

It allows NULL values in the foreign key column.

It automatically generates unique values for the foreign key.

It specifies that the deletion should cascade to related records.

It disables the Delete operation.

25 / 25

25. In SQL Server, how can you ensure referential integrity when a record in a parent table is deleted?

By disabling foreign key constraints

By using the "CASCADE" option for foreign key constraints

By using the "SET NULL" option for foreign key constraints

By allowing NULL values in foreign key columns

Your score is

MS SQL Server – 18 – Integrity Constraints MCQ