Answer Posted / Ravi Kumar Shukla
In SQL, there are three levels of constraints: table constraints, column constraints, and assertion constraints. Table constraints are defined on the entire table (such as primary key, foreign key). Column constraints are applied to individual columns (such as not null, unique). Assertion constraints define a check condition for multiple tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
If a cursor is open, how can we find in a pl/sql block?
What is your daily office routine?
Do we need to rebuild index after truncate?
what is bcp? When does it used? : Sql dba
Can we rollback truncate?
how to use regular expression in pattern match conditions? : Sql dba
What is the current version of sql?
how many tables will create when we create table, what are they? : Sql dba
how to start mysql server? : Sql dba
what are the advantages of sql ? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Is primary key always clustered index?
what is schema? : Sql dba
Is inner join faster than left join?
what are all the common sql function? : Sql dba