ORACLE DATABASE INTERVIEW QUESTIONS

What is a CHECK constraint in Oracle?

How do you define a CHECK constraint when creating a table?

What happens if you try to insert a value that violates a CHECK constraint?

How can you add a CHECK constraint to an existing table?

Can you use a CHECK constraint to compare values between two columns in the same table?

How do you remove a CHECK constraint from a table?

What are some limitations of the CHECK constraint in Oracle?

How can you use a CHECK constraint to enforce a complex business rule?

What is the impact of CHECK constraints on database performance?

Explain how to use the CHECK constraint with the DECODE function to handle conditional logic?