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
- 187832 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / priya reddy
primary key- if a column is declared as priamry then there
wont be any repeated values in that column throughout that
table, as well as it wont take any null values and we can
use primary key only once in a table. but we can declare
combination of two columns as primary key.
unique- if a column is declared as unique then again there
wont be any repeated values in that column, but this will
take null values and even we can declare more thatn one
unique column in a table.
foreign key-if a column is declared with this key then we
have to use a reference ie we need to give the column which
will have the same values as this column and the table that
column belongs to.. this referced column of other table
will be the primary key of that table.
| Is This Answer Correct ? | 379 Yes | 91 No |
Post New Answer View All Answers
What is the best database software for small businesses?
What is the difference between specialization and generalization?
How many types of locks are present in a database?
What do you mean by cluster and non cluster index?
Explain transaction manager?
What is a database call?
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
How to do Data integrity testing? Who does this testing (Developer or tester)?
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
What are indexes in oracle?
What are the types of indexes that are present inside a database?
What is the use of default key?
What are database connection details?
What is the purpose of TNS?
query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp
