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
What is the maximum limit on the number of columns in a table?
What are the different types of record groups in oracle? Explain each of them
How oracle handles dead locks?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
What is difference between truncate and delete?
How can you use check constraints for self referential integrity?
How to experiment a data lock in oracle?
What is a nvl function?
What's dateware house and what's clustor with practicle example
Please explain drop constraint oracle?
How to Truncate Table in Oracle
How to see free space of each tablespace?
What is the data pump import utility?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
