Answer Posted / Manoj Singh
A constraint in SQL and PL/SQL is a rule that is used to enforce integrity of data in a database. It ensures the validity of data by enforcing rules such as uniqueness, referential integrity, null values etc. Some common types of constraints include PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, and NOT NULL.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does group by remove duplicates?
how to use regular expression in pattern match conditions? : Sql dba
what is sql server agent? : Sql dba
What is the current version of postgresql?
If a cursor is open, how can we find in a pl/sql block?
how many tables will create when we create table, what are they? : Sql dba
What is your daily office routine?
Can delete statement be rollbacked?
what is collation? : Sql dba
Is primary key clustered index?
what are the advantages of sql ? : Sql dba
what are all the common sql function? : Sql dba
Is primary key always clustered index?
Can we rollback truncate?
Can we use distinct and group by together?
