Define the terms primary key foreign key and also the
difference between primary and the unique key
Answer Posted / pugal
Primary Key : The primary key of a relational table
uniquely identifies each record in the table
Foreign Key : These keys are used to create relationships
between tables.
Unique Key : In relational database design, a unique key is
a candidate key to uniquely identify each row in a table. A
unique key comprises a single column or set of columns
Difference between primary and unique key :
primary key not allows null values
unique key allows null values
| Is This Answer Correct ? | 33 Yes | 12 No |
Post New Answer View All Answers
How to put more than 1000 values into an oracle in clause?
What is the difference between formal parameters and actual parameters?
Why do we need integrity constraints in a database?
What are triggers in oracle?
Explain the dml?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What types of joins are used in writing subqueries?
What are the different types of synonyms?
How to rename an existing table?
What is tns entry?
Explain a private synonyms?
Explain the difference between replace() and translate() functions in oracle?
How to connect asp pages to oracle servers?
State and explain the different types of data models?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE