Test Your MySQL CHECK Constraint Knowledge with This Quiz

Progress

True / False

MySQL enforces the CHECK constraint in the same way it enforces the NOT NULL constraint.

True False

MySQL recognizes the CHECK constraint syntax, but it does not enforce the constraint in versions before 8.0.16.

True / False

You can use the CHECK constraint in a MySQL CREATE TABLE statement.

True False

The syntax for the CHECK constraint can be included in the CREATE TABLE statement, but it is not enforced in versions before 8.0.16.

True / False

The CHECK constraint in MySQL is used to limit the values that can be placed in a column.

True False

The purpose of the CHECK constraint is to ensure that all values in a column satisfy certain conditions.

True / False

MySQL fully supports and enforces the CHECK constraint starting from version 5.7.

True False

MySQL started enforcing the CHECK constraint from version 8.0.16 onwards, not in version 5.7.

True / False

In MySQL, the CHECK constraint can reference multiple columns in the same table.

True False

The CHECK constraint can reference more than one column in the table to enforce more complex conditions.

True / False

In MySQL, you can add a CHECK constraint to an existing table using the ALTER TABLE statement.

True False

You can add a CHECK constraint to an existing table using the ALTER TABLE statement, but enforcement of the constraint depends on the MySQL version.

True / False

In MySQL, you can create a CHECK constraint that uses subqueries.

True False

MySQL does not support subqueries in the CHECK constraint expressions.

True / False

The CHECK constraint in MySQL can be used to enforce domain integrity by ensuring that only valid domain values are entered into a column.

True False

The CHECK constraint is designed to enforce domain integrity by restricting the values that can be entered into a column based on specified criteria.

True / False

In MySQL, a CHECK constraint can reference another table to ensure referential integrity.

True False

CHECK constraints cannot reference other tables; they can only apply to the current table's columns.

Q10

True / False

As of MySQL 8.0.16, the CHECK constraint is both recognized and enforced, allowing for more robust data validation within the database.

True False

Starting with MySQL 8.0.16, the CHECK constraint is not only recognized but also enforced, providing a means for better data validation and integrity.

Q11

Single Choice

What is the primary purpose of the CHECK constraint in MySQL?

To enforce referential integrity To define default values for columns To enforce domain integrityTo index columns

The CHECK constraint is used to enforce domain integrity by limiting the values that can be placed in a column

Q12

Single Choice

Can the CHECK constraint be applied to multiple columns in a MySQL table?

Yes, it can be applied to multiple columns. No, it can only be applied to a single column. Only in specific versions of MySQL.It depends on the table structure.

The CHECK constraint can be used to validate conditions involving multiple columns.

Q13

Single Choice

Which of the following is a correct way to define a CHECK constraint in MySQL?

CHECK age > 0 CHECK (age > 0) CHECK [age > 0]CHECK {age > 0}

The correct syntax for defining a CHECK constraint in MySQL is using parentheses.

Q14

Single Choice

In MySQL, where can a CHECK constraint be defined?

Only in the CREATE TABLE statement Only in the ALTER TABLE statement Both in CREATE TABLE and ALTER TABLE statementsNone of the above

The CHECK constraint can be defined both when creating a table and when altering an existing table.

Q15

Single Choice

What happens if a value violates a CHECK constraint in MySQL?

The value is accepted but logged as a violation. The value is rejected, and an error is returned. The value is automatically corrected to meet the constraint.The table is locked for further modifications.

When a value violates a CHECK constraint, MySQL rejects the value and returns an error message

Q16

Single Choice

Can you use functions within a CHECK constraint in MySQL?

Yes, you can use any function. No, functions are not allowed. Only deterministic functions are allowed.Only aggregate functions are allowed.

Only deterministic functions, which always return the same result for the same input, are allowed in CHECK constraints.

Q17

Single Choice

How can a CHECK constraint be removed from a column in MySQL?

Using the DROP CONSTRAINT statement Using the ALTER TABLE statement with DROP CHECK Using the REMOVE CONSTRAINT statementUsing the ALTER TABLE statement with DROP CONSTRAINT

The correct way to remove a CHECK constraint is by using the ALTER TABLE statement with the DROP CONSTRAINT clause.

Q18

Single Choice

Is it possible to disable a CHECK constraint in MySQL temporarily?

Yes, using the SET CONSTRAINTS statement No, MySQL does not support disabling constraints Yes, using the ALTER TABLE statement with DISABLE CHECKYes, using the DISABLE CONSTRAINT statement

MySQL does not support temporarily disabling constraints; they must be dropped if they need to be temporarily ignored.

Q19

Single Choice

Which of the following is true about the CHECK constraint in MySQL 8.0 and later?

It is enforced by default. It is ignored by default. It is only available in MySQL Enterprise Edition.It is deprecated and should not be used.

In MySQL 8.0 and later, the CHECK constraint is enforced by default, ensuring that the constraint conditions are met.

Q20

Single Choice

In MySQL, which statement correctly adds a CHECK constraint to ensure that the salary column in the employees table is always greater than 0?

ALTER TABLE employees ADD CONSTRAINT CHECK (salary > 0); ALTER TABLE employees ADD CHECK (salary > 0); ALTER TABLE employees MODIFY CHECK (salary > 0);ALTER TABLE employees SET CHECK (salary > 0);

The correct syntax to add a CHECK constraint to an existing table in MySQL is ALTER TABLE employees ADD CHECK (salary > 0);.

Q21

Multiple Choice

Identify the correct SQL statement to create a table with a CHECK constraint ensuring that a column's value is greater than 0.

SQL Code

CREATE TABLE products (
 product_id INT PRIMARY KEY,
 price DECIMAL(10, 2),
 CHECK (price > 0)
);

CREATE TABLE products ( product_id INT PRIMARY KEY, price DECIMAL(10, 2), CHECK (price > 0) ); CREATE TABLE products ( product_id INT PRIMARY KEY, price DECIMAL(10, 2), CHECK (price >= 0) ); CREATE TABLE products ( product_id INT PRIMARY KEY, price DECIMAL(10, 2), CHECK (price IS NOT NULL) );CREATE TABLE products ( product_id INT PRIMARY KEY, price DECIMAL(10, 2), CHECK (price BETWEEN 1 AND 100) );

The CHECK constraint ensures that the price column's value must be greater than 0, preventing the insertion of invalid data.

Q22

Multiple Choice

Choose the correct SQL statement to add a CHECK constraint to an existing table ensuring a column's value is non-negative.

SQL Code

ALTER TABLE orders
ADD CHECK (quantity >= 0);

ALTER TABLE orders ADD CHECK (quantity >= 0); ALTER TABLE orders MODIFY CHECK (quantity >= 0); ALTER TABLE orders ADD CONSTRAINT CHECK (quantity >= 0);ALTER TABLE orders ADD CONSTRAINT chk_quantity CHECK (quantity >= 0);

The ALTER TABLE statement is used to add a CHECK constraint ensuring that the quantity column has a non-negative value.

Q23

Multiple Choice

Determine the correct SQL statement to enforce a CHECK constraint on a column to ensure values fall within a specific range.

SQL Code

CREATE TABLE employees (
 employee_id INT PRIMARY KEY,
 age INT,
 CHECK (age BETWEEN 18 AND 65)
);

CREATE TABLE employees ( employee_id INT PRIMARY KEY, age INT, CHECK (age BETWEEN 18 AND 65) ); CREATE TABLE employees ( employee_id INT PRIMARY KEY, age INT, CHECK (age >= 18 AND age <= 65) ); CREATE TABLE employees ( employee_id INT PRIMARY KEY, age INT, CHECK (age IS NOT NULL) );CREATE TABLE employees ( employee_id INT PRIMARY KEY, age INT, CHECK (age > 17 AND age < 66) );

The CHECK constraint on the age column ensures that all values must fall within the range of 18 to 65.

Q24

Multiple Choice

Which SQL statement correctly defines a CHECK constraint on multiple columns?

SQL Code

CREATE TABLE transactions (
 transaction_id INT PRIMARY KEY,
 amount DECIMAL(10, 2),
 transaction_type VARCHAR(10),
 CHECK (amount > 0 AND transaction_type IN ('Credit', 'Debit'))
);

CREATE TABLE transactions ( transaction_id INT PRIMARY KEY, amount DECIMAL(10, 2), transaction_type VARCHAR(10), CHECK (amount > 0 AND transaction_type IN ('Credit', 'Debit')) ); CREATE TABLE transactions ( transaction_id INT PRIMARY KEY, amount DECIMAL(10, 2), transaction_type VARCHAR(10), CHECK (amount > 0) AND CHECK (transaction_type IN ('Credit', 'Debit')) ); CREATE TABLE transactions ( transaction_id INT PRIMARY KEY, amount DECIMAL(10, 2), transaction_type VARCHAR(10), CHECK (transaction_type = 'Credit' OR transaction_type = 'Debit') );CREATE TABLE transactions ( transaction_id INT PRIMARY KEY, amount DECIMAL(10, 2), transaction_type VARCHAR(10), CHECK (amount > 0), CHECK (transaction_type IN ('Credit', 'Debit')) );

The CHECK constraint on multiple columns ensures that the amount is positive and the transaction_type is either 'Credit' or 'Debit'.

Q25

Multiple Choice

Select the correct SQL statement to drop an existing CHECK constraint from a table.

SQL Code

ALTER TABLE employees
DROP CONSTRAINT chk_age;

ALTER TABLE employees DROP CONSTRAINT chk_age; ALTER TABLE employees DROP CHECK chk_age; ALTER TABLE employees REMOVE CONSTRAINT chk_age;ALTER TABLE employees DELETE CHECK chk_age;

The DROP CONSTRAINT clause is used to remove an existing CHECK constraint from a table.

Q26

Multiple Choice

Identify the correct SQL statement to enforce a CHECK constraint ensuring a date is in the future.

SQL Code

CREATE TABLE events (
 event_id INT PRIMARY KEY,
 event_date DATE,
 CHECK (event_date > CURDATE())
);

CREATE TABLE events ( event_id INT PRIMARY KEY, event_date DATE, CHECK (event_date > CURDATE()) ); CREATE TABLE events ( event_id INT PRIMARY KEY, event_date DATE, CHECK (event_date >= CURDATE()) ); CREATE TABLE events ( event_id INT PRIMARY KEY, event_date DATE, CHECK (event_date IS NOT NULL) );CREATE TABLE events ( event_id INT PRIMARY KEY, event_date DATE, CHECK (event_date > NOW()) );

The CHECK constraint ensures that the event_date must be greater than the current date, meaning it must be in the future.

Q27

Multiple Choice

Determine the correct SQL statement to enforce a CHECK constraint ensuring a column value starts with a specific prefix.

SQL Code

CREATE TABLE departments (
 department_id INT PRIMARY KEY,
 department_code VARCHAR(10),
 CHECK (department_code LIKE 'HR%')
);

CREATE TABLE departments ( department_id INT PRIMARY KEY, department_code VARCHAR(10), CHECK (department_code LIKE 'HR%') ); CREATE TABLE departments ( department_id INT PRIMARY KEY, department_code VARCHAR(10), CHECK (department_code LIKE 'HR*') ); CREATE TABLE departments ( department_id INT PRIMARY KEY, department_code VARCHAR(10), CHECK (department_code LIKE 'HR_') );CREATE TABLE departments ( department_id INT PRIMARY KEY, department_code VARCHAR(10), CHECK (department_code LIKE '%HR') );

The CHECK constraint with the LIKE operator ensures that the department_code column value must start with the prefix 'HR'.

Q28

Multiple Choice

Which SQL statement correctly adds a CHECK constraint to ensure an integer column has only even values?

SQL Code

ALTER TABLE inventory
ADD CONSTRAINT chk_even
CHECK (stock_quantity % 2 = 0);

ALTER TABLE inventory ADD CONSTRAINT chk_even CHECK (stock_quantity % 2 = 0); ALTER TABLE inventory ADD CONSTRAINT chk_even CHECK (stock_quantity MOD 2 = 0); ALTER TABLE inventory ADD CONSTRAINT chk_even CHECK (stock_quantity IS EVEN);ALTER TABLE inventory ADD CONSTRAINT chk_even CHECK (MOD(stock_quantity, 2) = 0);

The CHECK constraint ensures that the stock_quantity column must always store even numbers.

Q29

Multiple Choice

Select the correct SQL statement to add a CHECK constraint to ensure a string column is not empty.

SQL Code

ALTER TABLE users
ADD CHECK (username <> '');

ALTER TABLE users ADD CHECK (username <> ''); ALTER TABLE users ADD CHECK (username IS NOT NULL); ALTER TABLE users ADD CHECK (LENGTH(username) > 0);ALTER TABLE users ADD CHECK (username IS NOT NULL AND username <> '');

The CHECK constraint ensures that the username column cannot have an empty string as its value.

Q30

Multiple Choice

Identify the correct SQL statement to create a table with a CHECK constraint ensuring a numeric value is within a specified range and not NULL.

SQL Code

CREATE TABLE sales (
 sale_id INT PRIMARY KEY,
 discount_percentage DECIMAL(5, 2),
 CHECK (discount_percentage BETWEEN 0 AND 50 AND discount_percentage IS NOT NULL)
);

CREATE TABLE sales ( sale_id INT PRIMARY KEY, discount_percentage DECIMAL(5, 2), CHECK (discount_percentage BETWEEN 0 AND 50 AND discount_percentage IS NOT NULL) ); CREATE TABLE sales ( sale_id INT PRIMARY KEY, discount_percentage DECIMAL(5, 2), CHECK (discount_percentage >= 0 AND discount_percentage <= 50) ); CREATE TABLE sales ( sale_id INT PRIMARY KEY, discount_percentage DECIMAL(5, 2), CHECK (discount_percentage > 0 AND discount_percentage < 50) );CREATE TABLE sales ( sale_id INT PRIMARY KEY, discount_percentage DECIMAL(5, 2), CHECK (discount_percentage > 0 AND discount_percentage <= 50) );

The CHECK constraint ensures that the discount_percentage must be within the range of 0 to 50 and cannot be NULL.

MySQL Database Quiz Questions