what is a constraint? Tell me about its various levels. : Sql dba



what is a constraint? Tell me about its various levels. : Sql dba..

Answer / Anup Kumar Dwivedi

A constraint in SQL is a rule that ensures the integrity of data in a database. There are several types of constraints, including primary key, foreign key, unique, check, and default constraints. Primary and foreign keys ensure referential integrity, while unique and check constraints enforce specific conditions on columns.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what is switch column,colums cost in oracle?

0 Answers   Metric Stream,


how to saw triggers output in pl/sql database?

1 Answers  


Can you create a table with Primary Key not as the clustered index.

2 Answers   CGI,


Is sql free?

1 Answers  


What does where 1 1 mean in sql?

1 Answers  


what is the different between unique+not null & primary key,

4 Answers  


how many no of table can be join in a sql query.

4 Answers  


What is pl sql in oracle?

1 Answers  


What is a null value?

1 Answers  


What is nvarchar max in sql?

1 Answers  


Which sql statement is used to delete data from a database?

1 Answers  


how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?

4 Answers   TCS,


Categories