Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rajshri.20
SQL constraints are used to specify rules for the data in a table.
NOT NULL - Indicates that a column cannot store NULL value
UNIQUE - Ensures that each row for a column must have a unique value
PRIMARY KEY - A combination of a NOT NULL and UNIQUE. Ensures that a column (or combination of two or more columns) have an unique identity which helps to find a particular record in a table more easily and quickly
FOREIGN KEY - Ensure the referential integrity of the data in one table to match values in another table
CHECK - Ensures that the value in a column meets a specific condition
DEFAULT - Specifies a default value when specified none for this column
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to invoke the data pump export utility?
What is a read only transaction in oracle?
Explain the use of inctype option in exp command.
How to create an oracle database?
How can I combine multiple rows into a comma-delimited list in oracle?
What is oracle analytical function?
What do you mean by merge in oracle?
What is the difference between a primary key & a unique key?
various types of hints and their usage
What is the difference between postgresql and oracle?
Explain about integrity constraint?
What is Virtual Private Database in Oracle?
How to resolve name conflicts between variables and columns?
What are the various types of snapshots ?
Why packages are used in oracle?
