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 are the limitations oracle database 10g xe?
What happens in oracle commit?
How to delete a column in an existing table in oracle?
What is the difference between primary key and unique key and foreign key in oracle?
Is primary key indexed by default in oracle?
What exactly do quotation marks around the table name do?
What is an oracle data file?
How to loop through data rows in the implicit cursor?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is the difference between post-database commit and post-form commit?
Explain oracle’s server parameter file.
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
what is the use of system.effective.date variable in oracle?
How to create a table index in oracle?
What is an oracle user role?
