Interested to Buy Any Domain ? << Click Here >> for more details...
what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 186226 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / kranthi
primary key: primary creates a clustered index on the
column and it doesn't allow null values.
unique key: unique key creates non clustered index by
default.it allows "one null value".
foreign key: A foreign key (FK) is a column or combination
of columns used to establish and enforce a link between the
data in two tables
| Is This Answer Correct ? | 212 Yes | 76 No |
Post New Answer View All Answers
What is the function of cluster index?
What is database server and how it works?
Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
What is the role of driver manager?
What is the Lock Based Protocol used for?
What are different types of resources?
What are different types of joins used in?
How many types of locks are present in a database?
can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance
Explain entity set?
Display the employees whose salary is less than average salary.
List various types of log-based recovery in DBMS.
What is a database connection string?
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
