Interested to Buy Any Domain ? << Click Here >> for more details...
What are various constraints used in SQL?
- 1 Answers
- 3852 Views
- Polaris, I also Faced
- E-Mail Answers
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 |
What are the differences between date and timestamp in oracle?
What is MTTR advisor in Oracle?
What are temporal data types in oracle?
How to sort the query output in oracle?
What are the advantages of oracle?
What is hot backup and logical backup?
What is instant client oracle?
how do u know the total no of rows in a table?
What is Database Buffers ?
How to convert character types to numeric types?
Can the default values be assigned to actual parameters?
12 RULES OF RDBMS
Oracle General 
